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.

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

2006-03-12 Thread Matthew Nuzum
On 12 Mar 2006 11:46:25 -, Phadnis <[EMAIL PROTECTED]> wrote: > 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 t

[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.