Request a Demo
Home   >   mailing lists

Re: Some optimizations for COALESCE expressions during constant folding - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Some optimizations for COALESCE expressions during constant folding
Date
Msg-id CAMbWs49VoRxj3Gm=Wqt1EdEDz6OGgOuVqvAxhKGcUUv2PwE-vA@mail.gmail.com
Whole thread Raw
In response to Re: Some optimizations for COALESCE expressions during constant folding  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view 
Attached is the patch set rebased on current master.  I have split the
patch into two parts: 0001 teaches eval_const_expressions to simplify
COALESCE arguments using NOT NULL constraints, and 0002 teaches
expr_is_nonnullable to handle COALESCE expressions.

In addition, 0003 is a WIP patch that extends expr_is_nonnullable to
handle more expression types.  I suspect there are additional cases
beyond those covered in this patch that can be proven non-nullable.

- Richard
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: missing PG_IO_ALIGN_SIZE uses
Next
From: Michael Banck
Date:
Subject: Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer