8.1 release notes

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
27 messages Options
12
Reply | Threaded
Open this post in threaded view
|

8.1 release notes

Bruce Momjian-2
I have compiled the 8.1 release notes and converted them to SGML at:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1

I still need to add markup and cleanup, but it is good enough for
review and for beta1.  I will work on it more tomorrow.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 2: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruno Wolff III
On Mon, Aug 22, 2005 at 23:16:14 -0400,
  Bruce Momjian <[hidden email]> wrote:
> I have compiled the 8.1 release notes and converted them to SGML at:
>
>   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.

I spotted a couple of typos:

I think that 'not' should be 'now' in the following:
In previous releases, the only way to use index for MIN/MAX was to rewrite the query as SELECT col FROM tab ORDER BY col LIMIT 1. This not happens automatically.

I think that 'of' should be 'off' in the following:
To prevent partial disk writes from corrupting the database, PostgreSQL writes a complete copy of each database disk page to WAL the first time it is modified after a checkpoint. This turns of that functionality for users with battery-backed disk caches where partial page writes can not happen.

I don't think you want a double negative ('not' and 'INconsistant') in the
following:
In release 8.0, carriage returns and line feeds in CSV COPY TO were not processed in a inconsitent manner. (This was documented on the TODO list.)

---------------------------(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
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Oleg Bartunov
In reply to this post by Bruce Momjian-2
Bruce,

I think I took part in GiST concurrency and recovery project.

  Oleg
On Mon, 22 Aug 2005, Bruce Momjian wrote:

> I have compiled the 8.1 release notes and converted them to SGML at:
>
>  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.
>
>

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Mario Weilguni-3
In reply to this post by Bruce Momjian-2
JFYI:

"Allow indexes to be used for MIN/MAX (Tom)

In previous releases, the only way to use index for MIN/MAX was to
rewrite the query as SELECT col FROM tab ORDER BY col LIMIT 1. This not
happens automatically."

I guess this should read "This now happens automatically"

Regards,
        Mario Weilguni

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Oleg Bartunov
Sent: Tuesday, August 23, 2005 9:04 AM
To: Bruce Momjian
Cc: PostgreSQL-development
Subject: Re: [HACKERS] 8.1 release notes

Bruce,

I think I took part in GiST concurrency and recovery project.

  Oleg
On Mon, 22 Aug 2005, Bruce Momjian wrote:

> I have compiled the 8.1 release notes and converted them to SGML at:
>
>  
> http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-
> 8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.
>
>

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

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Michael Paesold
In reply to this post by Bruce Momjian-2
Bruce Momjian wrote:
> I have compiled the 8.1 release notes and converted them to SGML at:
>
>   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.

I think this is an understatement and does not really say what was done:
Replace pg_shadow and pg_group by new role-capable catalogs pg_authid
and pg_auth_members.

I would include something like "Implement SQL-compliant ROLE support...".

I believe "Make default_with_oids default to false" and "Change
add_missing_from to 'false'" should be mentioned in the "Migration" section.
This section should say "Migration to version 8.1" instead of "Migration
to version 8.0".

"This caused CREATE DATABASE to sometimes fail because a new database
can not be created if anyone else is in the template database."
Shouldn't this read:
"This caused CREATE DATABASE to sometimes fail because a new database
could not be created if anyone else was in the template database."

"With this change, the default connection database is now 'postgres',
meaning is is much less likely someone will be using template1 during
CREATE DATABASE."
... meaning it is much less likely ...

There are some items that are appended to the last one. E.g. "Fix
interval division and multiplication (Bruce)"
Other times, the additional comments have their own bullet.

These I don't really understand:
- Improve rtree index capabilities and performance (Neil)
- Replace rtree index code with code from /contrib/rtree_gist (Tom)

So first Neil improved the performance for rtree, then rtree was
replaced with rtree_gist? So Neil's optimizations are gone?

What file should I send patches against next time? ;-)

Best Regards,
Michael Paesold

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Michael Glaesemann

On Aug 23, 2005, at 6:07 PM, Michael Paesold wrote:

> "This caused CREATE DATABASE to sometimes fail because a new  
> database can not be created if anyone else is in the template  
> database."
> Shouldn't this read:
> "This caused CREATE DATABASE to sometimes fail because a new  
> database could not be created if anyone else was in the template  
> database."

iiuc, It's *always* the case that a new database can not be created  
if anyone is connected to template1, so *can not be* is more  
appropriate than *could not be*. It's still the case that if someone  
is connected to template1 when a CREATE DATABASE is issued, the  
command will fail.


Michael Glaesemann
grzm myrealbox com



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
In reply to this post by Bruno Wolff III

Fixed.

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

Bruno Wolff III wrote:

> On Mon, Aug 22, 2005 at 23:16:14 -0400,
>   Bruce Momjian <[hidden email]> wrote:
> > I have compiled the 8.1 release notes and converted them to SGML at:
> >
> >   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
> >
> > I still need to add markup and cleanup, but it is good enough for
> > review and for beta1.  I will work on it more tomorrow.
>
> I spotted a couple of typos:
>
> I think that 'not' should be 'now' in the following:
> In previous releases, the only way to use index for MIN/MAX was to rewrite the query as SELECT col FROM tab ORDER BY col LIMIT 1. This not happens automatically.
>
> I think that 'of' should be 'off' in the following:
> To prevent partial disk writes from corrupting the database, PostgreSQL writes a complete copy of each database disk page to WAL the first time it is modified after a checkpoint. This turns of that functionality for users with battery-backed disk caches where partial page writes can not happen.
>
> I don't think you want a double negative ('not' and 'INconsistant') in the
> following:
> In release 8.0, carriage returns and line feeds in CSV COPY TO were not processed in a inconsitent manner. (This was documented on the TODO list.)
>
> ---------------------------(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
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 2: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
In reply to this post by Oleg Bartunov

Thanks, added.

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

Oleg Bartunov wrote:

> Bruce,
>
> I think I took part in GiST concurrency and recovery project.
>
>   Oleg
> On Mon, 22 Aug 2005, Bruce Momjian wrote:
>
> > I have compiled the 8.1 release notes and converted them to SGML at:
> >
> >  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
> >
> > I still need to add markup and cleanup, but it is good enough for
> > review and for beta1.  I will work on it more tomorrow.
> >
> >
>
>   Regards,
>   Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [hidden email], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 5: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
In reply to this post by Mario Weilguni-3

Fixed.

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

Mario Weilguni wrote:

> JFYI:
>
> "Allow indexes to be used for MIN/MAX (Tom)
>
> In previous releases, the only way to use index for MIN/MAX was to
> rewrite the query as SELECT col FROM tab ORDER BY col LIMIT 1. This not
> happens automatically."
>
> I guess this should read "This now happens automatically"
>
> Regards,
> Mario Weilguni
>
> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of Oleg Bartunov
> Sent: Tuesday, August 23, 2005 9:04 AM
> To: Bruce Momjian
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] 8.1 release notes
>
> Bruce,
>
> I think I took part in GiST concurrency and recovery project.
>
>   Oleg
> On Mon, 22 Aug 2005, Bruce Momjian wrote:
>
> > I have compiled the 8.1 release notes and converted them to SGML at:
> >
> >  
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-
> > 8-1
> >
> > I still need to add markup and cleanup, but it is good enough for
> > review and for beta1.  I will work on it more tomorrow.
> >
> >
>
>   Regards,
>   Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg
> Astronomical Institute, Moscow University (Russia)
> Internet: [hidden email], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Dave Page
In reply to this post by Bruce Momjian-2
Hi Bruce,

Andreas did the initial version of the dbsize integration patch so should be included in the credit for that item.

Regards, Dave


-----Original Message-----
From: "Bruce Momjian"<[hidden email]>
Sent: 23/08/05 04:19:19
To: "PostgreSQL-development"<[hidden email]>
Subject: [HACKERS] 8.1 release notes

I have compiled the 8.1 release notes and converted them to SGML at:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1

I still need to add markup and cleanup, but it is good enough for
review and for beta1.  I will work on it more tomorrow.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 2: Don't 'kill -9' the postmaster



-----Unmodified Original Message-----
I have compiled the 8.1 release notes and converted them to SGML at:

  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1

I still need to add markup and cleanup, but it is good enough for
review and for beta1.  I will work on it more tomorrow.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 2: Don't 'kill -9' the postmaster

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

               http://www.postgresql.org/docs/faq
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
In reply to this post by Michael Paesold
Michael Paesold wrote:

> Bruce Momjian wrote:
> > I have compiled the 8.1 release notes and converted them to SGML at:
> >
> >   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
> >
> > I still need to add markup and cleanup, but it is good enough for
> > review and for beta1.  I will work on it more tomorrow.
>
> I think this is an understatement and does not really say what was done:
> Replace pg_shadow and pg_group by new role-capable catalogs pg_authid
> and pg_auth_members.
>
> I would include something like "Implement SQL-compliant ROLE support...".

Yes, I still need to add text for some of the items.

> I believe "Make default_with_oids default to false" and "Change
> add_missing_from to 'false'" should be mentioned in the "Migration" section.
> This section should say "Migration to version 8.1" instead of "Migration
> to version 8.0".
>
> "This caused CREATE DATABASE to sometimes fail because a new database
> can not be created if anyone else is in the template database."
> Shouldn't this read:
> "This caused CREATE DATABASE to sometimes fail because a new database
> could not be created if anyone else was in the template database."
>
> "With this change, the default connection database is now 'postgres',
> meaning is is much less likely someone will be using template1 during
> CREATE DATABASE."
> ... meaning it is much less likely ...
>
> There are some items that are appended to the last one. E.g. "Fix
> interval division and multiplication (Bruce)"
> Other times, the additional comments have their own bullet.

Above fixed.

> These I don't really understand:
> - Improve rtree index capabilities and performance (Neil)
> - Replace rtree index code with code from /contrib/rtree_gist (Tom)
>
> So first Neil improved the performance for rtree, then rtree was
> replaced with rtree_gist? So Neil's optimizations are gone?

I was wondering about this too. I will add a ? to the item.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
In reply to this post by Dave Page

Thanks, added.

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

Dave Page wrote:

> Hi Bruce,
>
> Andreas did the initial version of the dbsize integration patch so should be included in the credit for that item.
>
> Regards, Dave
>
>
> -----Original Message-----
> From: "Bruce Momjian"<[hidden email]>
> Sent: 23/08/05 04:19:19
> To: "PostgreSQL-development"<[hidden email]>
> Subject: [HACKERS] 8.1 release notes
>
> I have compiled the 8.1 release notes and converted them to SGML at:
>
>   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   [hidden email]               |  (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 2: Don't 'kill -9' the postmaster
>
>
>
> -----Unmodified Original Message-----
> I have compiled the 8.1 release notes and converted them to SGML at:
>
>   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   [hidden email]               |  (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 2: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Havasvölgyi Ottó
In reply to this post by Bruce Momjian-2
Bruce,

I have also noticed a small error:

a.. Remove old *.backup files when we do pg_stop_backup() (Bruce)

a.. This prevents a large number of *.backup files from existing in
pg_xlog/.

I think there should not be a point on the left of the second line because
it's the details of the first line.

Best Regards,

Otto


----- Original Message -----
From: "Bruce Momjian" <[hidden email]>
To: "PostgreSQL-development" <[hidden email]>
Sent: Tuesday, August 23, 2005 5:16 AM
Subject: [HACKERS] 8.1 release notes


>I have compiled the 8.1 release notes and converted them to SGML at:
>
>  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.
>
> --
>  Bruce Momjian                        |  http://candle.pha.pa.us
>  [hidden email]               |  (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 2: Don't 'kill -9' the postmaster
>
>



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Andrew Dunstan
In reply to this post by Bruce Momjian-2


Bruce Momjian wrote:

>I have compiled the 8.1 release notes and converted them to SGML at:
>
>  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
>I still need to add markup and cleanup, but it is good enough for
>review and for beta1.  I will work on it more tomorrow.
>  
>

A couple of (other) items I have been involved with that might deserve a
mention:

. pl/perl support for strict mode
. improved regression framework, - separate db names for separate suites
(standard regression, PL, contrib), loadable languages, standardised
framework for PLs.

(We're still working in strict mode but we'll get it fixed in the next
few days)

And I am not sure if this counts as a bug fix or a feature :-) :

. pl/perl logging of non-fatal warnings

cheers

andrew


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2
Andrew Dunstan wrote:

>
>
> Bruce Momjian wrote:
>
> >I have compiled the 8.1 release notes and converted them to SGML at:
> >
> >  http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
> >
> >I still need to add markup and cleanup, but it is good enough for
> >review and for beta1.  I will work on it more tomorrow.
> >  
> >
>
> A couple of (other) items I have been involved with that might deserve a
> mention:
>
> . pl/perl support for strict mode

That was completed after I pulled CVS, I think.  It will be updated
later.

> . improved regression framework, - separate db names for separate suites
> (standard regression, PL, contrib), loadable languages, standardised
> framework for PLs.

That isn't something we usually mention in the release notes, but I can
under "source code".

> (We're still working in strict mode but we'll get it fixed in the next
> few days)
>
> And I am not sure if this counts as a bug fix or a feature :-) :
>
> . pl/perl logging of non-fatal warnings

Uh, not really.  I saw the commit message but what does it mean?
--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Tom Lane-2
In reply to this post by Michael Paesold
Michael Paesold <[hidden email]> writes:
> These I don't really understand:
> - Improve rtree index capabilities and performance (Neil)
> - Replace rtree index code with code from /contrib/rtree_gist (Tom)

Not sure how Bruce got the latter out of this commit message:

        Migrate rtree_gist functionality into the core system, and add some
        basic regression tests for GiST to the standard regression tests.

All that's really happened is that GiST actually has a couple of
opclasses in the core system now, whereas previously they were all
contrib (meaning that GiST was dead weight in a standard installation).

It's also now true that everything you can do with the standard rtree
opclasses, you can do with standard GiST opclasses.

There was some talk of obsoleting rtree further down the road, but it
isn't happening in 8.1.  If no serious bugs crop up in all the new GiST
work Teodor and Oleg did, we might consider obsoleting rtree in 8.2.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2

OK, updated.  When I read "migrate" I thought "move".

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

Tom Lane wrote:

> Michael Paesold <[hidden email]> writes:
> > These I don't really understand:
> > - Improve rtree index capabilities and performance (Neil)
> > - Replace rtree index code with code from /contrib/rtree_gist (Tom)
>
> Not sure how Bruce got the latter out of this commit message:
>
> Migrate rtree_gist functionality into the core system, and add some
> basic regression tests for GiST to the standard regression tests.
>
> All that's really happened is that GiST actually has a couple of
> opclasses in the core system now, whereas previously they were all
> contrib (meaning that GiST was dead weight in a standard installation).
>
> It's also now true that everything you can do with the standard rtree
> opclasses, you can do with standard GiST opclasses.
>
> There was some talk of obsoleting rtree further down the road, but it
> isn't happening in 8.1.  If no serious bugs crop up in all the new GiST
> work Teodor and Oleg did, we might consider obsoleting rtree in 8.2.
>
> regards, tom lane
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Andrew Dunstan
In reply to this post by Bruce Momjian-2


Bruce Momjian wrote:

>>
>>. pl/perl support for strict mode
>>    
>>
>
>That was completed after I pulled CVS, I think.  It will be updated
>later.
>
>  
>

Actually, it snuck in with one of Abhijit's patches.


>>And I am not sure if this counts as a bug fix or a feature :-) :
>>
>>. pl/perl logging of non-fatal warnings
>>    
>>
>
>Uh, not really.  I saw the commit message but what does it mean?
>  
>

Before this patch, any non-fatal perl warning, either generated by perl
itself of by the user calling the builtin function warn(), was dropped
in the bit bucket. Now it is logged at NOTICE level.

cheers

andrew



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Bruce Momjian-2

Added.  Thanks.

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

Andrew Dunstan wrote:

>
>
> Bruce Momjian wrote:
>
> >>
> >>. pl/perl support for strict mode
> >>    
> >>
> >
> >That was completed after I pulled CVS, I think.  It will be updated
> >later.
> >
> >  
> >
>
> Actually, it snuck in with one of Abhijit's patches.
>
>
> >>And I am not sure if this counts as a bug fix or a feature :-) :
> >>
> >>. pl/perl logging of non-fatal warnings
> >>    
> >>
> >
> >Uh, not really.  I saw the commit message but what does it mean?
> >  
> >
>
> Before this patch, any non-fatal perl warning, either generated by perl
> itself of by the user calling the builtin function warn(), was dropped
> in the bit bucket. Now it is logged at NOTICE level.
>
> cheers
>
> andrew
>
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [hidden email]               |  (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 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
Reply | Threaded
Open this post in threaded view
|

Re: 8.1 release notes

Jim C. Nasby
In reply to this post by Bruce Momjian-2
On Mon, Aug 22, 2005 at 11:16:14PM -0400, Bruce Momjian wrote:
> I have compiled the 8.1 release notes and converted them to SGML at:
>
>   http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> I still need to add markup and cleanup, but it is good enough for
> review and for beta1.  I will work on it more tomorrow.

Is a dump/restore required for upgrading from 8.0.x? It might be nice to
note what features require this (2PC?).
--
Jim C. Nasby, Sr. Engineering Consultant      [hidden email]
Pervasive Software        http://pervasive.com        512-569-9461

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

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