Yes, but... does postgres maintain some statistics that could be queried
to determine whether vacuuming would be helpful? For Case 1 I would need
to know how many records were added since the last vacuum relative to the
total number of records in each table. For case 2 I guess you really only
nee
On Tue, 28 Jul 1998, Chris Johnson wrote:
>
> OK, so there's been quite a bit of traffic about vacuuming databases as
> well as more than one suggestion on how to do it. But there really hasn't
> been an answer to the question of how to know when to vacuum.
>
> I now vacuum the databases every
OK, so there's been quite a bit of traffic about vacuuming databases as
well as more than one suggestion on how to do it. But there really hasn't
been an answer to the question of how to know when to vacuum.
I now vacuum the databases every night, but this seems somewhat
inefficient... I know t
