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.