| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Syed Asif Tanveer <asif(dot)tanveer(at)analytics(dot)com(dot)pk> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres configuration for 8 CPUs, 6 GB RAM |
| Date: | 2012-11-27 19:53:45 |
| Message-ID: | CAOR=d=0fb+jRtjCeTn6sS28DSU6ogTppfCk3U6cX-fNXMWFLXQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Nov 27, 2012 at 12:47 AM, Syed Asif Tanveer
<asif(dot)tanveer(at)analytics(dot)com(dot)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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Blackwell | 2012-11-27 22:04:42 | Savepoints in transactions for speed? |
| Previous Message | Andrew Dunstan | 2012-11-27 13:56:12 | Re: Postgres configuration for 8 CPUs, 6 GB RAM |