From: Julian Mehnle <julian@mehnle.net>
To: pgsql-performance@postgresql.org
Subject: Re: Bad query plans for queries on partitioned table
Date: Tue, 4 Dec 2007 20:03:14 +0000
Message-ID: <200712042003.14121.julian@mehnle.net> (raw)
In-Reply-To: <200712041944.13543.julian@mehnle.net>
References: <200712041944.13543.julian@mehnle.net>
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.
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: julian@mehnle.net
Subject: Re: Bad query plans for queries on partitioned table
In-Reply-To: <200712042003.14121.julian@mehnle.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox