| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Robert Klaus <robert(dot)klaus(dot)07(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Are partitions getting pruned? |
| Date: | 2013-04-08 19:47:10 |
| Message-ID: | CAMkU=1w4KnC1eotHPAjmYi0U0cpx3BMBO=ELOT+Vjzdspq1R_g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Apr 8, 2013 at 11:11 AM, Robert Klaus <robert(dot)klaus(dot)07(at)gmail(dot)com>wrote:
> Postgres 8.4.9 on CentOS
>
>
>
> I partitioned some tables over the weekend by month using a date field as
> the partitioning column. Table inheritance was used and all indexes on
> the parent were created on the partitions. constraint_exclustion =
> partition.
>
>
>
> My question is, are partitions really getting pruned or are locks showing
> up just due to inheritance.
>
In order to know that a partition can be pruned, you have to know what the
check constraint on it is. In order to know that, you have to lock the
table so that the constraint can't change while you look at it. So you
could say that it is just due to inheritance.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Kerr | 2013-04-08 19:58:58 | AWS and postgres issues |
| Previous Message | Martijn van Oosterhout | 2013-04-08 18:41:57 | Re: procedure to contribute this community |