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)
