Re: PostgreSQL performance issues

From: Codelogic <codelogic(at)gmail(dot)com>
To: Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL performance issues
Date: 2006-08-30 00:16:36
Message-ID: 1156896996.21893.85.camel@santafe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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).

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Sullivan 2006-08-30 09:29:35 performance problems.
Previous Message Merlin Moncure 2006-08-29 23:39:57 Re: PostgreSQL performance issues