Draft release notes

Ühel kenal päeval, N, 2006-09-14 kell 01:12, kirjutas Bruce Momjian:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

You should leave my name out from plpython enchancements, the actual
programming was all done by Sven.

* Add named parameters to plpython args[] array (Hannu Krosing, Sven Suursoho)
* Return composite-types from plpython as dictionary (Hannu Krosing,
Sven Suursoho)
* Return result-set from plpython as list, iterator or generator
(Hannu Krosing, Sven Suursoho)
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com

On 9/14/06, Bruce Momjian <bruce@momjian.us> wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

AFAICS the log_duration behaviour change made by Tom a few days ago is
not there.

--
Guillaume

* Improve multicolumn GiST index (oleg,teodor)
* GiST indexes now are clusterable (teodor)
* tsearch2 improvements (oleg, teodor):
- multibyte encoding support (including UTF8)
- query rewriting support
- improve ranking functions
- thesaurus dictionary
- Ispell dictionary now recognize MySpell format, used by OpenOffice.
- support of GIN
* new operators for one-dimensional array (<@, @>, &&) with
GIN support (teodor)

Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

* Allow regression tests to be run on Win32 without MinGW (Magnus, Tom)

This is not entirsely correect. What was done was a re-implementation of
pg_regress in C from shellscript. This is a prerequisite for running the
tests completely without mingw, but you can't do that yet (there needs
to be rules in the VC build stuff to deal with the regression output
files that need to be edited, for example - this is done with sed from
the Makefile today.

//Magnus

The list of functions for:
* Add SQL2003-standard statistical aggregates (Sergey Koposov)

regr_intercept, regr_slope, regr_r2, corr, covar_samp, covar_pop,
regr_avgx, regr_avgy, regr_sxy, regr_sxx, regr_syy, regr_count

Also, I guess that the point
* Aggregate functions now support multiple input arguments (Tom)
should be
* Aggregate functions now support multiple input arguments (Sergey Koposov, Tom)
instead

Regards,
Sergey
*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math@sai.msu.ru

On Thu, 2006-09-14 at 01:12 -0400, Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

A few changes:

- Improve COPY performance (Alon Goldshuv)
- Optimize the locking used by sequential scans (Qingqing Zhou)

- Re-enable full_page_writes (Tom)
This flag can now be used even with PITR. It is turned **on** (not off!)
automatically between pg_start_backup() and pg_stop_backup() calls.

- Add support for forcing a switch to a new xlog file (Simon Riggs)
...should include Tom

- Improve performance of replaying WAL logs on a backup server (Simon
Riggs)
...I describe this as Restartable Recovery... don't think it improves
performance exactly, just avoids needing to re-run it from scratch

My memory says this was eventually removed, even though it was committed
for a time. Am I wrong?
- Make EXPLAIN sampling smarter, to avoid excessive sampling delay
(Martijn van Oosterhout)

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

Add support for Windows codepages 1253, 1254, 1255, and 1257 (Peter)

This was actually me.

http://archives.postgresql.org/pgsql-patches/2006-02/msg00039.php

Kris Jurka

Hannu Krosing wrote:

?hel kenal p?eval, N, 2006-09-14 kell 01:12, kirjutas Bruce Momjian:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

You should leave my name out from plpython enchancements, the actual
programming was all done by Sven.

* Add named parameters to plpython args[] array (Hannu Krosing, Sven Suursoho)
* Return composite-types from plpython as dictionary (Hannu Krosing,
Sven Suursoho)
* Return result-set from plpython as list, iterator or generator
(Hannu Krosing, Sven Suursoho)

OK, updated.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Guillaume Smet wrote:

On 9/14/06, Bruce Momjian <bruce@momjian.us> wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

AFAICS the log_duration behaviour change made by Tom a few days ago is
not there.

The top says:

[ CURRENT AS OF 2006-09-07 ]

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Great. Added:

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

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

Teodor Sigaev wrote:

* Improve multicolumn GiST index (oleg,teodor)
* GiST indexes now are clusterable (teodor)
* tsearch2 improvements (oleg, teodor):
- multibyte encoding support (including UTF8)
- query rewriting support
- improve ranking functions
- thesaurus dictionary
- Ispell dictionary now recognize MySpell format, used by OpenOffice.
- support of GIN
* new operators for one-dimensional array (<@, @>, &&) with
GIN support (teodor)

Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Magnus Hagander wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

* Allow regression tests to be run on Win32 without MinGW (Magnus, Tom)

This is not entirsely correect. What was done was a re-implementation of
pg_regress in C from shellscript. This is a prerequisite for running the
tests completely without mingw, but you can't do that yet (there needs
to be rules in the VC build stuff to deal with the regression output
files that need to be edited, for example - this is done with sed from
the Makefile today.

OK, updated wording:

* Reimplement the regression test as a C program (Magnus, Tom)

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

OK, all updated. Thanks.

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

Sergey E. Koposov wrote:

The list of functions for:
* Add SQL2003-standard statistical aggregates (Sergey Koposov)

regr_intercept, regr_slope, regr_r2, corr, covar_samp, covar_pop,
regr_avgx, regr_avgy, regr_sxy, regr_sxx, regr_syy, regr_count

Also, I guess that the point
* Aggregate functions now support multiple input arguments (Tom)
should be
* Aggregate functions now support multiple input arguments (Sergey Koposov, Tom)
instead

Regards,
Sergey
*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math@sai.msu.ru

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Simon Riggs wrote:

On Thu, 2006-09-14 at 01:12 -0400, Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

A few changes:

- Improve COPY performance (Alon Goldshuv)
- Optimize the locking used by sequential scans (Qingqing Zhou)

- Re-enable full_page_writes (Tom)
This flag can now be used even with PITR. It is turned **on** (not off!)
automatically between pg_start_backup() and pg_stop_backup() calls.

- Add support for forcing a switch to a new xlog file (Simon Riggs)
...should include Tom

OK, done.

- Improve performance of replaying WAL logs on a backup server (Simon
Riggs)
...I describe this as Restartable Recovery... don't think it improves
performance exactly, just avoids needing to re-run it from scratch

OK, new wording:

* Allow WAL replay to be restared quicker in case of a crash (Simon
Riggs)

The improvement is to do periodic checkpoints during WAL recovery, so
if there is a crash, future WAL recovery is shortened.

My memory says this was eventually removed, even though it was committed
for a time. Am I wrong?
- Make EXPLAIN sampling smarter, to avoid excessive sampling delay
(Martijn van Oosterhout)

I see a reversion for EXPLAIN ANALYZE only:

date: 2006/06/09 19:30:56; author: tgl; state: Exp; lines: +27 -172
Revert sampling patch for EXPLAIN ANALYZE; it turns out to be too
unreliable because node timing is much less predictable than the patch
expects. I kept the API change for InstrStopNode, however.

so the item is probably still OK.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Bruce Momjian <bruce@momjian.us> writes:

Simon Riggs wrote:

My memory says this was eventually removed, even though it was committed
for a time. Am I wrong?
- Make EXPLAIN sampling smarter, to avoid excessive sampling delay
(Martijn van Oosterhout)

I see a reversion for EXPLAIN ANALYZE only:

date: 2006/06/09 19:30:56; author: tgl; state: Exp; lines: +27 -172
Revert sampling patch for EXPLAIN ANALYZE; it turns out to be too
unreliable because node timing is much less predictable than the patch
expects. I kept the API change for InstrStopNode, however.

so the item is probably still OK.

No, Simon is right, that entry should be removed --- there's nothing
interesting left of the patch :-(

regards, tom lane

Tom Lane wrote:

Bruce Momjian <bruce@momjian.us> writes:

Simon Riggs wrote:

My memory says this was eventually removed, even though it was committed
for a time. Am I wrong?
- Make EXPLAIN sampling smarter, to avoid excessive sampling delay
(Martijn van Oosterhout)

I see a reversion for EXPLAIN ANALYZE only:

date: 2006/06/09 19:30:56; author: tgl; state: Exp; lines: +27 -172
Revert sampling patch for EXPLAIN ANALYZE; it turns out to be too
unreliable because node timing is much less predictable than the patch
expects. I kept the API change for InstrStopNode, however.

so the item is probably still OK.

No, Simon is right, that entry should be removed --- there's nothing
interesting left of the patch :-(

I see. Removed.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

Done.

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

Joe Conway wrote:

Bruce Momjian wrote:

Here is an early draft of the release notes. It needs more polish and
review:

http://momjian.us/cgi-bin/pgrelease

I will catch up on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.

This one should be changed:

"Add support for multi-row VALUES clauses as part of INSERT
statements (Joe, Tom)

For example, allow INSERT ... VALUES (...), (...), ...."

Maybe:

"Add support for multi-row VALUES clauses wherever SELECT
can be used (Joe, Tom)

For example, allow
INSERT ... VALUES (...), (...), ....
SELECT * FROM (VALUES (...), (...), ....) AS alias(f1, ...)"

Joe

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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