Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL performance issues - Mailing list pgsql-performance

From Codelogic
Subject Re: PostgreSQL performance issues
Date
Msg-id 1156896996.21893.85.camel@santafe
Whole thread Raw
In response to PostgreSQL performance issues  (Willo van der Merwe <willo@studentvillage.co.za>)
List pgsql-performance
Tree view 
On Tue, 2006-08-29 at 15:52 +0200, Willo van der Merwe wrote:
> (cost=0.00..51848.56 rows=1309356 width=0)

It is going through way more number of rows than what is returned by the
count(*).

It appears that you need to VACUUM the table (not VACUUM ANALYZE).

pgsql-performance by date:

Previous
From: Rusty Conover
Date:
Subject: Re: PostgreSQL performance issues
Next
From: "Merlin Moncure"
Date:
Subject: Re: PostgreSQL performance issues