From: Bruno Wolff III <bruno@wolff.to>
To: Phadnis <shphadnis@rediffmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: help needed asap....
Date: Sun, 12 Mar 2006 15:00:51 -0600
Message-ID: <20060312210051.GA32559@wolff.to> (raw)
In-Reply-To: <20060312114625.7463.qmail@webmail8.rediffmail.com>
References: <20060312114625.7463.qmail@webmail8.rediffmail.com>
On Sun, Mar 12, 2006 at 11:46:25 -0000,
Phadnis <shphadnis@rediffmail.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, shphadnis@rediffmail.com
Subject: Re: help needed asap....
In-Reply-To: <20060312210051.GA32559@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox