Novo PostgreSQL versão 8.3
Postado no Fevereiro 5, 2008 de flaviobrito
Saiu a tão esperada versão 8.3 do PostgreSQL. Ficamos muitos meses a espera desta versão, pois trata-se de um marco na tecnologia deste banco. Para se ter uma idéia, esta última versão traz grandes saltos tecnológicos. Acompanhe os comentários abaixo e veja a tabela.
| Recursos | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
|---|---|---|---|---|---|
| Advisory locks | No | No | No | Yes | Yes |
| Autovacuum enabled by default | No | No | No | No | Yes |
| COPY with arbitrary SELECT | No | No | No | Yes | Yes |
| CSV support for COPY | No | Yes | Yes | Yes | Yes |
| Changing column types (ALTER TABLE .. ALTER COLUMN TYPE) | No | Yes | Yes | Yes | Yes |
| Concurrent GiST indexes | No | No | Yes | Yes | Yes |
| Crash-safe GiST indexes | No | No | Yes | Yes | Yes |
| DROP object IF EXISTS | No | No | No | Yes | Yes |
| Dollar Quoting | No | Yes | Yes | Yes | Yes |
| Holdable cursors | Yes | Yes | Yes | Yes | Yes |
| INSERT/UPDATE/DELETE RETURNING | No | No | No | Yes | Yes |
| Integrated autovacuum daemon | No | No | Yes | Yes | Yes |
| Loadable plugin infrastructure for monitoring the planner | No | No | No | No | Yes |
| MVCC safe CLUSTER | No | No | No | No | Yes |
| Multiple autovacuum workers | No | No | No | No | Yes |
| Multiple input aggregates | No | No | No | Yes | Yes |
| Multirow VALUES | No | No | No | Yes | Yes |
| ON COMMIT clause for CREATE TEMPORARY TABLE | Yes | Yes | Yes | Yes | Yes |
| ORDER BY NULLS FIRST/LAST | No | No | No | No | Yes |
| Point-in-Time Recovery | No | Yes | Yes | Yes | Yes |
| Row-wise comparison | No | No | No | Yes | Yes |
| SQL-standard information schema | Yes | Yes | Yes | Yes | Yes |
| Savepoints | No | Yes | Yes | Yes | Yes |
| Temporary VIEWs | No | No | Yes | Yes | Yes |
| Two Phase commit | No | No | Yes | Yes | Yes |
| Txid functions | No | No | No | No | Yes |
| Updateable cursors | No | No | No | No | Yes |
| WAL-safe B-Tree Indexes | Yes | Yes | Yes | Yes | Yes |
| Warm Standby | No | No | No | Yes | Yes |
| Performance | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| Asynchronous Commit | No | No | No | No | Yes |
| Automatic plan invalidation | No | No | No | No | Yes |
| Background Writer | No | Yes | Yes | Yes | Yes |
| Cross datatype hashing support | No | No | No | No | Yes |
| Distributed checkpointing | No | No | No | No | Yes |
| Full Text Search | No | No | No | No | Yes |
| GIN (Generalized Inverted Index) Indexes | No | No | No | Yes | Yes |
| GiST (Generalized Search Tree) Indexes | Yes | Yes | Yes | Yes | Yes |
| Hashing support for NUMERIC | No | No | No | No | Yes |
| Heap Only Tuples (HOT) | No | No | No | No | Yes |
| In-memory Bitmap Indexes | No | No | Yes | Yes | Yes |
| Index support for IS NULL | No | No | No | No | Yes |
| Indexes on expressions | Yes | Yes | Yes | Yes | Yes |
| Inlining of SQL-functions | Yes | Yes | Yes | Yes | Yes |
| Lazy XID allocation | No | No | No | No | Yes |
| Multiple temporary tablespaces | No | No | No | No | Yes |
| Non-blocking CREATE INDEX | No | No | No | Yes | Yes |
| Outer Join reordering | No | No | No | Yes | Yes |
| Partial sort capability (top-n sorting) | No | No | No | No | Yes |
| SELECT … FOR UPDATE/SHARE NOWAIT | No | No | Yes | Yes | Yes |
| Shared row level locking | No | No | Yes | Yes | Yes |
| Synchronized sequential scanning | No | No | No | No | Yes |
| Table partitioning | No | No | Yes | Yes | Yes |
| Tablespaces | No | Yes | Yes | Yes | Yes |
| Segurança | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| GSSAPI support | No | No | No | No | Yes |
| Native LDAP authentication | No | No | No | Yes | Yes |
| Per user/database connection limits | No | No | Yes | Yes | Yes |
| ROLES | No | No | Yes | Yes | Yes |
| Security Service Provider Interface (SSPI) | No | No | No | No | Yes |
| Rede | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| Full SSL support | Yes | Yes | Yes | Yes | Yes |
| IPv6 Support | Yes | Yes | Yes | Yes | Yes |
| V2 client protocol | Yes | Yes | Yes | Yes | Yes |
| V3 client protocol | Yes | Yes | Yes | Yes | Yes |
| Internationalização | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| EUC_JIS_2004/ SHIFT_JIS_2004 support | No | No | No | No | Yes |
| Multibyte encoding support, incl. UTF8 | Yes | Yes | Yes | Yes | Yes |
| Multiple language support | Yes | Yes | Yes | Yes | Yes |
| UTF8 support on Windows | No | No | Yes | Yes | Yes |
| Plataformas | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| Microsoft Visual C++ Support | No | No | No | No | Yes |
| Native Windows Port | No | Yes | Yes | Yes | Yes |
| Tipos de Dados | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| Array support | Yes | Yes | Yes | Yes | Yes |
| Arrays of compound types | No | No | No | No | Yes |
| ENUM data type | No | No | No | No | Yes |
| GUID/UUID data type | No | No | No | No | Yes |
| NULLs in Array | No | No | No | Yes | Yes |
| Type modifier support | No | No | No | No | Yes |
| XML data type | No | No | No | No | Yes |
| Funções e Triggers | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| ALTER TABLE / ENABLE REPLICA TRIGGER/RULE | No | No | No | No | Yes |
| ALTER TABLE ENABLE/DISABLE TRIGGER | No | No | Yes | Yes | Yes |
| Per-function GUC settings | No | No | No | No | Yes |
| Statement level triggers | Yes | Yes | Yes | Yes | Yes |
| Linguagens | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| CONTINUE statement for pl/pgsql | No | No | Yes | Yes | Yes |
| EXCEPTION support in pl/pgsql | No | Yes | Yes | Yes | Yes |
| IN/OUT/INOUT parameters for pl/pgsql and pl/SQL | No | No | Yes | Yes | Yes |
| Named parameters | No | Yes | Yes | Yes | Yes |
| Non-superuser language creation | No | No | No | No | Yes |
| Number of function arguments increased to 100 | No | No | Yes | Yes | Yes |
| Polymorphic functions | Yes | Yes | Yes | Yes | Yes |
| Qualified function parameters | No | No | No | No | Yes |
| RETURN QUERY in pl/pgsql | No | No | No | No | Yes |
| ROWS and COST specification for functions | No | No | No | No | Yes |
| SQLERRM/SQLSTATE for pl/pgsql | No | No | Yes | Yes | Yes |
| Scrollable and updatable cursor support for pl/pgsql | No | No | No | No | Yes |
| Validator function for pl/perl | No | No | Yes | Yes | Yes |
| Módulos Adicionais | 7.4 | 8.0 | 8.1 | 8.2 | 8.3 |
| contrib/adminpack | No | No | No | Yes | Yes |
| contrib/btree_gist | No | Yes | Yes | Yes | Yes |
| contrib/dblink | Yes | Yes | Yes | Yes | Yes |
| contrib/dbsize | Yes | Yes | Obsolete | Obsolete | Obsolete |
| contrib/fuzzystrmatch | Yes | Yes | Yes | Yes | Yes |
| contrib/hstore | No | No | No | Yes | Yes |
| contrib/intarray | Yes | Yes | Yes | Yes | Yes |
| contrib/isn (ISBN) | No | No | No | Yes | Yes |
| contrib/ltree | Yes | Yes | Yes | Yes | Yes |
| contrib/pageinspect | No | No | No | No | Yes |
| contrib/pg_autovacuum | Yes | Yes | Obsolete | Obsolete | Obsolete |
| contrib/pg_buffercache | No | No | Yes | Yes | Yes |
| contrib/pg_freespacemap | No | No | No | Yes | Yes |
| contrib/pg_standby | No | No | No | No | Yes |
| contrib/pg_trgm | No | Yes | Yes | Yes | Yes |
| contrib/pgbench | Yes | Yes | Yes | Yes | Yes |
| contrib/pgstattuple | Yes | Yes | Yes | Yes | Yes |
| contrib/seg | Yes | Yes | Yes | Yes | Yes |
| contrib/sslinfo | No | No | No | Yes | Yes |
| contrib/tablefunc | Yes | Yes | Yes | Yes | Yes |
| contrib/tsearch2 | Yes | Yes | Yes | Yes | Obsolete |
| contrib/tsearch2 UTF8 support | No | No | No | Yes | Obsolete |
| contrib/tsearch2 compat wrapper | No | No | No | No | Yes |
| contrib/userlocks | Yes | Yes | Yes | Obsolete | Obsolete |
| contrib/uuid-ossp | No | No | No | No | Yes |
| contrib/xml2 | No | Yes | Yes | Yes | Yes |
Arquivado em: Bancos de Dados | Tagged: Banco de Dados, Database, PostgreSQL
