Документ взят из кэша поисковой машины. Адрес оригинального документа : 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