Re: Need help in setting optimal configuration for a huge database.

Kishore B <kishorebh@gmail.com> writes:
> Even a basic query like select count(*) from bigger_table is
> taking about 4 minutes to return.

You do realize that "select count(*)" requires a full table scan in
Postgres?  It's never going to be fast.

If that's not where your performance problem really is, you need to
show us some of the actual problem queries.  If it is, you should
rethink why your application needs an exact row count.

            regards, tom lane