Re: [GENERAL] How to tune this query

2011-03-07 Thread Jaiswal Dhaval Sudhirkumar
mp; Regards Dhaval Jaiswal From: pgsql-general-ow...@postgresql.org on behalf of Adarsh Sharma Sent: Tue 3/8/2011 10:31 AM To: pgsql-general@postgresql.org Cc: pgsql-performa...@postgresql.org Subject: [GENERAL] How to tune this query Dear all, Can anyone Please

[GENERAL] How to tune this query

2011-03-07 Thread Adarsh Sharma
Dear all, Can anyone Please guide me with some suggestions on how to tune the below query as I needed to perform the below query as faster as i can. I have 3 tables on which the query runs: pdc_uima=# select pg_size_pretty(pg_total_relation_size('page_content_demo')); pg_size_pretty ---