What's new in 8.3

From: Jim Nasby <decibel(at)decibel(dot)org>
To: PostgreSQL Advocacy List <pgsql-advocacy(at)postgresql(dot)org>
Subject: What's new in 8.3
Date: 2007-07-20 05:22:49
Message-ID: FD07DEE1-1F5D-4882-84C4-24F3A040D141@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

This is the list I'm working off of for the "What's New in 8.3"
lightning talk at OSCon. I'm going to kind-of lump all the
performance stuff together (and most of that is going to get a very,
very quick overview), and blitz through the improved statistics stuff
in like 10 seconds... everything else I'm going to essentially go
through in the order shown here, and whatever I can fit in in the
time remaining is what makes it in. So, two questions...

1) Am I missing anything? (I'm not going to mention anything that
hasn't been committed unless it's *really* big; namely HOT and tsearch)
2) Any *serious* issues with the ordering?

Keep in mind that this is 100% targeted at *end users*, so these need
to be ranked on how much they'll affect them. There's tons of patches
that haven't even made this list not because they're not important,
but because they just won't have that big of a direct impact on end
users. Performance stuff sort of falls into this category... people
care a lot about how performance has improved, but far less about how
it was actually done (plus 5 minutes is nowhere near enough to do any
justice to most of the performance stuff).

* indicates feature isn't committed yet

Integrated tsearch2*
XML
UUID / ENUM
Sort order / NULLs first/last in indexes
UPDATE/DELETE WHERE CURRENT OF cursor_name
Arrays of compound types
Functional costing
Index advisor -- Does this actually do anything useful yet, or is it
just backend hooks?
pg_standby
improved regex support (regexp_matches, regexp_split_to_array,
regexp_split_to_table)
CREATE TABLE LIKE INCLUDING INDEXES
GSSAPI
Operator families
Make CLUSTER MVCC safe

Performance
HOT*
Autovac workers
plan cache
SyncScan
distributed checkpoint
cmin/cmax combination
varvarlena

Improved stats info
tuple stats in pg_stat_database
bgwriter
lock wait logging
pg_stat_all_tables.n_live_tuples, n_dead_tuples
log_temp_files
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Jim Nasby 2007-07-20 05:57:27 Information Week article on PostgreSQL benchmark
Previous Message Jim Nasby 2007-07-20 04:58:35 8.2 -> 8.3 performance numbers