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

Re: slow result

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Laurent Manchon <lmanchon(at)univ-montp2(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow result
Date: 2007-01-23 17:59:51
Message-ID: 20070123175951.GC20870@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jan 23, 2007 at 11:34:52 +0100,
  Laurent Manchon <lmanchon(at)univ-montp2(dot)fr> wrote:
> Hi,
> 
> 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

Responses

pgsql-performance by date

Next:From: Dave DutcherDate: 2007-01-23 22:08:47
Subject: Bad Row Count Estimate on View with 8.2
Previous:From: Subramaniam AiylamDate: 2007-01-23 16:11:11
Subject: Postgres processes have a burst of CPU usage

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