On 2015-04-30 08:39:45 -0400, Peter Eisentraut wrote:
> If you have spare cycles, there are a number of relevant patches still
> open in the commit fest.

I was wondering what the actual state of the commitfest is. I'm thus
going through all the open items. Here's my thoughts:


* fsync $PGDATA recursively at startup
  Bugfix, i.e. not really tied to CF

* EvalPlanQual behaves oddly for FDW queries involving system columns
  Tom wants to take care of it next week.
  => Keep in 'ready for committer'

* Do not vacuum pgbench tables if they do not exist when pgbench -f given
  Robert was recently sending an iteration of a patch, so I think this
  is being taken care of.
  => Keep in 'ready for committer'

* Multivariate statistics
  This is not intended to be committed this CF.
  => I'd like to mark this as returned with (little) feedback.

* fastbloat
  Not too big, I think it should be easy to commit this.
  => Keep in 'ready for committer'

* Avoiding plan disasters with LIMIT
  I'm not enthused by the approach, it's disabled by default though. So
  it might not be too bad to just do it. Would probably have been a good
  idea to discuss the patch in a separate thread.
  => ?

* Turning off HOT for larger SQL queries
  Seems to have degenerated into a discussion of not really related
  things. I personally would vote for committing something close to what
  Simon proposed last *directly at the beginning* of the next cycle.
  => Move?

* BRIN inclusion operator class
  This seems to be a mishmash of bugfix and feature. The bugfixes should
  be applied pdq...
  => ?
* Async execution of postgres_fdw.

  Later iterations of the patch haven't gotten much review yet. The
  original version of the patch is just from 2014-12-15.
  => Should imo be moved to the next CF

* PageRepairFragmentation optimization
  Hm. Heikki hasn't replied recently. It's a committer's patch though,
  so it probably doesn't matter that much.
  => Move?

* Abbreviated key support for Datum sorts
  Unfortunately the discussion about potential performance regression
  has been largely sidestepped by bickering over minutiae.
  => ?

* Unique Joins
  This seems to require more work and came in pretty late
  => Returned with feedback.

* INNER JOIN removals
  Seem far to controversial to consider comitting in 9.5.
  => Returned (or even rejected :()

* Aggregate State Combine Support
  I think we pretty clearly need something roughly like this. It seems
  equally clear that this isn't going to happen in 9.5
  => Returned with feedback

* Allow "snapshot too old" error, to prevent bloat
  
http://archives.postgresql.org/message-id/1361166406.1897609.1424371443904.JavaMail.yahoo%40mail.yahoo.com
  talked about a new version that afaics never materialized
  => Returned with feedback

* KNN-GiST with recheck
  Unfortunately the last version hasn't gotten feedback. The topic is
  somewhat old, so I'd be ugly to not do somethign about it this CF. I
  can't judge the state of the patch right now.
  => ?

* GIN fillfactor
  Seems like a simple enough idea.
  => I guess somebody should review and commit it?

* Manipulating complex types as non-contiguous structures in-memory
  Pretty large for this state and being proposed late. On the other hand
  it's Tom. Looks like it could use some review tho.
  => ?

* Optimization for updating foreign tables in Postgres FDW
  Hm. The last, significantly redone, iteration doesn't seem to have
  gotten much code level review.
  => ?

* iteration over record in plpgsql
  To me this still seems to be in the in the design phase.
  => Return?

* Sequence Access Method
  There's been some back and forth between Petr and Heikki on this
  lately.
  => Maybe there's still a chance for 9.5?

* archive_mode=shared/always
  Hasn't really gotten code level review yet. Heikki?

* Sending WAL receiver feedback regularly even if the receiver is under
  heavy load
  Imo more of a bugfix than a feature. I.e. doesn't really concern the
  CF scheduling.

* Auditing extension
  I'm unclear on the status here. Abhijit said he'll have a look.

* Parallel Seq scan
  In my opinion the topic has progressed greatly. But at the same time
  it doesn't seem like it's in a state we should consider for 9.5.
  => Return?

* ctidscan as an example of custom-scan
  Hasn't really gotten sufficient review.
  => Move

* logical column ordering (WIP)
  This pretty clearly isn't 9.5 material.
  => Return

* parallel mode/contexts
  The largest part of this has just been committed. There's more
  contentious/complicated bits around locking left. I have a hard time
  believing we have the cycles to resolve those for 9.5. It'd be neat if
  we could, but I think "older" stuff has a bit of precedence.

* Support ORDER BY in CREATE FUNCTION for Set Returning Functions
  Uhm. I think the outcome of the discussion so far wasn't really
  favorable to the idea s proposed.
  => Rejected

* RLS: row-level security, more review
  More of a placeholder item. There seem to various open items.

* Cube extension kNN support
  Waiting on author for a few weeks, and submitted late.
  => Returned with feedback

* compress method for spgist
  Hm. Changes spgist's API. Hasn't gotten review in the redone version.
  But it's also not that large?
  => Move?

* mogrify and indent for jsonb
  Committer's patch marked as ready for commit.
  => Should get committed ;)

* assessing parallel-safety
  Unclear. The patch isn't particularly huge, but I'm not sure the
  design is full finished yet. It also came in somewhat late.
  => Unclear.

* Join pushdown support for foreign tables
  Hasn't gotten particularly much review yet. And it doesn't look
  entirely ready to me on a very quick scan. But I don't know that much
  about the area.
  => Move?

* Deparsing utility commands
  IIUc Alvaro intends to commit a minimal version soon.

* Grouping Sets
  Tom intends to take a peek next week.

* INSERT ... ON CONFLICT {UPDATE | IGNORE}
  Heikki, Peter and I have spent a fair amount of time on this. I believe
  we can commit it early next week.

* TABLESAMPLE clause
  Doesn't seem very far from being done. Some questions about including
  (or not) DDL and contrib modules seem to remain.

* REINDEX xxx VERBOSE
  Looks simple enough to commit soon.

* regrole and regnamespace
  Looks simple enough to commit soon.

* pg_basebackup vs. Windows and tablespaces
  Should be committed.

* Additional role attributes
  I agree with Robert's point in
  
http://archives.postgresql.org/message-id/CA%2BTgmobH4tdccajn7VmPT-1RqBdzLYcAz5jUz4bJ%3Drkqs_gADA%40mail.gmail.com
  and thus think that this patch isn't ready for 9.5.

* catalog view to pg_hba.conf file
  Greg is marked as a comitter here.

* pg_file_settings view: To know detail of config files via SQL
  Seems to be ready.

* Add pg_settings.pending_restart column
  Looks like it coudl quickly be committed.


Greetings,

Andres Freund


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to