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
http://pgfouine.projects.po
"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
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
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
