pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Subject: Re: It's June 1; do you know where your release is?
Date: Tue, 02 Jun 2009 17:26:23 -0700
Message-ID: <4A25C32F.30203@agliodbs.com> (raw)
In-Reply-To: <15765.1243965376@sss.pgh.pa.us>
References: <19107.1243873940@sss.pgh.pa.us>
	<603c8f070906012050p6ccd62d3v13d3e0f887fe7c90@mail.gmail.com>
	<alpine.BSO.2.00.0906020108410.15690@leary.csoft.net>
	<15765.1243965376@sss.pgh.pa.us>

Tom, all,

More suggested dispositions:

     *  plperl fails with Perl 5.10 on Windows
           o tgl says: no reports of this with pre-8.4 Postgres, but I 
bet that's just because no one tried it
           o dpage says: I'm rolling back the Windows installers to use 
5.8 for now. Would appreciate help from anyone familiar with Perl 
internals to try to debug this further!

-- Dunstan, Wheeler, Sabino-Mullaine, 'lil help please?

     * contrib/seg and contrib/cube GiST index support have performance 
issues
           o proposed (incomplete) patch here

-- If it's just a performance issue, I don't think this issue should 
block 8.4.0; it can be fixed in 8.4.1 if necessary, since we'll probably 
want to backpatch the fix anyway.

     * possible bug in cover density ranking?

-- From Teodor's response, this is maybe a doc patch and not a code 
patch.  Teodor?  Oleg?

     * localeconv encoding issues
           o proposed patch here

-- Any reason not to apply patch?

     * BUG #4622: xpath only work in utf-8 server encoding
           o tgl says: there's a proposed patch for this, but I don't 
think it fixes it

-- I think this is a doc patch.  Since libxml (as I understand it) only 
supports UTF, this is not something we can fix without major engineering 
anyway, certainly not before release.  I just think we need big warnings 
in the docs in several places.

     * contrib/intarray opclass definition needs updating
           o tgl says: done, but there's another problem; see also bug 
#4806

-- This is a serious issue which I'm not sure how we can resolve in the 
next couple weeks.  Simply throwing a warning is inadequate (although if 
we can't fix it in time, we'll have to do that).  Having the planner 
refuse to use the index if '{}' is involved is problematic from a 
performance standpoint.  And changing GIN and GiST so they index empty 
arrays seems likely to have other side effects.  Ideas, anyone?

     * Path separator consistency on Windows

-- This discussion does not appear to have concluded.  Magnus, Dave?

     * autovacuum can run rebuild_database_list unreasonably often

-- A possible quick workaround would be to put a lower limit of naptime 
at 1s.  This would save most people (those with 10 or less database) 
from triggering rebuild_database_list too often.  However, given that 
it's precisely the people with 100's of databases who would want to 
lower naptime to very low levels, this isn't much of a solution.
   On the other-other hand, this is enough of a corner case that I think 
we can put in a documentation warning and put a fix for this in the TODO 
list.  Unless Alvaro can get in a patch which prevents 
rebuild_database_list from running more often than once per minute this 
week?

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com



view thread (42+ messages)  latest in thread

Message-ID: <4A25C32F.30203@agliodbs.com>
Permalink:  ../4A25C32F.30203@agliodbs.com/
Also on:    postgresql.org/message-id/4A25C32F.30203@agliodbs.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: It's June 1; do you know where your release is?
  In-Reply-To: <4A25C32F.30203@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox