Skip site navigation (1) Skip section navigation (2)

Re: [Fwd: Re: [CORE] Going Beta on Monday ...]

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Fwd: Re: [CORE] Going Beta on Monday ...]
Date: 2000-12-04 19:45:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Macaddr manufacturer table update now in SQL table
syslog configurability improvements.
* Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)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           
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-12-04 20:24:06
Subject: Re: AW: AW: broken locale in 7.0.2 without multibyte suppor t (F reeBSD 4.1-RELEASE) ?
Previous:From: Thomas LockhartDate: 2000-12-04 19:31:27
Subject: [Fwd: Re: [CORE] Going Beta on Monday ...]

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group