From: | Darcy Buskermolen <darcyb(at)commandprompt(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: misbehaving planer? |
Date: | 2006-10-20 15:55:36 |
Message-ID: | 200610200855.36440.darcyb@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Friday 20 October 2006 08:26, Tom Lane wrote:
> Darcy Buskermolen <darcyb(at)commandprompt(dot)com> writes:
> > I have a setup in which a table has been partitioned into 30 partitions
> > on type (1 -30), however no matter what I do i can't make the planner try
> > to use constraint exclusion on it.
>
> Do you have constraint_exclusion turned on? What are the check
> constraints on the other children of tbl_ps?
Yes CE is on (you can see it in the session paste). The other child tables
have simular CHECK's of type=2, type=3, type=4 and so on.. 1 for each of the
30 tables.
> This example doesn't
> really show whether the planner is misbehaving or not.
>
> The multiple-partial-index setup on tbl_ps_type_1 looks pretty silly to
> me... it seems unlikely to buy anything except extra planning overhead.
This was a direct port from a big fat table. I agree, I'm not convinced that
the partial indexes will buy me much, but this box is so IO bound that the
planner overhead my just offset the needing to IO bigger indexes.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-10-20 16:27:33 | Re: misbehaving planer? |
Previous Message | Zeugswetter Andreas ADI SD | 2006-10-20 15:37:48 | Re: [SPAM?] Re: Asynchronous I/O Support |