| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Cedric BUSCHINI <cbuschini(at)carax(dot)com> |
| Cc: | Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Performances |
| Date: | 2006-12-29 03:09:35 |
| Message-ID: | 20061229030935.GC29576@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnau | 2006-12-29 12:06:59 | How do you upgrade for production servers? |
| Previous Message | Bricklen Anderson | 2006-12-28 17:17:51 | Re: Performances |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2006-12-30 23:04:56 | upgrading from 7.3.5 to 8.1.5 |
| Previous Message | Bricklen Anderson | 2006-12-28 17:17:51 | Re: Performances |