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 reltup

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