Обсуждение: [Fwd: Re: [CORE] Going Beta on Monday ...]
> I browsed through the CVS logs and made this list of the important > stuff. There's a ton of less important stuff... Shall we consider this the start of the list then? I think there may be a couple of things already mentioned in the release note stubs for 7.1 too. - Thomas Additional items: AT TIME ZONE clause for date/time types OVERLAPS operator support rewritten WAL --- fsync reliability without the performance hit TOAST --- 8K row limit is no longer significant outer joins (per SQL92 syntax, not Oracle's) subselects in FROM clause views and subselects now allow union/intersect/except, order by, limit views containing grouping, aggregates, DISTINCT work now bit-string types work now function manager overhaul: fixes portability problems, NULL-argument handling memory management overhaul: prevent memory leak accumulation during queries drop table and rename table are now rollback-able (transaction-safe) extensive overhaul of configure/build mechanism overhaul of parameter-setting mechanisms (postmaster flags, postmaster.opts,etc) more efficient large-object implementation pg_dump can dump large objects now pg_dump does the right thing with user-added objects in template1 support for binding postmaster's IP socket to a virtual host name support for placing postmaster's Unix socket file elsewhere than /tmp keep reference counts on syscache entries to avoid dropping still-used entries Protect against changes in LOCALE environment causing corrupted indexes better handling of unknown-type literals (default to string type more readily) inet/cidr datatypes cleaned up LIKE/ESCAPE implemented, also ILIKE (case-insensitive LIKE) aggregate-function support redesigned: only one transition function now,cleaner handling of NULLs STDDEV() and VARIANCE() aggregates added SUM() and AVG() on integer datatypes use NUMERIC accumulators Child tables are now scanned by default -- ie, if foo has children thenSELECT FROM foo means SELECT FROM foo*. Ditto forUPDATE and DELETE.Use SELECT FROM ONLY foo if you don't want this behavior. vacuum analyze does the analyze part without holding exclusive lock
Macaddr manufacturer table update now in SQL table syslog configurability improvements. * Thomas Lockhart <lockhart@alumni.caltech.edu> [001204 13:42]: > > I browsed through the CVS logs and made this list of the important > > stuff. There's a ton of less important stuff... > > Shall we consider this the start of the list then? I think there may be > a couple of things already mentioned in the release note stubs for 7.1 > too. > > - Thomas > > Additional items: > > AT TIME ZONE clause for date/time types > OVERLAPS operator support rewritten > > WAL --- fsync reliability without the performance hit > TOAST --- 8K row limit is no longer significant > outer joins (per SQL92 syntax, not Oracle's) > subselects in FROM clause > views and subselects now allow union/intersect/except, order by, limit > views containing grouping, aggregates, DISTINCT work now > bit-string types work now > function manager overhaul: fixes portability problems, NULL-argument > handling > memory management overhaul: prevent memory leak accumulation during > queries > drop table and rename table are now rollback-able (transaction-safe) > extensive overhaul of configure/build mechanism > overhaul of parameter-setting mechanisms (postmaster flags, > postmaster.opts, > etc) > more efficient large-object implementation > pg_dump can dump large objects now > pg_dump does the right thing with user-added objects in template1 > support for binding postmaster's IP socket to a virtual host name > support for placing postmaster's Unix socket file elsewhere than /tmp > keep reference counts on syscache entries to avoid dropping still-used > entries > Protect against changes in LOCALE environment causing corrupted indexes > better handling of unknown-type literals (default to string type more > readily) > inet/cidr datatypes cleaned up > LIKE/ESCAPE implemented, also ILIKE (case-insensitive LIKE) > aggregate-function support redesigned: only one transition function now, > cleaner handling of NULLs > STDDEV() and VARIANCE() aggregates added > SUM() and AVG() on integer datatypes use NUMERIC accumulators > Child tables are now scanned by default -- ie, if foo has children then > SELECT FROM foo means SELECT FROM foo*. Ditto for UPDATE and DELETE. > Use SELECT FROM ONLY foo if you don't want this behavior. > vacuum analyze does the analyze part without holding exclusive lock -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
I will work on a list this week. It will have the same format as usual, if that is OK. > > I browsed through the CVS logs and made this list of the important > > stuff. There's a ton of less important stuff... > > Shall we consider this the start of the list then? I think there may be > a couple of things already mentioned in the release note stubs for 7.1 > too. > > - Thomas > > Additional items: > > AT TIME ZONE clause for date/time types > OVERLAPS operator support rewritten > > WAL --- fsync reliability without the performance hit > TOAST --- 8K row limit is no longer significant > outer joins (per SQL92 syntax, not Oracle's) > subselects in FROM clause > views and subselects now allow union/intersect/except, order by, limit > views containing grouping, aggregates, DISTINCT work now > bit-string types work now > function manager overhaul: fixes portability problems, NULL-argument > handling > memory management overhaul: prevent memory leak accumulation during > queries > drop table and rename table are now rollback-able (transaction-safe) > extensive overhaul of configure/build mechanism > overhaul of parameter-setting mechanisms (postmaster flags, > postmaster.opts, > etc) > more efficient large-object implementation > pg_dump can dump large objects now > pg_dump does the right thing with user-added objects in template1 > support for binding postmaster's IP socket to a virtual host name > support for placing postmaster's Unix socket file elsewhere than /tmp > keep reference counts on syscache entries to avoid dropping still-used > entries > Protect against changes in LOCALE environment causing corrupted indexes > better handling of unknown-type literals (default to string type more > readily) > inet/cidr datatypes cleaned up > LIKE/ESCAPE implemented, also ILIKE (case-insensitive LIKE) > aggregate-function support redesigned: only one transition function now, > cleaner handling of NULLs > STDDEV() and VARIANCE() aggregates added > SUM() and AVG() on integer datatypes use NUMERIC accumulators > Child tables are now scanned by default -- ie, if foo has children then > SELECT FROM foo means SELECT FROM foo*. Ditto for UPDATE and DELETE. > Use SELECT FROM ONLY foo if you don't want this behavior. > vacuum analyze does the analyze part without holding exclusive lock > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026