Re: [GENERAL] Index space growing even after cleanup via autovacuum in Postgres 9.2

2014-01-15 Thread Tirthankar Barari
On 01/13/2014 01:38 PM, Francisco Olarte wrote: Hi: On Mon, Jan 13, 2014 at 5:26 PM, Tirthankar Barari tbar...@verizon.com wrote: On 01/10/2014 07:06 AM, Francisco Olarte wrote: Not related to your vacuum problem, but if your pattern is something like deleting everything inserted 15 days ago

Re: [GENERAL] Index space growing even after cleanup via autovacuum in Postgres 9.2

2014-01-13 Thread Tirthankar Barari
On 01/10/2014 07:06 AM, Francisco Olarte wrote: Hi: On Thu, Jan 9, 2014 at 7:50 PM, Tirthankar Barari tbar...@verizon.com wrote: We have a table where we insert about 10 million rows everyday. We keep 14 day's worth of entries (i.e. 140 mil). A scheduled task wakes up every day and deletes all

[GENERAL] Index space growing even after cleanup via autovacuum in Postgres 9.2

2014-01-09 Thread Tirthankar Barari
Hi, We have a table where we insert about 10 million rows everyday. We keep 14 day's worth of entries (i.e. 140 mil). A scheduled task wakes up every day and deletes all entries past the 14 day window (i.e. deletes entries from the 15th day in the past). We have autovacuum set to trigger