On Tue, Jan 23, 2007 at 11:34:52 +0100,
Laurent Manchon <lmanchon(at)univ-montp2(dot)fr> wrote:
> I have a slow response of my PostgreSQL database 7.4 using this query below
> on a table with 800000 rows:
> select count(*)from tbl;
> PostgreSQL return result in 28 sec every time.
> although MS-SQL return result in 0.02 sec every time.
Besides the other advice mentioned in this thread, check that you don't
have a lot of dead tuples in that table. 28 seconds seems a bit high
for even a sequential scan of 800000 tuples unless they are pretty large.
In response to
- slow result at 2007-01-23 10:34:52 from Laurent Manchon
pgsql-performance by date
|Next:||From: Dave Dutcher||Date: 2007-01-23 22:08:47|
|Subject: Bad Row Count Estimate on View with 8.2|
|Previous:||From: Subramaniam Aiylam||Date: 2007-01-23 16:11:11|
|Subject: Postgres processes have a burst of CPU usage|