Postgres Pro
Downloads
Home   >   mailing lists

RE: Problem with default partition pruning - Mailing list pgsql-hackers

From Yuzuko Hosoya
Subject RE: Problem with default partition pruning
Date
Msg-id 008f01d4e911$39aa87a0$acff96e0$@lab.ntt.co.jp
Whole thread Raw
In response to Re: Problem with default partition pruning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Problem with default partition pruning
List pgsql-hackers
Tree view 
Hi,

> Maybe we should have two patches as we seem to be improving two things:
> 
> 1. Patch to fix problems with default partition pruning originally reported by Hosoya-san
> 
> 2. Patch to determine if a given clause contradicts a sub-partitioned table's partition constraint,
> fixing problems unearthed by Thibaut's tests

I attached the latest patches according to Amit comment.
v3_default_partition_pruning.patch fixes default partition pruning problems
and ignore_contradictory_where_clauses_at_partprune_step.patch fixes
sub-partition problems Thibaut tested.

Best regards,
Yuzuko Hosoya
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Checksum errors in pg_stat_database
Next
From: Julien Rouhaud
Date:
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)