Re: Performances - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Performances
Date
Msg-id 20061229030935.GC29576@alvh.no-ip.org
Whole thread Raw
In response to Performances  (Cedric BUSCHINI <cbuschini@carax.com>)
List pgsql-admin
Cedric BUSCHINI wrote:
> Hello everyone,
>
> A quick question:
> - how long does it take you to perform that query :
> "SELECT COUNT(*) FROM A_TABLE;"

Longer than I want to wait in any case.  In most cases you can rewrite
that query to something else; what that something looks like, depends on
how exact you want the result to be.  So the question to you is, what do
you want that number for?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: Performances
Next
From: Arnau
Date:
Subject: How do you upgrade for production servers?