5 Weeks till feature freeze or (do you know where your patch is?)

Hello,

5 weeks to feature freeze folks. Please provide updates including if you
think you will have a patch submitted before feature freeze. Be
realistic, if you can't make it -- say so.

Alvaro Herrera: Autovacuum improvements (maintenance window etc..)
Gavin Sherry: Bitmap Indexes (on disk), possible basic Window functions
Greg Stark: WITH/Recursive Queries?
Andrei Kovalesvki: Some Win32 work with Magnus
Magnus Hagander: VC++ support (thank goodness)
Heikki Linnakangas: Vacuum for Bitmap Indexes, Group Index Tuples
Oleg Bartunov: Tsearch2 in core
Neil Conway: Patch Review (including enums), pg_fcache
PeterE: XML
ITAGAKI Takahiro: Dead space map, load distributed checkpoints
Stephen Frost: Default permission per object/schema
Tom Lane: Cost based functions, operator overhaul, Plan Invalidation?
Simon Riggs: HOT ( you know he just is )
Pavan Deolasee: HOT ( never met him )
Teodor Sigaev: Tsearch2 in core (with Oleg)
Jeff Davis: Synchronized scanning
Henry Hotz: GSSAPI (with Magnus)
Andrew Dunstan: Something with COPY? Andrew?
David Fetter: Arrays of compound types

Looking for updates on Updateable views. Anyone? Bueller?

Vertical projects:

Pavel Stehule: PLpsm
Alexey Klyukin: PLphp
Andrei Kovalesvki: ODBCng
Neil Conway: pgmemcache
Josh Drake: pgmemcache

This close to feature freeze it is really time for people to get
pounding on patch review!!!

Sincerely,

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Joshua D. Drake wrote:
> Andrew Dunstan: Something with COPY? Andrew?
>
>

The only thing I can think of is to remove the support for ancient COPY
syntax from psql's \copy, as suggested here:
http://archives.postgresql.org/pgsql-hackers/2007-02/msg01078.php

That's hardly a feature - more a matter of tidying up.

>
> Neil Conway: pgmemcache
> Josh Drake: pgmemcache
>

what does this refer to?

cheers

andrew

>>
>> Neil Conway: pgmemcache
>> Josh Drake: pgmemcache
>>
>
>
> what does this refer to?

Neil is cleaning up the code, I am cleaning up the docs.

Joshua D. Drake

>
>
> cheers
>
> andrew
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

> The only thing I can think of is to remove the support for ancient COPY
> syntax from psql's \copy, as suggested here:
> http://archives.postgresql.org/pgsql-hackers/2007-02/msg01078.php
>
> That's hardly a feature - more a matter of tidying up.

I thought you were being sponsored for something?

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:

> Greg Stark: WITH/Recursive Queries?

Uhm, I posted two weeks ago saying I had to shelve that temporarily.

On the other hand I've submitted a patch to reduce the storage overhead of
varlenas under 128 bytes by 3-7 bytes each.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

Gregory Stark wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>
>> Greg Stark: WITH/Recursive Queries?
>
> Uhm, I posted two weeks ago saying I had to shelve that temporarily.

I can't read every email :)

Can someone pick this up? This would be the second time that this has
been dropped. Anyone?

>
> On the other hand I've submitted a patch to reduce the storage overhead of
> varlenas under 128 bytes by 3-7 bytes each.

Cool!

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Fri, 2007-02-23 at 13:24 -0800, Joshua D. Drake wrote:
> Jeff Davis: Synchronized scanning

I am still on target. I'm scheduling some benchmarks on real hardware
and real queries in the next week or two. If those show the results I
expect, I'll be ready before feature freeze.

Regards,
Jeff Davis

Jeff,

> I am still on target. I'm scheduling some benchmarks on real hardware
> and real queries in the next week or two. If those show the results I
> expect, I'll be ready before feature freeze.

Send me a patch against 8.2.3 and I'll pass it to the Sun benchmarking
team.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

Also, I have several heavy patches in the patch queue that I am not
comfortable reviewing/applying:

http://momjian.postgresql.org/cgi-bin/pgpatches

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

Joshua D. Drake wrote:
> Hello,
>
> 5 weeks to feature freeze folks. Please provide updates including if you
> think you will have a patch submitted before feature freeze. Be
> realistic, if you can't make it -- say so.
>
>
> Alvaro Herrera: Autovacuum improvements (maintenance window etc..)
> Gavin Sherry: Bitmap Indexes (on disk), possible basic Window functions
> Greg Stark: WITH/Recursive Queries?
> Andrei Kovalesvki: Some Win32 work with Magnus
> Magnus Hagander: VC++ support (thank goodness)
> Heikki Linnakangas: Vacuum for Bitmap Indexes, Group Index Tuples
> Oleg Bartunov: Tsearch2 in core
> Neil Conway: Patch Review (including enums), pg_fcache
> PeterE: XML
> ITAGAKI Takahiro: Dead space map, load distributed checkpoints
> Stephen Frost: Default permission per object/schema
> Tom Lane: Cost based functions, operator overhaul, Plan Invalidation?
> Simon Riggs: HOT ( you know he just is )
> Pavan Deolasee: HOT ( never met him )
> Teodor Sigaev: Tsearch2 in core (with Oleg)
> Jeff Davis: Synchronized scanning
> Henry Hotz: GSSAPI (with Magnus)
> Andrew Dunstan: Something with COPY? Andrew?
> David Fetter: Arrays of compound types
>
> Looking for updates on Updateable views. Anyone? Bueller?
>
> Vertical projects:
>
> Pavel Stehule: PLpsm
> Alexey Klyukin: PLphp
> Andrei Kovalesvki: ODBCng
> Neil Conway: pgmemcache
> Josh Drake: pgmemcache
>
>
> This close to feature freeze it is really time for people to get
> pounding on patch review!!!
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Joshua D. Drake wrote:
> Hello,
>
> 5 weeks to feature freeze folks. Please provide updates including if you
> think you will have a patch submitted before feature freeze. Be
> realistic, if you can't make it -- say so.
>
>
> Alvaro Herrera: Autovacuum improvements (maintenance window etc..)
> Gavin Sherry: Bitmap Indexes (on disk), possible basic Window functions
> Greg Stark: WITH/Recursive Queries?
> Andrei Kovalesvki: Some Win32 work with Magnus
> Magnus Hagander: VC++ support (thank goodness)
> Heikki Linnakangas: Vacuum for Bitmap Indexes, Group Index Tuples
> Oleg Bartunov: Tsearch2 in core
> Neil Conway: Patch Review (including enums), pg_fcache
> PeterE: XML
> ITAGAKI Takahiro: Dead space map, load distributed checkpoints
> Stephen Frost: Default permission per object/schema
> Tom Lane: Cost based functions, operator overhaul, Plan Invalidation?
> Simon Riggs: HOT ( you know he just is )
> Pavan Deolasee: HOT ( never met him )
> Teodor Sigaev: Tsearch2 in core (with Oleg)
> Jeff Davis: Synchronized scanning
> Henry Hotz: GSSAPI (with Magnus)
> Andrew Dunstan: Something with COPY? Andrew?
> David Fetter: Arrays of compound types
>
> Looking for updates on Updateable views. Anyone? Bueller?

Afaik Bernd is working in this one and he is targetting 8.4

Looks like we are doing redundant work here:
http://developer.postgresql.org/index.php/Todo:WishlistFor83

Where/how do you maintained your todo list Joshua? Would love to join
"forces" on this one .. especially since I send out emails to many of
the above noted people. If we both send emails to everybody they might
get ticked off ..

regards,
Lukas

>
> Looks like we are doing redundant work here:
> http://developer.postgresql.org/index.php/Todo:WishlistFor83
>
> Where/how do you maintained your todo list Joshua? Would love to join
> "forces" on this one .. especially since I send out emails to many of
> the above noted people. If we both send emails to everybody they might
> get ticked off ..

I just took the replies from my 10 week email and merged them. I tried
to use the wiki but got fed up with my login/edit privelages not working :)

Joshua D. Drake

>
> regards,
> Lukas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

"Gregory Stark" <stark(at)enterprisedb(dot)com> writes:

> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>
>> Greg Stark: WITH/Recursive Queries?
>
> Uhm, I posted two weeks ago saying I had to shelve that temporarily.
>
> On the other hand I've submitted a patch to reduce the storage overhead of
> varlenas under 128 bytes by 3-7 bytes each.

oops, that's actually 3-6 bytes.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

Joshua D. Drake wrote:

<snip>

> Magnus Hagander: VC++ support (thank goodness)

I would much appreciate more people testing and commenting on this one,
from the version in CVS head.

//Magnus

On 2/24/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
>
> Pavan Deolasee: HOT ( never met him )
>
>
I am working on it with the target of 8.3. I am posting WIP patches
since couple of weeks. One of the objectives of publishing WIP
patches, even though they are not well tested (for correctness as
well as performance) is to get early feedback on the design and
code. It would really help if one or more of the community members
look at the code so that we don't have last minute gotchas.

Thanks,
Pavan

--

EnterpriseDB http://www.enterprisedb.com

On Feb 23, 2007, at 1:24 PM, Joshua D. Drake wrote:

> Henry Hotz: GSSAPI (with Magnus)

Progressing. Had hoped to have alpha patches by March 1, but I just
got handed a proposal that I have to do by then. I trust it's OK to
send the first version in next week?

No real issues, except I haven't disentangled the SSL buffering to
disentangle my security layer from theirs.

Question: are there any corresponding deadlines for the Java client
code that I need to worry about?
------------------------------------------------------------------------
The opinions expressed in this message are mine,
not those of Caltech, JPL, NASA, or the US Government.
Henry(dot)B(dot)Hotz(at)jpl(dot)nasa(dot)gov, or hbhotz(at)oxy(dot)edu

Henry B. Hotz wrote:
>
> On Feb 23, 2007, at 1:24 PM, Joshua D. Drake wrote:
>
>> Henry Hotz: GSSAPI (with Magnus)
>
> Progressing. Had hoped to have alpha patches by March 1, but I just got
> handed a proposal that I have to do by then. I trust it's OK to send
> the first version in next week?

Feature freeze is the end of March so I would say yes.

>
> No real issues, except I haven't disentangled the SSL buffering to
> disentangle my security layer from theirs.
>
> Question: are there any corresponding deadlines for the Java client
> code that I need to worry about?

You would need to talk to the jdbc folks about that I would guess. There
development cycle is independent of .Org.

Joshua D. Drake

> ------------------------------------------------------------------------
> The opinions expressed in this message are mine,
> not those of Caltech, JPL, NASA, or the US Government.
> Henry(dot)B(dot)Hotz(at)jpl(dot)nasa(dot)gov, or hbhotz(at)oxy(dot)edu
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Tue, 27 Feb 2007, Henry B. Hotz wrote:

> Question: are there any corresponding deadlines for the Java client code
> that I need to worry about?

The JDBC driver will release a new version at the same time as the server,
but we don't have nearly as strict rules about feature freeze/beta. We
don't need multiple months of beta so as long as the patch isn't terribly
complicated we'll accept it close to the release.

Kris Jurka