Search found 5 matches

by rishireddy.bokka
Fri Aug 11, 2017 9:23 pm
Forum: Vertica SQL
Topic: Managing Disk space by deleting the older records when the disk is 60% full
Replies: 8
Views: 3630

Re: Managing Disk space by deleting the older records when the disk is 60% full

Thanks for the reply. We have continuous flow of data in our application. so we are planning to partition based on "PARTITION BY EXTRACT(MONTH FROM eventTime)*100 + EXTRACT(DAY FROM eventTime);" where eventTime is dateTime format. Please let me know if you need more information.
by rishireddy.bokka
Thu Aug 10, 2017 4:08 pm
Forum: Vertica SQL
Topic: Managing Disk space by deleting the older records when the disk is 60% full
Replies: 8
Views: 3630

Re: Managing Disk space by deleting the older records when the disk is 60% full

Thanks for the reply. Could you please help me out how to get oldest partition in a table.
by rishireddy.bokka
Wed Aug 09, 2017 8:43 pm
Forum: Vertica SQL
Topic: Managing Disk space by deleting the older records when the disk is 60% full
Replies: 8
Views: 3630

Re: Managing Disk space by deleting the older records when the disk is 60% full

We have 6 tables and we want to delete data from all the tables appropriately.
by rishireddy.bokka
Mon Aug 07, 2017 4:26 pm
Forum: Vertica SQL
Topic: Managing Disk space by deleting the older records when the disk is 60% full
Replies: 8
Views: 3630

Managing Disk space by deleting the older records when the disk is 60% full

Hi,
I am using vertica for an application which has continuous flow of data. So I want to manage the disk space by creating a cron job which will delete the older records once the disk is 60% full. Could someone please help me to achieve the same.

Go to advanced search