Re: Postgres configuration for 8 CPUs, 6 GB RAM

On Tue, Nov 27, 2012 at 12:47 AM, Syed Asif Tanveer
<asif.tanveer@analytics.com.pk> wrote:
> Hi,
>
>
>
> I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes. Data size
> is around 100 GB and I have tuned my PostgreSQL accordingly still I am
> facing performance issues. The query performance is too low despite tables
> being properly indexed and are vacuumed and analyzed at regular basis. CPU
> usage never exceeded 15% even at peak usage times. Kindly guide me through
> if there are any mistakes in setting configuration parameters. Below are my
> system specs and please find attached my postgresql configuration parameters
> for current system.
>

I notice that you've got autovac nap time of 60 minutes, so it's
possible you've managed to bloat your tables a fair bit.  What do you
get running the queries from this page:

http://wiki.postgresql.org/wiki/Show_database_bloat