Review for EXPLAIN and nfiltered

From: Marc Cousin <cousinmarc(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org <pgsql-hackers(at)postgresql(dot)org>
Cc: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
Subject: Review for EXPLAIN and nfiltered
Date: 2011-09-19 16:51:38
Message-ID: 20110919185138.47863f9a@marco-dalibo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Here is my review for EXPLAIN and nfiltered

- Is the patch in context diff format?
It's in git diff format

- Does it apply cleanly to the current git master?

- Does it include reasonable tests, necessary doc patches, etc?
I think so.

Comments in execnodes.h are not updated with new fields
(ss_qualnremoved and others). They are commented directly in the
definition. Very minor, comments should just be moved around.

I have the same problem as explained in the original mail finding
an appropriate place in the documentation.
It could be added on EXPLAIN's page, but that would mean changing the
example statement for one with a filter.

- Does the patch actually implement that?

- Do we want that?
I'd like to have that. It makes it easier to determine if an index is
selective enough. Some people might prefer having it through an option
of EXPLAIN (such as EXPLAIN (filters on) ), I don't really know.

- Do we already have it?

- Does it follow SQL spec, or the community-agreed behavior?
Nothing about this in the SQL spec, obviously, and I didn't see anyone
disagreeing with the proposal.

- Does it include pg_dump support (if applicable)?
Not applicable

- Are there dangers?
Not that I think of

- Have all the bases been covered?
Yes, I think so.

- Does the feature work as advertised?

- Are there corner cases the author has failed to consider?
I didn't find any

- Are there any assertion failures or crashes?

- Does the patch slow down simple tests?

- If it claims to improve performance, does it?
Not applicable

- Does it slow down other things?

- Does it follow the project coding guidelines?

- Are there portability issues?

- Will it work on Windows/BSD etc?

- Are the comments sufficient and accurate?
Yes, except for the minor inconsistancy in execnodes.h

- Does it do what it says, correctly?

- Does it produce compiler warnings?

- Can you make it crash?

- Is everything done in a way that fits together coherently with other

- Are there interdependencies that can cause problems?
Not that I can see


Browse pgsql-hackers by date

  From Date Subject
Next Message Vitor Reus 2011-09-19 17:11:18 Re: CUDA Sorting
Previous Message Jeff Davis 2011-09-19 16:48:42 Re: Range Types - typo + NULL string constructor