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

Re: slow result

From: "Heiko W(dot)Rupp" <heiko(dot)rupp(at)redhat(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow result
Date: 2007-01-23 10:43:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Am 23.01.2007 um 11:34 schrieb Laurent Manchon:

> 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;

count(*) is doing a full tablescan over all your 800000 rows. This is  
a well known "feature"
of postgres :-/

So enhancing the performance is currently only possible by having  
faster disk drives.
Heiko W.Rupp

In response to

  • slow result at 2007-01-23 10:34:52 from Laurent Manchon

pgsql-performance by date

Next:From: A. KretschmerDate: 2007-01-23 10:53:35
Subject: Re: slow result
Previous:From: Laurent ManchonDate: 2007-01-23 10:34:52
Subject: slow result

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