Re: Bad query plans for queries on partitioned table

From: Julian Mehnle <julian(at)mehnle(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad query plans for queries on partitioned table
Date: 2007-12-04 20:03:14
Message-ID: 200712042003.14121.julian@mehnle.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Julian Mehnle wrote:
> I have a large database with e-mail meta-data (no bodies) for over 100
> million messages. I am running PostgreSQL 8.2.4 on a server with 2GB
> of RAM (shared_buffers = 240MB, temp_buffers = 128MB, work_mem = 256MB,
> maintenance_work_mem = 256MB). I have the data split in two separate
> tables, "email" and "email_extras":
> [...]
>
> Each of these tables has been partitioned equally based on the "ts"
> (timestamp) field into two dozen or so tables, each covering one week
> of messages. For testing purposes, I have only one week's partition
> filled for each of the "email" and "email_extras" tables
> (email_2007_week34 {,extras}).

Oh, just for the record: I do have "constraint_exclusion" enabled.

Julian.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message James Mansion 2007-12-04 20:14:22 Re: RAID arrays and performance
Previous Message Julian Mehnle 2007-12-04 19:44:08 Bad query plans for queries on partitioned table