Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [ADMIN] Performances
- 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: [ADMIN] Performances
- Date: Fri, 29 Dec 2006 00:09:35 -0300
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
- References:
- Performances
- From: Cedric BUSCHINI
- Performances
- Prev by Date: Re: [ADMIN] Performances
- Next by Date: upgrading from 7.3.5 to 8.1.5
- Previous by thread: Re: [ADMIN] Performances
- Next by thread: upgrading from 7.3.5 to 8.1.5
- Indexes: