>>> On Fri, Oct 12, 2007 at 3:41 PM, in message
<BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>, henk de wit
<henk53602@hotmail.com> wrote:
>
> I have a table with some 50 millions rows in PG 8.2. The table has indexes
> on relevant columns. My problem is that most everything I do with this table
> (which are actually very basic selects) is unbearable slow.
Do you have autovacuum turned on? With what settings?
Do you run scheduled VACUUM ANALYZE?
What does the tail of the output from your last
VACUUM ANALYZE VERBOSE look like?
-Kevin