Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 29 Aug 2006 17:16:36 -0700
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).
- References:
- PostgreSQL performance issues
- From: Willo van der Merwe
- PostgreSQL performance issues
- Prev by Date: Re: PostgreSQL performance issues
- Next by Date: Re: PostgreSQL performance issues
- Previous by thread: Re: PostgreSQL performance issues
- Next by thread: Re: PostgreSQL performance issues
- Indexes: