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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
