Search found 23 matches

by sramdram
Tue Sep 24, 2013 8:03 pm
Forum: Vertica Database Administration
Topic: Drop partition fails with Error
Replies: 5
Views: 4984

Re: Drop partition fails with Error

Thanks, I'll try this
by sramdram
Tue Sep 24, 2013 7:12 pm
Forum: Vertica Database Administration
Topic: Drop partition fails with Error
Replies: 5
Views: 4984

Re: Drop partition fails with Error

select drop_partition('tablename')
by sramdram
Tue Sep 24, 2013 3:35 pm
Forum: Vertica Database Administration
Topic: Drop partition fails with Error
Replies: 5
Views: 4984

Drop partition fails with Error

I get this error often while dropping partitions ERROR 2083: A Moveout operation is already in progress on projection XXX Is there a command to drop partitions which incorporates a "wait" till the moveout is done? Dropping partitions is critical as space usage needs to be reclaimed. This requires sc...
by sramdram
Mon Aug 12, 2013 4:30 pm
Forum: Vertica Performance Tuning
Topic: Partition Pruning on Date Columns Gotcha
Replies: 5
Views: 7805

Re: Partition Pruning on Date Columns Gotcha

I dont agree

Try purging a day's worth of 2 billion log entries on a daily basis without partitions.

You have to partition by date to have a smooth way to purge historical data.
by sramdram
Sat Aug 10, 2013 7:59 pm
Forum: Vertica Performance Tuning
Topic: Partition Pruning on Date Columns Gotcha
Replies: 5
Views: 7805

Partition Pruning on Date Columns Gotcha

If I create a table with a partition like partition by date_trunc('day',dt) where dt is a timestamp columns... then queries like where dt >= date_trunc('day',current_timestamp) will be slower than dt >= date_trunc('day',current_timestamp::timestamp) This is also true for postgres...I would expect th...
by sramdram
Sat Aug 10, 2013 6:43 pm
Forum: New to Vertica Database Administration
Topic: Column Sort Order
Replies: 5
Views: 5099

Column Sort Order

If i create a projection with a sort order like

order by col1,col2,col3

what does that translate to from a storage perspective...

Does it mean that col1,col2 and col3 are independently stored sorted ? Is there any collocation of rows based on this column ordering
by sramdram
Sun Aug 04, 2013 4:22 pm
Forum: Vertica Database Administration
Topic: Disk/CPU/Memory Usage
Replies: 1
Views: 3605

Disk/CPU/Memory Usage

Is there a way to see how a query performs with respect to IO calls made / Cache hits / Memory Used / Network Wait

I understand that the Web Admin Interface has a graphical component that does something similar. I am looking for an accurate profile of resource usage by a query

Go to advanced search