Документ взят из кэша поисковой машины. Адрес оригинального документа : http://www.sai.msu.su/~megera/postgres/talks/kbd2008-pg84plans.pdf
Дата изменения: Tue Apr 15 23:55:35 2008
Дата индексирования: Sat Sep 6 06:11:34 2008
Кодировка:

Поисковые слова: http www.badastronomy.com phpbb index.php
PostgreSQL news


EnterprizeDB 2008


10 . IBM Rebranding Enterprize DB


Postgres Plus -- A true Enterprise Open Source DB GridSQL -- Grid Postgres Plus Advanced Server --


Cloud Edition (Elastra) , DynaTune --

PostgreSQL -- 2008


PostgreSQL news


XDI Applience -- postgreSQL with support of shared-nothing parallel cluster envrionment with FPGA acceleration




1GB/s SQL query per Node (TPC-H) 1TB/min sustained SQL query 19 inch server rack Decision Support Systems, Full table scan, Group By, Order By, Aggregation, multitable joins

PostgreSQL -- 2008


PostgreSQL news


XDI Appliance -- 750,000 USD

PostgreSQL -- 2008


PostgreSQL 8.4:


: 2008 - 2009 Wishlist 8.4


http://developer.postgresql.org/index.php/Todo:WishlistFor84



Patch Status 8.4


http://wiki.postgresql.org/wiki/Todo:PatchStatus



CommitFest


http://wiki.postgresql.org/wiki/CommitFest:March http://wiki.postgresql.org/wiki/CommitFest:May



Feature Matrix


http://www.postgresql.org/about/featurematrix

PostgreSQL -- 2008


PostgreSQL 8.4: plans


TOAST (+)


min_input_size=32 ( 256 ) Req. ompression rate = 25% ( 20%) -- 10% ts_rank() -- ,



Concurrent psql (+)




PostgreSQL -- 2008


PostgreSQL 8.4: plans


Index AM




lossy @ run time (+) GIT -- Group Index Tuples (?)


, tuple @@@ - tsvector @@@ 'star:a'::tsquery GiST index - lossy



GIN/GiST index






On-disk Bitmap index (?)

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Index AM


GIN Partial Match (+) - opclasses:




Prefix Search: to_tsquery('star:*'), API wildcard wildcard search - LIKE '%asd%' full scan, '!foo'.



GIN -- gin_stat (. gevel) (+)


0.5 s ~ 450,000



Improvement of GIN insertion speed GIN multicolumn index support

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Index AM


GiST (?)


-- KNN-search , SP-GiST ,



GiST bulk insert (?)


PostgreSQL -- 2008


PostgreSQL 8.4: plans


FTS


Middleware -- HTML- 4 16 tsvector- GiSTarray -- intarray Ltree, pg_trgm -- UTF-8








PostgreSQL -- 2008


PostgreSQL 8.4: plans


Group Commit (??? async. Commit 8.3)


WAL flush SQL:2003



Windowing functions (?)




Table function support (?)
RETURN TABLE(SELECT * FROM Foo WHERE x < a);



PL/PgPSM ( SQL/PSM) (?) - SQL3 EXECUTE USING -- (+)

PostgreSQL -- 2008


PostgreSQL 8.4: plans




ON TRUNCATE triggers - TRUNCATE TABLE (+) psql (+)


\d table_name -- FK \l+ - tablespace, tab-completion


a: UPDATE foo.bar SET Quoted name: UPDATE "foo" SET

PostgreSQL -- 2008


PostgreSQL 8.4: plans





FSM DSM VM SVM

- free space map -- dead space map Visibility Map - Segment Visibility Map






Partial Vacuum Index-only scans Automatic Partitioning

PostgreSQL -- 2008


PostgreSQL 8.4: plans


DSM -- Dead Space Map (?)




FSM, (bgwriter) , (dead tuples) Vacuum DSM - Vacuum ALL --

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Visibility Map (VM) (?)


Index-only scans




, bitmap (1bit/page) -- 1 -- , 0 - .



-- :


dead tuples (vacuum) non-frozen tuples (vacuum freeze)

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Segment Visibility Map (?) -- 100% -- pg_svm, 1Gb
http://wiki.postgresql.org/wiki/Segment_Visibility_Map


2 ( )


rw,ro,ro_pending, ro_frozen - explicitly marked read only, clustered, compressed, offline



DSM, Visibility Map ?

PostgreSQL -- 2008


PostgreSQL 8.4: plans


(partitioning) (?)




- constraints view/inheritance, constraints -- constraints , .

PostgreSQL -- 2008


PostgreSQL 8.4: plans


(partitioning) (?)


:


read-only (bulk delete)



(1Gb) read-only (SVM)

PostgreSQL -- 2008


PostgreSQL 8.4: plans


(partitioning) (?)




read-only min/max , SeqScan (Segment Exclusion) , -- transaction date, sequences,...

PostgreSQL -- 2008


PostgreSQL 8.4: plans
Select count(*) from Foo where id >10 and id <=50;

Scan segment min/max 0 10 50

Scan always

12

3

4 *****

96 97 98

99 100

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Security Enhanced (SE) PostgreSQL (?)


SELinux ,

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Security Enhanced PostgreSQL

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Security Enhanced PostgreSQL

PostgreSQL -- 2008


PostgreSQL 8.4: plans


Column level privileges (?)




GRANT, REVOKE on INSERT,UPDATE, REFERENCES. SELECT \z (\dp) -- psql Call counts, duration,...



Stored procedures stats


=# select * from pg_stat_user_functions ; procid | schemaname | procname | nargs | calls | total_time | total_cpu | self_time | self_cpu --------+------------+----------+-------+-------+------------+-----------+-----------+---------16388 | public | f1 | 0 | 4000 | 14978 | 8352 | 14978 | 8352 16389 | public | f2 | 0 | 2000 | 40044 | 8364 | 25066 | 12 16390 | public | f3 | 0 | 1000 | 40054 | 8364 | 9| 0 (3 rows)

PostgreSQL -- 2008





TODO- (, )


http://www.sai.msu.su/~megera/wiki/TODO http://www.sai.msu.su/~megera/wiki/wildspeed



WildSpeed




Gevel http://www.sai.msu.su/~megera/wiki/Gevel Waiting for 8.4 by depesz (Hubert Lubaczewski) http://www.depesz.com/index.php/tag/pg84/



PostgreSQL -- 2008





Dead Space Map


http://archives.postgresql.org/pgsql-hackers/2006-12/msg01188.ph



Visibility Map


http://archives.postgresql.org/pgsqlhackers/2007-11/msg00142.php



Segment Visibility Map


http://wiki.postgresql.org/wiki/Segment_Visibility_Map



Dynamic Partitioning


http://archives.postgresql.org/pgsqlhackers/2008-01/msg00028.php

PostgreSQL -- 2008