Re: What's new in 8.3

On Jul 20, 2007, at 2:08 AM, Stefan Kaltenbrunner wrote:
>> Integrated tsearch2*
>
> this will be simply called text search or so once it got integrated ?

Well, either way I'll be calling it full text search.

>> XML
>> UUID / ENUM
>
> for UUID we also have contrib/uuid-ossp

Too much detail...

>> Sort order / NULLs first/last in indexes
>> UPDATE/DELETE WHERE CURRENT OF cursor_name
>
> aka updateable cursors (also in plpgsql)

Yup.

>> Arrays of compound types
>> Functional costing
>> Index advisor -- Does this actually do anything useful yet, or is it
>> just backend hooks?
>
> http://pgfoundry.org/projects/pgadviser/

Ahh, thanks.

> full MSVC++ support (big one for some developers)
> improved support for replication solutions (ie the session controlable
> trigger firing stuff)

Yeah, but that's not really user-visible.

> plan invalidation

Well, it's the plan cache that's important to folks...

> index support for IS NULL

Already got it.

> scrollable cursors in pl/pgsql
> hashing support for NUMERIC
> RESET SESSION/TEMP/PLANS
>
>>
>> Performance
>> HOT*
>> Autovac workers
>> plan cache
>> SyncScan
>> distributed checkpoint
>> cmin/cmax combination
>> varvarlena
>
> faster multibyte text matching
> multiple temporary tablespaces
>
>>
>> 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
>
> contrib/pageinspect (probably out of scope for endusers)

Yup. :)
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)