Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kishore B <kishorebh(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help in setting optimal configuration for a huge database.
Date: 2005-10-22 22:15:43
Message-ID: 3994.1130019343@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
Kishore B <kishorebh(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Kishore BDate: 2005-10-23 02:05:50
Subject: Re: Need help in setting optimal configuration for a huge database.
Previous:From: Karl O. PincDate: 2005-10-22 22:03:03
Subject: Re: Need help in setting optimal configuration for a huge

pgsql-admin by date

Next:From: Kishore BDate: 2005-10-23 02:05:50
Subject: Re: Need help in setting optimal configuration for a huge database.
Previous:From: Kirby UbbenDate: 2005-10-22 22:04:19
Subject: Pgpool errors: pgpool 2.6.4 postgres 7.3.10 ProcessFrontendResponse: failed to read kind from frontend. fronend abnormally exited

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group