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
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
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
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
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