February 19th, 2013, 11:53 AM
Postgres partition performance questions
I've worked on partitioning a huge table(19 GB) in postgres 8.3. I use one of the column called publisher_campaign_name as constraint key. At the end, I have one parent table with 3500 child partition tables. However the execution time query like select * from PARENT_TABLE where publisher_campaign_name = '???' is in average 30 times slower than the similar query which ran on single version table with indexes. By looking at execution plan, I know constraint exclusion is on. However, I just can't get the performance that I am expected. Any idea on what went wrong?