FreeOZ论坛

标题: 数据库界的大象要出新版了 [打印本页]

作者: coredump 时间: 14-5-2010 16:47
标题: 数据库界的大象要出新版了

PostgreSQL 9.0的首个beta测试版已经发布。
PostgreSQL 9.0是PostgreSQL第一个内置了实时二进制数据库复制的版本，支持热待机和流复制。新版的其它特性包括：Windows系统支持64位；改进了LISTEN/NOTIFY，加快内部数据库事件消息传递；支持 Python 3等。

从8.0开始PostgreSQL发展十分迅速，增加了大量功能，性能也有大幅提高，在MySQL内忧外患之际，PostgreSQL有取而代之的势头。
Feature Matrix：

ackend	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Advisory locks	No	No	No	Yes	Yes	Yes	Yes
Autovacuum enabled by default	No	No	No	No	Yes	Yes	Yes
COPY with arbitrary SELECT	No	No	No	Yes	Yes	Yes	Yes
CSV support for COPY	No	Yes	Yes	Yes	Yes	Yes	Yes
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)	No	Yes	Yes	Yes	Yes	Yes	Yes
Column level permissions	No	No	No	No	No	Yes	Yes
Common Table Expressions (WITH RECURSIVE)	No	No	No	No	No	Yes	Yes
Concurrent GiST indexes	No	No	Yes	Yes	Yes	Yes	Yes
Crash-safe GiST indexes	No	No	Yes	Yes	Yes	Yes	Yes
DROP object IF EXISTS	No	No	No	Yes	Yes	Yes	Yes
Default permissions	No	No	No	No	No	No	Yes
Deferrable unique constraints	No	No	No	No	No	No	Yes
Disk based FSM	No	No	No	No	No	Yes	Yes
Dollar Quoting	No	Yes	Yes	Yes	Yes	Yes	Yes
EXPLAIN (BUFFERS) support	No	No	No	No	No	No	Yes
Exclusion constraints	No	No	No	No	No	No	Yes
Full code coverage generation support	No	No	No	No	No	No	Yes
GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS	No	No	No	No	No	No	Yes
Holdable cursors	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Hot Standby	No	No	No	No	No	No	Yes
INSERT/UPDATE/DELETE RETURNING	No	No	No	Yes	Yes	Yes	Yes
Integrated autovacuum daemon	No	No	Yes	Yes	Yes	Yes	Yes
Join removal support	No	No	No	No	No	No	Yes
Loadable plugin infrastructure for monitoring the planner	No	No	No	No	Yes	Yes	Yes
MVCC safe CLUSTER	No	No	No	No	Yes	Yes	Yes
Multiple autovacuum workers	No	No	No	No	Yes	Yes	Yes
Multiple input aggregates	No	No	No	Yes	Yes	Yes	Yes
Multirow VALUES	No	No	No	Yes	Yes	Yes	Yes
ON COMMIT clause for CREATE TEMPORARY TABLE	Yes	Yes	Yes	Yes	Yes	Yes	Yes
ORDER BY NULLS FIRST/LAST	No	No	No	No	Yes	Yes	Yes
Payload support for LISTEN/NOTIFY	No	No	No	No	No	No	Yes
Per tablespace support for GUCs	No	No	No	No	No	No	Yes
Per user/database server configuration settings	No	No	No	No	No	No	Yes
Point-in-Time Recovery	No	Yes	Yes	Yes	Yes	Yes	Yes
Prefix support for text search synonym dictionary	No	No	No	No	No	No	Yes
Row-wise comparison	No	No	No	Yes	Yes	Yes	Yes
SQL standard interval handling	No	No	No	No	No	Yes	Yes
SQL-standard information schema	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SQLDA support for ECPG	No	No	No	No	No	No	Yes
Savepoints	No	Yes	Yes	Yes	Yes	Yes	Yes
Streaming Replication	No	No	No	No	No	No	Yes
TABLE statement	No	No	No	No	No	Yes	Yes
Temporary VIEWs	No	No	Yes	Yes	Yes	Yes	Yes
Two Phase commit	No	No	Yes	Yes	Yes	Yes	Yes
Txid functions	No	No	No	No	Yes	Yes	Yes
Typed tables	No	No	No	No	No	No	Yes
UNNEST/array_agg	No	No	No	No	No	Yes	Yes
Updateable cursors	No	No	No	No	Yes	Yes	Yes
Version aware psql	No	No	No	No	No	Yes	Yes
Visibility map	No	No	No	No	No	Yes	Yes
WAL-safe B-Tree Indexes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Warm Standby	No	No	No	Yes	Yes	Yes	Yes
Window functions	No	No	No	No	No	Yes	Yes
XML, JSON and YAML output for EXPLAIN	No	No	No	No	No	No	Yes
Performance	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Asynchronous Commit	No	No	No	No	Yes	Yes	Yes
Automatic plan invalidation	No	No	No	No	Yes	Yes	Yes
Background Writer	No	Yes	Yes	Yes	Yes	Yes	Yes
Cross datatype hashing support	No	No	No	No	Yes	Yes	Yes
Distributed checkpointing	No	No	No	No	Yes	Yes	Yes
Full Text Search	No	No	No	No	Yes	Yes	Yes
GIN (Generalized Inverted Index) Indexes	No	No	No	Yes	Yes	Yes	Yes
GIN indexes partial match	No	No	No	No	No	Yes	Yes
GiST (Generalized Search Tree) Indexes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT	No	No	No	No	No	Yes	Yes
Hashing support for NUMERIC	No	No	No	No	Yes	Yes	Yes
Heap Only Tuples (HOT)	No	No	No	No	Yes	Yes	Yes
In-memory Bitmap Indexes	No	No	Yes	Yes	Yes	Yes	Yes
Index support for IS NULL	No	No	No	No	Yes	Yes	Yes
Indexes on expressions	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Inlining of SQL-functions	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Lazy XID allocation	No	No	No	No	Yes	Yes	Yes
Multiple temporary tablespaces	No	No	No	No	Yes	Yes	Yes
Non-blocking CREATE INDEX	No	No	No	Yes	Yes	Yes	Yes
Outer Join reordering	No	No	No	Yes	Yes	Yes	Yes
Parallel restore	No	No	No	No	No	Yes	Yes
Partial sort capability (top-n sorting)	No	No	No	No	Yes	Yes	Yes
SELECT ... FOR UPDATE/SHARE NOWAIT	No	No	Yes	Yes	Yes	Yes	Yes
Semi- and Antijoins	No	No	No	No	No	Yes	Yes
Shared row level locking	No	No	Yes	Yes	Yes	Yes	Yes
Synchronized sequential scanning	No	No	No	No	Yes	Yes	Yes
Table partitioning	No	No	Yes	Yes	Yes	Yes	Yes
Tablespaces	No	Yes	Yes	Yes	Yes	Yes	Yes
Security	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
GSSAPI support	No	No	No	No	Yes	Yes	Yes
Native LDAP authentication	No	No	No	Yes	Yes	Yes	Yes
Native RADIUS authentication	No	No	No	No	No	No	Yes
Per user/database connection limits	No	No	Yes	Yes	Yes	Yes	Yes
ROLES	No	No	Yes	Yes	Yes	Yes	Yes
SSL certificate validation in libpq	No	No	No	No	No	Yes	Yes
SSL client certificate authentication	No	No	No	No	No	Yes	Yes
Search+bind mode operation for LDAP authentication	No	No	No	No	No	No	Yes
Security Service Provider Interface (SSPI)	No	No	No	No	Yes	Yes	Yes
large object access controls	No	No	No	No	No	No	Yes
Network	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Full SSL support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
IPv6 Support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
V2 client protocol	Yes	Yes	Yes	Yes	Yes	Yes	Yes
V3 client protocol	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Internationalisation	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Database level Collation	No	No	No	No	No	Yes	Yes
EUC_JIS_2004/ SHIFT_JIS_2004 support	No	No	No	No	Yes	Yes	Yes
Multibyte encoding support, incl. UTF8	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Multiple language support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
UTF8 support on Windows	No	No	Yes	Yes	Yes	Yes	Yes
Unicode string literals and identifiers	No	No	No	No	No	Yes	Yes
Platforms	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Microsoft Visual C++ Support	No	No	No	No	Yes	Yes	Yes
Native Windows Port	No	Yes	Yes	Yes	Yes	Yes	Yes
Spinlock support for the SuperH hardware platform	No	No	No	No	No	No	Yes
Sun Studio compiler on Linux	No	No	No	No	No	Yes	Yes
Windows x64 support	No	No	No	No	No	No	Yes
Datatypes	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
Array support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Arrays of compound types	No	No	No	No	Yes	Yes	Yes
ENUM data type	No	No	No	No	Yes	Yes	Yes
GUID/UUID data type	No	No	No	No	Yes	Yes	Yes
IS0 8601 interval syntax	No	No	No	No	No	Yes	Yes
NULLs in Array	No	No	No	Yes	Yes	Yes	Yes
Type modifier support	No	No	No	No	Yes	Yes	Yes
XML data type	No	No	No	No	Yes	Yes	Yes
Functions and triggers	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
ALTER TABLE / ENABLE REPLICA TRIGGER/RULE	No	No	No	No	Yes	Yes	Yes
ALTER TABLE ENABLE/DISABLE TRIGGER	No	No	Yes	Yes	Yes	Yes	Yes
Column level triggers	No	No	No	No	No	No	Yes
Function argument names	No	No	No	No	No	No	Yes
ORDER BY support within aggregates	No	No	No	No	No	No	Yes
Per function GUC settings	No	No	No	No	Yes	Yes	Yes
Per function statistics	No	No	No	No	No	Yes	Yes
RETURN QUERY EXECUTE	No	No	No	No	No	Yes	Yes
RETURNS TABLE	No	No	No	No	No	Yes	Yes
Statement level TRUNCATE triggers	No	No	No	No	No	Yes	Yes
Statement level triggers	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Variadic functions	No	No	No	No	No	Yes	Yes
WHEN clause for CREATE TRIGGER	No	No	No	No	No	No	Yes
Procedural Languages	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
CASE in pl/pgsql	No	No	No	No	No	Yes	Yes
CONTINUE statement for PL/pgSQL	No	No	Yes	Yes	Yes	Yes	Yes
DO statement for pl/perl	No	No	No	No	No	No	Yes
DO statement for pl/pgsql	No	No	No	No	No	No	Yes
EXCEPTION support in PL/pgSQL	No	Yes	Yes	Yes	Yes	Yes	Yes
EXECUTE USING in PL/pgSQL	No	No	No	No	No	Yes	Yes
IN/OUT/INOUT parameters for pl/pgsql and PL/SQL	No	No	Yes	Yes	Yes	Yes	Yes
Named parameters	No	Yes	Yes	Yes	Yes	Yes	Yes
Non-superuser language creation	No	No	No	No	Yes	Yes	Yes
Number of function arguments increased to 100	No	No	Yes	Yes	Yes	Yes	Yes
Polymorphic functions	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Python 3 support for pl/python	No	No	No	No	No	No	Yes
Qualified function parameters	No	No	No	No	Yes	Yes	Yes
RETURN QUERY in pl/pgsql	No	No	No	No	Yes	Yes	Yes
ROWS and COST specification for functions	No	No	No	No	Yes	Yes	Yes
SQLERRM/SQLSTATE for pl/pgsql	No	No	Yes	Yes	Yes	Yes	Yes
Scrollable and updatable cursor support for pl/pgsql	No	No	No	No	Yes	Yes	Yes
Unicode object support in PL/python	No	No	No	No	No	No	Yes
User defined exceptions	No	No	No	No	No	Yes	Yes
Validator function for pl/perl	No	No	Yes	Yes	Yes	Yes	Yes
pl/pgsql installed by default	No	No	No	No	No	No	Yes
contrib modules	7.4	8.0	8.1	8.2	8.3	8.4	9.0a4
contrib/adminpack	No	No	No	Yes	Yes	Yes	Yes
contrib/autoexplain	No	No	No	No	No	Yes	Yes
contrib/btree_gin	No	No	No	No	No	Yes	Yes
contrib/btree_gist	No	Yes	Yes	Yes	Yes	Yes	Yes
contrib/citext	No	No	No	No	No	Yes	Yes
contrib/dblink	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/dblink asyncronous notification support	No	No	No	No	No	No	Yes
contrib/dbsize	Yes	Yes	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete
contrib/fuzzystrmatch	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/hstore	No	No	No	Yes	Yes	Yes	Yes
contrib/hstore improvements	No	No	No	No	No	No	Yes
contrib/intarray	Yes	Yes	Yes	Yes	Yes	Obsolete	Obsolete
contrib/isn (ISBN)	No	No	No	Yes	Yes	Yes	Yes
contrib/ltree	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/pageinspect	No	No	No	No	Yes	Yes	Yes
contrib/passwordcheck	No	No	No	No	No	No	Yes
contrib/pg_autovacuum	Yes	Yes	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete
contrib/pg_buffercache	No	No	Yes	Yes	Yes	Yes	Yes
contrib/pg_freespacemap	No	No	No	Yes	Yes	Yes	Yes
contrib/pg_standby	No	No	No	No	Yes	Yes	Yes
contrib/pg_stat_statements	No	No	No	No	No	Yes	Yes
contrib/pg_trgm	No	Yes	Yes	Yes	Yes	Yes	Yes
contrib/pgbench	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/pgstattuple	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/seg	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/sslinfo	No	No	No	Yes	Yes	Yes	Yes
contrib/tablefunc	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/tsearch2	Yes	Yes	Yes	Yes	Obsolete	Obsolete	Obsolete
contrib/tsearch2 UTF8 support	No	No	No	Yes	Obsolete	Obsolete	Obsolete
contrib/tsearch2 compat wrapper	No	No	No	No	Yes	Yes	Yes
contrib/unaccent	No	No	No	No	No	No	Yes
contrib/userlocks	Yes	Yes	Yes	Obsolete	Obsolete	Obsolete	Obsolete
contrib/uuid-ossp	No	No	No	No	Yes	Yes	Yes
contrib/xml2	No	Yes	Yes	Yes	Yes	Obsolete	Obsolete

作者: kaile 时间: 16-5-2010 19:33
PHP可以支持吗？

作者: xblues 时间: 16-5-2010 20:23
提示: 作者被禁止或删除, 无法发言 几年以前听IBM的一个演讲，推荐过一个OpenSource的小型数据库，据说很小很小，忘记叫做什么了。

作者: 空山鸟语 时间: 16-5-2010 20:28
Progresql是数据库界的古董了，历史悠久，很不好用。

作者: coredump 时间: 17-5-2010 10:24

原帖由 kaile 于 16-5-2010 18:33 发表

 登录/注册后可看大图

PHP可以支持吗？

PHP想来对Sqlite, Mysql和PostgreSQL支持得很好的

作者: kaile 时间: 17-5-2010 15:13
一个叫bekley db的嵌入式数据库听说不错，速度比access要快很多。

作者: coredump 时间: 17-5-2010 15:29

原帖由 kaile 于 17-5-2010 14:13 发表

 登录/注册后可看大图

一个叫bekley db的嵌入式数据库听说不错，速度比access要快很多。

Berkeley DB原来是Sleepycat公司的,现在也是属于Oracle的了，本来是key-value类型的数据库，不支持SQL，但除此之外有很多高级数据库才有的特性，比如事务,并发，复制等，性能很高，有C/C++,Java版本和其他各种脚本语言的绑定，现在Oracle在Berkeley DB上增加了SQL支持。

还有一点可说的就是Berkeley DB一直以来都可以作为MySQL的后台存储引擎，Subversion的后台存储也支持Berkeley DB。

另外Google的Single Sign On 后台也是用Berkeley DB实现的。

欢迎光临 FreeOZ论坛 (https://www.freeoz.org/ibbs/)