Search found 49 matches

by Brett
Wed Mar 04, 2015 3:28 pm
Forum: Vertica Database Administration
Topic: TxtIndex schema?
Replies: 1
Views: 5825

TxtIndex schema?

What is the TxtIndex schema in Vertica 7.1.1? dbadmin=> \dn List of schemas Name | Owner | Comment ------------+---------+--------- v_internal | dbadmin | v_catalog | dbadmin | v_monitor | dbadmin | public | dbadmin | TxtIndex | dbadmin | test | dbadmin | (6 rows)
by Brett
Fri Feb 06, 2015 3:15 am
Forum: Vertica Administration Tools
Topic: LDAP authentication for the dbadmin user
Replies: 0
Views: 12892

LDAP authentication for the dbadmin user

Hi,

Is there a way to use LDAP authorization for the dbadmin user so that I can successfully run admintools? When I try to do this some features in admintools do not work.
by Brett
Mon Dec 01, 2014 3:35 am
Forum: Vertica Data Load
Topic: Can I tune a COPY statement that uses the AUTO option?
Replies: 0
Views: 11826

Can I tune a COPY statement that uses the AUTO option?

Hi all, Is there a way that I can get faster load times when using the COPY command that invokes the AUTO option? I am using Informatica to load data into Vertica. When Informatica generates COPY command in Vertica they use the AUTO option and I have no way of specifying the DIRECT option in the ver...
by Brett
Mon Dec 01, 2014 3:13 am
Forum: New to Vertica Database Administration
Topic: Unable to reserve memory (X K) for the WOS
Replies: 1
Views: 5414

Unable to reserve memory (X K) for the WOS

Hi all,

I am getting a lot of messages like "Unable to reserve memory (17 K) for the WOS" in the error_messages system table.

Can someone explain why I might be seeing these and if there is a way to fix the issue (if it is an issue)?

Thank you.
by Brett
Fri Oct 31, 2014 8:36 pm
Forum: Vertica SQL Functions
Topic: now() <> sysdate
Replies: 6
Views: 27093

Re: now() <> sysdate

I was running the query in vsql. Odd, now when I run it today, it seems ok: [vertica@prod01 ~]$ vsql Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit vertica=> select now(), sysd...
by Brett
Thu Oct 30, 2014 10:50 pm
Forum: Vertica Database Administration
Topic: Estimate catalog size
Replies: 1
Views: 5086

Re: Estimate catalog size

I already asked that question :D

viewtopic.php?f=5&t=1952&p=6525
by Brett
Thu Oct 30, 2014 10:21 pm
Forum: Vertica SQL Functions
Topic: now() <> sysdate
Replies: 6
Views: 27093

Re: now() <> sysdate

Thanks, Norbert!

However, why would the minutes and seconds be different? I don't think the timezone affects those quantities.

Go to advanced search