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
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
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-
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
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
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
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
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
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..
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
10 matches
Mail list logo