ten should I run autovacuum?
>
>
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, July 23, 2006 11:48 AM
> > To: Peter Eisentraut
> > Cc: pgsql-admin@postgresql.org; Benjamin Krajmalnik
> > Subject: Re: [ADMIN] Unexplained
t: Sunday, July 23, 2006 11:48 AM
> To: Peter Eisentraut
> Cc: pgsql-admin@postgresql.org; Benjamin Krajmalnik
> Subject: Re: [ADMIN] Unexplained growth of tables
>
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Benjamin Krajmalnik wrote:
> >> What can be cau
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Benjamin Krajmalnik wrote:
>> What can be causing this growth? Not vacuuming often enough?
> The is exactly the reason.
>> I hav
>> pg_autovacuum running every 60 seconds. These tables have 10-15
>> insert/update statements per second.
> You shoul
After a long battle with technology, [EMAIL PROTECTED] ("Benjamin Krajmalnik"),
an earthling, wrote:
> Any assistance or guidance will be deeply appreciated. I am pulling
> hairs on this one.
It needs to be vacuumed a lot more aggressively. If you're using
pg_autovacuum, the defaults seem to be
Hi,
On Sun, 23 Jul 2006, Benjamin Krajmalnik wrote:
The actual number of physical rows in this table is 3404. Row width is
361. Table size = 639 MB.
What can be causing this growth? Not vacuuming often enough? I hav
pg_autovacuum running every 60 seconds. These tables have 10-15
insert/upda
Benjamin Krajmalnik wrote:
> What can be causing this growth? Not vacuuming often enough?
The is exactly the reason.
> I hav
> pg_autovacuum running every 60 seconds. These tables have 10-15
> insert/update statements per second.
You should probably run VACUUM FULL to get the table back to a
This is subsequent to the previous issue which I am expperiencing.
In my monitoring application, I have a few tables which contain few rows
but are constantly pounded with updates.
These tables are growing at very high rates. For example, a table with
less than 4K rows, which when reloaded was ab