CommitFest 2008-11
This page contains historical information or deprecated articles.
| ⇐ Previous CommitFest | This CommitFest | Next CommitFest ⇒ | 
|---|---|---|
| 2008-09 | 2008-11 | 2009-First | 
This is the page for the CommitFest starting 2008 November.
Managers for this CommitFest are Josh Berkus (josh-at-agliodbs-com) and Dave Page (dpage-at-pgadmin-org).
| This commitfest is now closed All items in this commitfest have been reviewed and actioned. If you have a new patch to submit, please add it at CommitFestOpen. | 
Committed patches
| Patch | Status | Author | Reviewers | 
|---|---|---|---|
| Common Table Expressions | Committed 2008-10-04 | Yoshiyuki Asaba | Jeff Davis | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Add default_val to pg_settings | Committed 2008-10-06 | Greg Smith | Simon Riggs,Magnus Hagander | 
| Noisy _dosmaperror | Committed 2008-10-16 | Takahiro Itagaki | Tom Lane | 
| Memory leak on hashed agg rescan | Committed 2008-10-16 | Neil Conway | Tom Lane | 
| 
 | |||
| Atomic subtransaction commit | Committed 2008-10-20 | Simon Riggs | Alvaro Herrera | 
| add placeholder variables to planner | Committed 2008-10-22 | Tom Lane | Nobody | 
| pg_hba options parsing | Committed 2008-10-23 | Magnus Hagander | Bruce Momjian | 
| 
 | |||
| libpq ssl -> clear fallback looses error messages | Committed 2008-10-27 | Magnus Hagander | Nobody | 
| better hba parsing error messages | Committed 2008-10-27 | Magnus Hagander | Nobody | 
| remove crypt authentication | Committed 2008-10-28 | Magnus Hagander | Nobody | 
| Unicode escapes in literals | Committed 2008-10-29 | Peter Eisentraut | Nobody | 
| User defined I/O conversion casts | Committed 2008-10-31 | Heikki Linnakangas | Nobody | 
| Updating FSM on recovery | Committed 2008-10-31 | Heikki Linnakangas | Nobody | 
| use new heap_(form/deform/modify)_tuple API | Committed 2008-11-01 | Kris Jurka | Zdenek Kotala | 
| 
 | |||
| don't use MAKE_PTR/OFFSET for shmem pointers | Committed 2008-11-02 | Kris Jurka | Tom Lane | 
| reducing statistics write overhead | Committed 2008-11-02 | Martin Pihlak | Tom Lane | 
| 
 | |||
| pg_typeof() | Committed 2008-11-03 | Brendan Jurd | Kurt Harriman | 
| 
 | |||
| Fixes for psql describeOneTableDetails | Committed 2008-11-03 | Kris Jurka | Tom Lane | 
| PageGetTempPage cleanup | Committed 2008-11-03 | Zdenek Kotala | Tom Lane | 
| 
 | |||
| Allow the UUID type to accept non-standard formats | Committed 2008-11-03 | Robert Haas | Peter Eisentraut | 
| array_ndims | Committed 2008-11-04 | Robert Haas | Peter Eisentraut | 
| bulk inserts - keep most recent page pinned | Committed 2008-11-06 | Robert Haas | Tom Lane | 
| 
 | |||
| 
 | |||
| 
 | |||
| ALTER DATABASE SET TABLESPACE Statement | Committed 2008-11-07 | Guillaume Lelarge | Bernd Helmle | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Tests citext casts | Committed 2008-11-07 | David Wheeler | Kenneth Marshall | 
| SQL Standard Interval output and IntervalStyle GUC | Committed 2008-11-08 | Ron Mayer | Brendan Jurd | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| ISO 8601 interval literal input and output | Committed 2008-11-10 | Ron Mayer | Brendan Jurd | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Interval rounding consistency | Committed 2008-11-11 | Ron Mayer | Brendan Jurd | 
| 
 | |||
| 
 | |||
| array_length | Committed 2008-11-12 | Jim C. Nasby | Peter Eisentraut | 
| 
 | |||
| SSL cleanups/hostname verification | Committed 2008-11-13 | Magnus Hagander | Alex Hunsaker | 
| 
 | |||
| 
 | |||
| array_agg/array_accum | Committed 2008-11-13 | Robert Haas | Peter Eisentraut | 
| 
 | |||
| contrib/auto_explain | Committed 2008-11-18 | Takahiro Itagaki | Jeff Davis | 
| 
 | |||
| 
 | |||
| clientcert option for pg_hba | Committed 2008-11-20 | Magnus Hagander | Unicron, Alex Hunsaker | 
| 
 | |||
| client certificate authentication | Committed 2008-11-20 | Magnus Hagander | Alex Hunsaker | 
| 
 | |||
| 
 | |||
| TABLE command | Committed 2008-11-20 | Peter Eisentraut | Unicron, Robert Haas | 
| 
 | |||
| 
 | |||
| adding VERBOSE option to CLUSTER | Committed 2008-11-24 | Jim Cox | Peter Eisentraut | 
| regexp support in usermaps | Committed 2008-11-28 | Magnus Hagander | Gianni Ciolli | 
| 
 | |||
| 
 | |||
| pg_stop_backup wait bug fix | Committed 2008-12-03 | Simon Riggs | Ibrar Ahmed, Heikki Linnakangas | 
| 
 | |||
| 
 | |||
| Visibility map, partial vacuums | Committed 2008-12-03 | Heikki Linnakangas | Tom Lane | 
| 
 | |||
| 
 | |||
| libpq callback unregistration | Committed 2008-12-03 | Bruce Momjian | Magnus Hagander | 
| 
 | |||
| 
 | |||
| 
 | |||
| default values for function's parameters | Committed 2008-12-04 | Pavel Stehule | Peter Eisentraut | 
| 
 | |||
| 
 | |||
| 
 | |||
| add columns via CREATE OR REPLACE VIEW | Committed 2008-12-06 | Robert Haas | Bernd Helmle | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Client SSL key/certificate/etc file name specification | Committed 2008-12-15 | Mark Woodward, Alvaro Herrera, Magnus Hagander | Magnus Hagander, Alex Hunsaker | 
| 
 | |||
| 
 | |||
| SQL/MED compatible connection manager | Committed 2008-12-19 | Martin Pihlak | Peter Eisentraut | 
| Window Functions | Committed 2008-12-28 | Hitoshi Harada | Heikki Linnakangas, David Rowley, Tom Lane | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| psql: reformat permissions in \l+ | Committed 2008-12-31 | Andreas Scherbaum | Tom Lane | 
| 
 | |||
| contrib/pg_stat_statements | Committed 2009-01-04 | Takahiro Itagaki | Alex Hunsaker | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| pg_dump roles support | Committed 2009-01-05 | Benedek Laszlo | Abhijit Menon-Sen | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Solve a problem of LC_TIME of windows | Committed 2009-01-09 | Hiroshi Saito | Magnus Hagander | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| posix_fadvise | Committed 2009-01-11 | Gregory Stark | Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| LC_MESSAGES on Windows | Committed 2009-01-21 | Hiroshi Inoue | Magnus Hagander | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Column-level Permissions | Committed 2009-01-22 | Stephen Frost | Markus Wanner, Alvaro Herrera, Tom Lane | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| parallel restore | Committed 2009-02-02 | Andrew Dunstan | Kenneth Marshall | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| autovacuum and reloption | Committed 2009-02-09 | Euler Taveira de Oliveira,Alvaro Herrera | Nobody | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| updated hash functions | Committed 2009-02-09 | Kenneth Marshall | Jeff Davis | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Infrastructure changes for recovery | Committed 2009-02-18 | Simon Riggs | Tom Lane, Heikki Linnakangas | 
| 
 | |||
| 
 | |||
| Improve Performance of Multi-Batch Hash Join for Skewed Data Sets | Committed 2009-03-20 | Ramon Lawrence/Bryce Cutt | Joshua Tolley,Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| GIN fast insert | Committed 2009-03-24 | Teodor Sigaev, Oleg Bartunov | Jeff Davis,Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| B-Tree emulation for GIN | Committed 2009-03-25 | Teodor Sigaev, Oleg Bartunov | Jeff Davis,Ibrar Ahmed | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | 
Returned with Feedback
| Patch | Status | Author | Reviewers | 
|---|---|---|---|
| Simple postgresql.conf wizard | WIP | Greg Smith | Josh Berkus,Nathan Boley | 
| 
 | |||
| 
 | |||
| 
 | |||
| new correlation metric | Pending rework | Jeff Davis | Brendan Jurd | 
| In-place online upgrade | Removed from queue per author | Zdenek Kotala | Robert Haas | 
| 
 | |||
| 
 | |||
| Extending pg_class info + more flexible TOAST chunk size | Removed from queue per author | Zdenek Kotala | Robert Haas | 
| 
 | |||
| 
 | |||
| Optimizing COPY with memchr() | WIP | Heikki Linnakangas | Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| grouping sets | WIP | Pavel Stehule | Ibrar Ahmed | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Distinct types | WIP | Peter Eisentraut | Nobody | 
| 
 | |||
| 
 | |||
| htup and bufpage API clean up | Waiting on author | Zdenek Kotala | Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| Block-level CRC checks | Waiting on author | Alvaro Herrera | Nobody | 
| 
 | |||
| 
 | |||
| 
 | |||
| Auto Partitioning Patch | WIP | Nikhil Sontakke | Jaime Casanova | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Enable pl/python to return records based on multiple OUT params | Returned for cleanup | Hannu Krosing | Unicron | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | 
 | ||
| pre-MED | WIP | David Fetter | Alex Hunsaker | 
| 
 | |||
| 
 | |||
| 
 | |||
| Hash Join-Filter Pruning using Bloom Filters | Removed from queue per author | Jonah Harris | Unicron | 
| 
 | |||
| 
 | |||
| 
 | |||
| On-disk bitmap indexes | Removed from queue per author | Gabriele Bartolini, Gianni Ciolli | Greg Stark (more welcome!) | 
| 
 | |||
| 
 | |||
| 
 | |||
| Synchronous log-shipping replication | Pending Review | Masao Fujii | Heikki Linnakangas, Simon Riggs | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| pg_upgrade script for 8.3->8.4 | Needs rewrite | Zdenek Kotala | Greg Smith, Peter Eisentraut | 
| 
 | |||
| 
 | |||
| Hot Standby - queries during archive recovery | Needs more work | Simon Riggs | Koichi Suzuki,Heikki Linnakangas | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Reducing some DDL Locks to ShareLock | Needs more testing | Simon Riggs | Tom Lane | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| SE-PostgreSQL patches | Needs more work | Kaigai Kohei | Tom Lane, Simon Riggs, Bruce Momjian | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Proposal of PITR performance improvement | pgfoundry, merge with HS & SR for 8.5 | Koichi Suzuki | Simon Riggs,Heikki Linnakangas,Greg Stark,Itakagi Takahiro,Fujii Masao | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | 
Rejected Patches
| Patch | Status | Author | Reviewers | 
|---|---|---|---|
| FAQ_Solaris 1.28 to spanish | Rejected | Emanuel CALVO FRANCO | Peter Eisentraut | 
| 
 | |||
| HeapTuple version extension + code cleanup | Rejected | Zdenek Kotala | Robert Haas | 
| 
 | |||
| 
 | |||
| Prepared transactions and temp tables | Rejected | Emmanuel Cecchet | Heikki Linnakangas | 
| 
 | |||
| 
 | |||
| 
 | |||
| Support PLUGINS lines in Makefiles, similar to MODULES | Rejected | Asif Naeem | Robert Haas | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| Automatic view update rules | Rejected | Bernd Helmle | Unicron, Robert Haas, Peter Eisentraut, Jaime Casanova | 
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| 
 | |||
| rmgr hooks and contrib/rmgr_hook | Not wanted, needs better use cases | Simon Riggs | Nobody | 
| 
 | |||
| 
 | |||
| 
 | 
Round Robin Reviewers
| Name | Status | Reviewing | Completed | 
|---|---|---|---|
| Brendan Jurd | Available | 0 | 4 | 
| Jaime Casanova | Available | 1 | 1 | 
| Stephen Frost | Available 11/15 | 0 | 0 | 
| Jeff Davis | Available | 0 | 5 | 
| Greg Stark | Unknown | 1 | 0 | 
| Abhijit Menon-Sen | Unknown | 0 | 0 | 
| Alex Hunsaker | Available | 0 | 6 | 
| Markus Wanner | Cherry-picking | 1 | 1 | 
| Ibrar Ahmed | Available | 1 | 2 | 
| D'Arcy Cain | Unknown | 0 | 0 | 
| Kenneth Marshall | Available | 1 | 1 | 
| Robert Haas | Available | 0 | 11 | 
| Matthew Wetmore | Out-of-contact | 0 | 0 | 
| Gianni Colli | Available | 1 | 0 | 
| "Unicron" | Available | 1 | 4 | 
| Pavan Deolasee | Partly-Done | 0 | 1 | 

