Re: partition pruning doesn't work with IS NULL clause in multikey range partition case

2018-07-11 Thread Amit Langote
On 2018/07/12 14:32, Amit Langote wrote: > Thanks Ashutosh for reporting and Dilip for the analysis and the patch. > > On 2018/07/11 21:39, Dilip Kumar wrote: >> On Wed, Jul 11, 2018 at 5:36 PM, amul sul wrote: >>> On Wed, Jul 11, 2018 at 5:10 PM Dilip Kumar wrote: >> >>> I am not sure that

Re: partition pruning doesn't work with IS NULL clause in multikey range partition case

2018-07-11 Thread Dilip Kumar
On Thu, Jul 12, 2018 at 11:10 AM, Amit Langote wrote: > On 2018/07/12 14:32, Amit Langote wrote: >> Thanks Ashutosh for reporting and Dilip for the analysis and the patch. >> >> I think your fix is correct. I slightly modified it along with updating >> nearby comments and added regression tests.

Re: Temporary WAL segments files not cleaned up after an instance crash

2018-07-11 Thread Yugo Nagata
On Mon, 14 May 2018 14:49:55 +0900 Michael Paquier wrote: > Hi all, > > While playing with a standby as follows I noticed that xlogtemp.* > generated in pg_wal may stay around when entering crash recovery. The > test I was conducting is pretty simple: > - Use a primary and a standby. > - Run pg

Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX

2018-07-11 Thread Yugo Nagata
On Tue, 10 Jul 2018 20:37:49 +0400 Andrey Borodin wrote: > Hi! > > > 10 июля 2018 г., в 17:54, Tom Lane написал(а): > > > > Aditya Toshniwal writes: > >> I am working on a feature to support INCLUDE clause of index in PG-11. As > >> per the documentation https://www.postgresql.org/docs/11/sta

<    1   2