Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCMY0-0006xG-TN for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2013 03:58:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCMY0-0006OA-Al for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2013 03:58:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCMXz-0006O4-0o for pgsql-hackers@postgreSQL.org; Mon, 04 Mar 2013 03:58:43 +0000 Received: from outmail149055.authsmtp.co.uk ([62.13.149.55]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCMXw-0000Ch-RJ for pgsql-hackers@postgreSQL.org; Mon, 04 Mar 2013 03:58:42 +0000 Received: from mail-c226.authsmtp.com (mail-c226.authsmtp.com [62.13.128.226]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id r243wZWq051603; Mon, 4 Mar 2013 03:58:35 GMT Received: from ayaki.localdomain (124-169-162-93.dyn.iinet.net.au [124.169.162.93]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r243wTKG033228 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Mon, 4 Mar 2013 03:58:32 GMT Message-ID: <51341BE1.2020902@2ndquadrant.com> Date: Mon, 04 Mar 2013 11:58:25 +0800 From: Craig Ringer Organization: 2nd Quadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130219 Thunderbird/17.0.3 MIME-Version: 1.0 To: Josh Berkus CC: PostgreSQL-development Subject: Re: Partial patch status update, 3/3/13 References: <5133C207.3040509@agliodbs.com> In-Reply-To: <5133C207.3040509@agliodbs.com> X-Enigmail-Version: 1.5.1 Content-Type: multipart/alternative; boundary="------------090101080400050805070205" X-Server-Quench: c8b35cb4-847f-11e2-98a9-0025907ec6c5 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZeVg0b BQteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAFbYFhD HGQLWldEUF57XGt/ aAkfbAdZfEtIVhtr VkpXS1FNFgBqBAMA SFwcVho1E34xeH1z Z0RqEHFZWEd4OxV1 EE1RRj8CeG9kbzYC UUENdR5deFJDYx9F aFV2VHRYMmNUYzQC El17DBAYFhZyEh9g CjkEN04TSEJDBjcg TBBKBikmAVAeDzgr IxU6JxpURwFKdRxp WQAA X-Authentic-SMTP: 61633235383639.1020:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 124.169.162.93/2525 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------090101080400050805070205 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I've gone through all the Server Features entries and partway through the performance category. So far: "Writable Foreign Tables" is waiting for Tom to have a chance to check it out and do some detailed work on it. Anyone else who wants to step in and help might be able to improve its chances, as right now it looks like it'll probably slip. Stalled waiting for final committer check and apply: - Identity projection (partitioning) - Writable foreign tables (but needs significant work not just apply, test, commit) Nobody seems to want to review this: - The SEPostgreSQL patches I still need to test this on Windows: - parallel pg_dump Discussion ongoing, uncertain if it'll make the 9.3 cut: - Timeout framework extension and lock_timeout - the rest of the event triggers patch - checksums Rejected per thread discussion: - Add code commentary in ProcessInterrupts RWF per thread discussion: - Store additional information in GIN index Pending update after response to reminders/queries: - Extension templates - Adjacent in SP-GiST for range-types - Performance Improvement by reducing WAL for Update Operation -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --------------090101080400050805070205 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
I've gone through all the Server Features entries and partway through the performance category. So far:

"Writable Foreign Tables" is waiting for Tom to have a chance to check it out and do some detailed work on it. Anyone else who wants to step in and help might be able to improve its chances, as right now it looks like it'll probably slip.

Stalled waiting for final committer check and apply:

- Identity projection (partitioning)
- Writable foreign tables
  (but needs significant work not just apply, test, commit)

Nobody seems to want to review this:

- The SEPostgreSQL patches

I still need to test this on Windows:

- parallel pg_dump

Discussion ongoing, uncertain if it'll make the 9.3 cut:

- Timeout framework extension and lock_timeout
- the rest of the event triggers patch
- checksums

Rejected per thread discussion:

- Add code commentary in ProcessInterrupts

RWF per thread discussion:

- Store additional information in GIN index


Pending update after response to reminders/queries:

- Extension templates
- Adjacent in SP-GiST for range-types
- Performance Improvement by reducing WAL for Update Operation
-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
--------------090101080400050805070205--