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

Performances

From: Cedric BUSCHINI <cbuschini(at)carax(dot)com>
To: Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org>,pgsql-admin(at)postgresql(dot)org
Subject: Performances
Date: 2006-12-28 09:59:39
Message-ID: 4593958B.1040601@carax.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
Hello everyone,

A quick question:
- how long does it take you to perform that query :
"SELECT COUNT(*) FROM A_TABLE;"

There are like 56113000 rows in the table.

Thanks

Cedric

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2006-12-28 10:48:33
Subject: Re: Performances
Previous:From: Richard Broersma JrDate: 2006-12-27 18:34:01
Subject: pg_dump using MS-DOS BAT file

pgsql-admin by date

Next:From: A. KretschmerDate: 2006-12-28 10:48:33
Subject: Re: Performances
Previous:From: Simon RiggsDate: 2006-12-28 09:51:27
Subject: Re: Trigger trouble

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