Postgres Pro
Downloads
Home   >   mailing lists

Re: index's relpages after table analyzed - Mailing list pgsql-performance

From Josh Berkus
Subject Re: index's relpages after table analyzed
Date
Msg-id 200405241205.26170.josh@agliodbs.com
Whole thread Raw
In response to index's relpages after table analyzed  (Litao Wu <litaowu@yahoo.com>)
Responses Re: index's relpages after table analyzed  (Litao Wu <litaowu@yahoo.com>)
List pgsql-performance
Tree view 
Litao,

> 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.
ANALYZE <table-name>;

> My PG version is 7.3.2.

I would suggest upgrading to 7.3.6; the version you are using has several
known bugs.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Litao Wu
Date:
Subject: Re: index's relpages after table analyzed
Next
From: Josh Berkus
Date:
Subject: Re: Avoiding vacuum full on an UPDATE-heavy table