Re: [GENERAL] Vacuum issue

2007-07-10 Thread Dimitri Fontaine
Le lundi 09 juillet 2007, Gregory Stark a écrit :0 The output of vacuum verbose can be hard to interpret, if you want help adjusting the fsm settings send it here. Using pgfouine, one gets easy to read reports: http://pgfouine.projects.postgresql.org/vacuum.html

[GENERAL] Vacuum issue

2007-07-09 Thread E.J. Moloney
I have a database with a table that adds 3 records a day, I am delete records older than 2 days. I am vacuuming it once a day , I am having an issue that the disk usage is continually rising. i.e. the space been flagged as free by the vacuum process isn't being reused. Please find below a

Re: [GENERAL] Vacuum issue

2007-07-09 Thread Gregory Stark
E.J. Moloney [EMAIL PROTECTED] writes: I have a database with a table that adds 3 records a day, I am delete records older than 2 days. I am vacuuming it once a day , I am having an issue that the disk usage is continually rising. i.e. the space been flagged as free by the vacuum process

[GENERAL] Vacuum issue

2007-07-05 Thread E.J. Moloney
I have a database with a table that adds 3 records a day, I am delete records older than 2 days. I am vacuuming it once a day , I am having an issue that the disk usage is continually rising. i.e. the space been flagged as free by the vacuum process isn't being reused. Please find below a

Re: [GENERAL] Vacuum issue

2007-07-05 Thread Michael Fuhr
On Thu, Jul 05, 2007 at 01:17:13PM +0100, E.J. Moloney wrote: I have a database with a table that adds 3 records a day, I am delete records older than 2 days. I am vacuuming it once a day , I am having an issue that the disk usage is continually rising. i.e. the space been flagged as