Nimesh Satam wrote:
> Following is the full plan of the query using partition. Let me know if you
> need any further information.
What indexes are there on the table partitions? You didn't post the
query, but it looks like your doing a join between rpt_network and the
partitioned table. An index on the join key might help...
In response to
pgsql-performance by date
|Next:||From: Sami Dalouche||Date: 2007-10-28 21:25:10|
|Subject: Outer joins and Seq scans|
|Previous:||From: Simon Riggs||Date: 2007-10-28 17:27:24|
|Subject: Re: partitioned table and ORDER BY indexed_fieldDESCLIMIT 1|