Re: [PERFORM] Newbie question: ultra fast count(*)

2005-11-28 Thread Merlin Moncure
I have been reading all this technical talk about costs and such that I don't (_yet_) understand. Now I'm scared... what's the fastest way to do an equivalent of count(*) on a table to know how many items it has? Make sure to analyze the database frequently and check pg_class for reltuples

[PERFORM] Newbie question: ultra fast count(*)

2005-11-25 Thread Rodrigo Madera
I have been reading all this technical talk about costs and such that I don't (_yet_) understand. Now I'm scared... what's the fastest way to do an equivalent of count(*) on a table to know how many items it has? Thanks, Rodrigo ---(end of

Re: [PERFORM] Newbie question: ultra fast count(*)

2005-11-25 Thread Jaime Casanova
On 11/25/05, Rodrigo Madera [EMAIL PROTECTED] wrote: I have been reading all this technical talk about costs and such that I don't (_yet_) understand. Now I'm scared... what's the fastest way to do an equivalent of count(*) on a table to know how many items it has? Thanks, Rodrigo you