On Tue, Nov 27, 2012 at 12:47 AM, Syed Asif Tanveer <asif.tanveer@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
