[PERFORM] help needed asap....

2006-03-12 Thread Phadnis
Hi. I am new to postgres and i need help from u.i hope i get positive response.. though my questions mite seem silly to u... iam working on postgres.. i have around 1 lakh records in almost 12 tables.. 1 ) when i try to query for count or for any thg it takes a long time to return the result.

Re: [PERFORM] help needed asap....

2006-03-12 Thread Bruno Wolff III
On Sun, Mar 12, 2006 at 11:46:25 -, Phadnis [EMAIL PROTECTED] wrote:   1 ) when i try to query for count or for any thg it takes a long time to return the result. How to avoid this Postgres doesn't cache counts, so if you are counting a lot of records, this may take a while to run. If