SEO

Here are the open items. Feature freeze is Friday, July 1.

---------------------------------------------------------------------------


PostgreSQL 8.1 Open Items
=========================

Current version at http://candle.pha.pa.us/cgi-bin/pgopenitems.

Changes
-------
integrated auto-vacuum (Alvaro)
ICU locale patch?
Win32 signal handling patch (Magnus)
KRB4 removal patch (Magnus)
GIST concurrency fixes? (Oleg)
Roles? (Stephen Frost)
convert plperl arrays to pg arrays? (Andrew Dunstan)
plperl validator function? (Andrew Dunstan)
column-level triggers (Greg)
interval improvements (Michael Glaesemann)
move rtree_gist into core?
config file I/O?
terminate backend fix?
dbsize functions from /contrib?
fix pg_autovacuum O(n^2) behavior
remove wal siblings guc vars?
COPY performance improvements

Documentation
-------------

Fixed Since Last Beta
---------------------

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Sat, Jun 25, 2005 at 11:24:56PM -0400, Bruce Momjian wrote:

> Changes
> -------
> integrated auto-vacuum (Alvaro)

Working on it.

> Roles? (Stephen Frost)

Additionally, my shared dependencies patch :-) I'm not sure if I'll be
able to do both autovacuum and shared dependencies before freeze, but
I'll try. I'm not sure if anybody is working on roles though; if I have
to do the three of them I'm pretty sure I won't be able to meet the
deadline.

I think we should leave shared dependencies out if roles do not make it
into 8.1.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido" (Papelucho)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Alvaro Herrera <alvherre@surnet.cl> writes:
>> Roles? (Stephen Frost)

> Additionally, my shared dependencies patch :-) I'm not sure if I'll be
> able to do both autovacuum and shared dependencies before freeze, but
> I'll try. I'm not sure if anybody is working on roles though;

I'll try to finish the roles patch if Stephen sends in what he's got
within the next day or so.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Sat, 25 Jun 2005, Bruce Momjian wrote:

> Here are the open items. Feature freeze is Friday, July 1.
>
> GIST concurrency fixes? (Oleg)
This should be
GIST concurrency support (Teodor, Oleg)

also, after moving rtree_gist into core we should add
regression tests for GIST.

Regards,
Oleg
__________________________________________________ ___________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Saturday 25 June 2005 23:24, Bruce Momjian wrote:
> Here are the open items. Feature freeze is Friday, July 1.
>
> ---------------------------------------------------------------------------
>
>
> PostgreSQL 8.1 Open Items
> =========================
>
> Current version at http://candle.pha.pa.us/cgi-bin/pgopenitems.
>
> Changes
> -------
> integrated auto-vacuum (Alvaro)
> ICU locale patch?
> Win32 signal handling patch (Magnus)
> KRB4 removal patch (Magnus)
> GIST concurrency fixes? (Oleg)
> Roles? (Stephen Frost)
> convert plperl arrays to pg arrays? (Andrew Dunstan)
> plperl validator function? (Andrew Dunstan)
> column-level triggers (Greg)
> interval improvements (Michael Glaesemann)
> move rtree_gist into core?
> config file I/O?
> terminate backend fix?
> dbsize functions from /contrib?
> fix pg_autovacuum O(n^2) behavior
> remove wal siblings guc vars?
> COPY performance improvements
>

Where does the rest of the "contrib roundup" fit into this picture? Is it
simply agreed that we will deal with them as outlined in Josh's and Tom's
email, or does that have to be *before* feature freeze if it is to be done in
8.1?

On a somewhat relative note, I was looking at fulltextindex earlier this week,
and had thoughts to move it to pgfoundry along with some documentation from
techdocs. However after discussing with ChrisKL, we both seem to reach a
conclusion that really that is deprecated code and should be deprecated in
favor of tsearch2. That being the case does anyone think we should still move
it?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On L, 2005-06-25 at 23:24 -0400, Bruce Momjian wrote:
> Here are the open items. Feature freeze is Friday, July 1.

I'm still hoping to get my concurrent vacuum patch in shape before
feature freeze

--
Hannu Krosing <hannu@skype.net>


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Bruce Momjian wrote:

>convert plperl arrays to pg arrays? (Andrew Dunstan)
>
>

Won't be done :-( . Too many wrinkles. Covered by recently added TODO item.

>plperl validator function? (Andrew Dunstan)
>
>

Done and merged.

Also, I am going to try to get done putting language handlers in
pg_catalog instead of public, as per recent discussion.

And I still have my fingers crossed that Abhijit Menon-Sen will submit a
patch to do row fetching via cursors for plperl in time.

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Robert Treat <xzilla@users.sourceforge.net> writes:
> On Saturday 25 June 2005 23:24, Bruce Momjian wrote:
>> Here are the open items. Feature freeze is Friday, July 1.

> Where does the rest of the "contrib roundup" fit into this picture?

I think that moving rtree_gist, reindexdb, and/or userlock into core
would have to happen before feature freeze, but the other items
remaining on the to-do list are simply removal of modules, and as such
not bound by feature freeze. Besides, we've always been laxer about the
rules for contrib than for the core system.

> On a somewhat relative note, I was looking at fulltextindex earlier
> this week, and had thoughts to move it to pgfoundry along with some
> documentation from techdocs. However after discussing with ChrisKL, we
> both seem to reach a conclusion that really that is deprecated code
> and should be deprecated in favor of tsearch2. That being the case
> does anyone think we should still move it?

It's certainly deprecated in favor of tsearch2 as far as the actual
functionality goes. I think that Josh had suggested preserving it
on pgfoundry more as an example of a nontrivial trigger function.
I wouldn't cry if we just dropped it though.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Here are the open items. Feature freeze is Friday, July 1.

This is missing the point that pg_dump output is not forward compatible
with the planned escape string changeover.

We had talked about tweaking ruleutils.c, as well as pg_dump itself,
to use E'...' syntax if the string value contains a backslash ---
but the patch so far applied does none of that.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Sat, 2005-06-25 at 23:24 -0400, Bruce Momjian wrote:
> Here are the open items. Feature freeze is Friday, July 1.
>
> ---------------------------------------------------------------------------
>
>
> PostgreSQL 8.1 Open Items
> =========================
>
> Current version at http://candle.pha.pa.us/cgi-bin/pgopenitems.
>
> Changes
> -------
> integrated auto-vacuum (Alvaro)
> ICU locale patch?
> Win32 signal handling patch (Magnus)
> KRB4 removal patch (Magnus)
> GIST concurrency fixes? (Oleg)
> Roles? (Stephen Frost)
> convert plperl arrays to pg arrays? (Andrew Dunstan)
> plperl validator function? (Andrew Dunstan)
> column-level triggers (Greg)
> interval improvements (Michael Glaesemann)
> move rtree_gist into core?
> config file I/O?
> terminate backend fix?
> dbsize functions from /contrib?
> fix pg_autovacuum O(n^2) behavior
> remove wal siblings guc vars?
> COPY performance improvements

I've just submitted my first working version of Constraint Exclusion
(basic Partitioning) for 8.1

I also hope to complete my earlier submitted patch on WAL log file
switching also.

Best Regards, Simon Riggs


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)