On Sun, Mar 12, 2006 at 11:46:25 -0000,
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 you do a lot of counts or need them to be fast
even if it slows other things down, there are some things you can do to address
this. Several strategies have been repeatedly discussed in the archives.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
