Re: [PERFORM] slow result

2007-01-24 Thread Shoaib Mir
You can also try this one: ANALYZE tablename; select reltuples from pg_class where relname = 'tablename'; Will also give almost the same results I guess... - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/23/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Tue, Jan 23, 2007

Re: [PERFORM] slow result

2007-01-23 Thread Mark Kirkwood
Laurent Manchon wrote: Hi, I have a slow response of my PostgreSQL database 7.4 using this query below on a table with 80 rows: select count(*)from tbl; PostgreSQL return result in 28 sec every time. Can you post the results of: analyze verbose tbl; explain analyze select count(*) from

Re: [PERFORM] slow result

2007-01-23 Thread Bruno Wolff III
On Tue, Jan 23, 2007 at 11:34:52 +0100, Laurent Manchon <[EMAIL PROTECTED]> wrote: > Hi, > > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; > > PostgreSQL return result in 28 sec every time. > although MS-

Re: [PERFORM] slow result

2007-01-23 Thread Ron
At 07:34 AM 1/23/2007, Laurent Manchon wrote: Hi, I have a slow response of my PostgreSQL database 7.4 using this query below on a table with 80 rows: 1= Upgrade to the latest stable version of pg. That would be 8.2.x You are very much in the Dark Ages pg version wise. pg 8.x has sign

Re: [PERFORM] slow result

2007-01-23 Thread Bill Moran
In response to Laurent Manchon <[EMAIL PROTECTED]>: > > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; > > PostgreSQL return result in 28 sec every time. > although MS-SQL return result in 0.02 sec every tim

Re: [PERFORM] slow result

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 13:34:19 +0100 mailte Laurent Manchon folgendes: > Hi, > > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; PLEASE READ THE ANSWERS FOR YOUR OTHER MAILS. Andreas -- Andreas Krets

Re: [PERFORM] slow result

2007-01-23 Thread Steinar H. Gunderson
On Tue, Jan 23, 2007 at 11:55:41AM +0100, Steinar H. Gunderson wrote: > you'll find them to be much master. s/master/faster/ /* Steinar */ -- Homepage: http://www.sesse.net/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will i

Re: [PERFORM] slow result

2007-01-23 Thread Steinar H. Gunderson
On Tue, Jan 23, 2007 at 11:34:52AM +0100, Laurent Manchon wrote: > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; Contrary to your expectations, this is _not_ a query you'd expect to be fast in Postgres. Try

Re: [PERFORM] slow result

2007-01-23 Thread A. Kretschmer
am Tue, dem 23.01.2007, um 11:34:52 +0100 mailte Laurent Manchon folgendes: > Hi, > > I have a slow response of my PostgreSQL database 7.4 using this query below > on a table with 80 rows: > > select count(*)from tbl; If i remember correctly, i saw this question yesterday on an other list..

Re: [PERFORM] slow result

2007-01-23 Thread Heiko W.Rupp
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 80 rows: select count(*)from tbl; count(*) is doing a full tablescan over all your 80 rows. This is a well known "feature" of postgre