PostgreSQL Beta Testers Needed

aliensexfiend writes ""PostgreSQL Beta Testing has begun. The more testers, the merrier. Read the announcement page as well as the Beta info page. Interesting new features include a new Binary I/O protocol, ability to inline simple SQL functions, and an error message wording scheme that provides 3 layers of detail!!.""

Comments

Some changes in psql 7.4

[zaqattack911]

In case you are interested, but don't want to hunt around. Here are the list of changes in 7.4 devel branch:

Server Operation

Allow IPv6 server connections (Nigel Kukard, Johan Jordaan, Bruce, Tom, Kurt
Roeckx, Andrew Dunstan)
Fix SSL to handle errors cleanly (Nathan Mueller)
SSL protocol security and performance improvements (Sean Chittenden)
Print lock information when a deadlock is detected (Tom)
Update /tmp socket mod. times regularly to avoid their removal (Tom)
Enable PAM for MAC OS X (Aaron Hillegass)
Make btree indexes fully WAL-safe (Tom)
Allow btree index compaction and empty page reuse (Tom)
Fix inconsistent index lookups during split of first root page (Tom)
Improve free space map allocation logic (Tom)
Preserve free space information between postmaster restarts (Tom)
Set proper schema permissions in initdb (Peter)
Add start time to pg_stat_activity (Neil)
New code to detect corrupt disk pages; erase with zero_damaged_pages (Tom)
New client/server protocol: faster, no username length limit, allow
clean exit from COPY (Tom)
Add transaction status, tableid, columnid to backend protocol (Tom)
Add new binary I/O protocol (Tom)
Remove autocommit server setting; move to client applications (Tom)
New error message wording, error codes, and three levels of error detail (Tom)

__________________________________________________ _______________

Performance

Add hashing for GROUP BY aggregates (Tom)
Allow nested loops to be smarter about multicolumn indexes (Tom)
Allow multi-key hash joins (Tom)
Improve constant folding (Tom)
Add ability to inline simple SQL functions (Tom)
Reduce memory usage for queries using complex functions (Tom)
Improve GEQO optimizer performance (Tom)
Allow IN/NOT IN to be handled via hash tables (Tom)
Improve NOT IN (subquery) performance (Tom)
Allow most IN subqueries to be processed as joins (Tom)
Allow the postmaster to preload libraries using preload_libraries (Joe)
Improve optimizer cost computations, particularly for subqueries (Tom)
Avoid sort when subquery ORDER BY matches upper query (Tom)
Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom)
Allow hash/merge joins on complex joins (Tom)
Allow hash joins for more data types (Tom)
Allow join optimization of ANSI joins, disable with join_collapse_limit (Tom)
Add from_collapse_limit to control conversion of subqueries to joins (Tom)
Use faster regex code from TCL (Henry Spencer, Tom)
Use bit-mapped relation sets in the optimizer (Tom)
Improve backend startup time (Tom)
Improve trigger/constraint performance (Stephan)

__________________________________________________ _______________

Server Configuration

Rename server parameter server_min_messages to log_min_messages (Bruce)
Rename show_*_stats to log_*_stats (Bruce)
Rename show_source_port to log_source_port (Bruce)
Rename hostname_lookup to log_hostname (Bruce)
Add checkpoint_warning to warn of excessive checkpointing (Bruce)
New read-only server parameters for localization (Tom)
Change debug server log messages to output as DEBUG rather than LOG (Bruce)
Prevent server log variables from being turned off by non-super users (Bruce)
log_min_messages/client_min_messages now controls debug_* output (Bruce)
Add Rendezvous server support (Chris Campbell)
Add ability to print only slow statements using log_min_duration_statement
(Christopher)
Allow pg_hba.conf to accept netmasks in CIDR format (Andrew Dunstan)
New is_superuser read-only variable (Tom)
New server-side parameter log_error_verbosity to control error detail (Tom)
postgres --help-config now dumps server config variables (Aizaz Ahmed)
Make default shared_buffers 1000 and max_connections 100, if possible (Tom)
Add new columns in pg_settings: context, type, source , min_val, max_val (Joe)
New pg_hba.conf 'hostnossl' to

Re:Some changes in psql 7.4

[rtaylor]

I'm afraid 'big features' aren't really in this release. There are a large number of small but important features but the importance list changes depending on who you are.

A number of people are happy to have decent DOMAIN support.

Others are happy to have indexes that don't grow unbounded (vacuum will clean them up now).

Developers are happy to have much improved error handling and optimizer corrections (a little smarter with some corner cases).

Folks with odd data or performance requirements are happy to have the dramatically improved ARRAY support.

My personal favorite is the Transaction safe Truncate.

This release is more about rounding off some of the sharp edges than a marketing feature box hunt.

But remember that's rather old

[abulafia]

That's a pretty old comparison; both PG and Mysql have changed a lot since then.