Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Matthew SullivanDate: 2006-08-30 09:29:35
Subject: performance problems.
Previous:From: Merlin MoncureDate: 2006-08-29 23:39:57
Subject: Re: PostgreSQL performance issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group