> I have some tables and there are almost only
> inserts. So I do not care about the "dead tuples",
> but do care about the statistics.
Then just run ANALYZE on those tables, and not VACUUM.
> My PG version is 7.3.2.
I would suggest upgrading to 7.3.6; the version you are using has several
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-05-24 19:08:50|
|Subject: Re: Avoiding vacuum full on an UPDATE-heavy table|
|Previous:||From: Litao Wu||Date: 2004-05-24 17:20:56|
|Subject: Re: index's relpages after table analyzed|