PostgreSQL minor versions released

显示全部楼层 · 2012-5-21 10:19:41

9.2.1 · 2012-09-24 · Notes
9.1.6 · 2012-09-24 · Notes
9.0.10 · 2012-09-24 · Notes
8.4.14 · 2012-09-24 · Notes
8.3.21 · 2012-09-24 · Notes

千问 · 2012-5-21 10:19:41

一个简单的解释就崩溃了
test_en=# create table t1 as select id from generate_series(1,100000) as g(id);
SELECT 100000
test_en=# create table t2 as select id from generate_series(1,100000) as g(id);
SELECT 100000
test_en=# alter table t1 add primary key (id);
注意:ALTER TABLE / ADD PRIMARY KEY 将要为表 "t1" 创建隐含索引 "t1_pkey"
ALTER TABLE
test_en=# alter table t2 add primary key (id);
注意:ALTER TABLE / ADD PRIMARY KEY 将要为表 "t2" 创建隐含索引 "t2_pkey"
ALTER TABLE
test_en=# analyze t1;
ANALYZE
test_en=# analyze t2;
ANALYZE
test_en=#
test_en=# explain select * from t1
test_en-# left outer join
test_en-# (
test_en(# select distinct t2.id from t2
test_en(# where t2.id>100
test_en(# ) as _t on _t.id=t1.id
test_en-# where
test_en-# (t1.id>100or (t1.id

千问 · 2012-5-21 10:19:41

http://archives.postgresql.org/pgsql-bugs/2012-10/msg00018.php

千问 · 2012-5-21 10:19:41

但服务器并没有down
!>
!> \c test_en
You are now connected to database "test_en" as user "db2admin" via socket in "/tmp" at port "5432".

千问 · 2012-5-21 10:19:41

只写一半是不会断开的
test_en=# explain select * from t1
test_en-# left outer join t2 on t2.id=t1.id and t2.id>100 ;

QUERY PLAN
-------------------------------------------------------------------------------------
Merge Left Join(cost=0.00..7847.75 rows=100000 width=8)
Merge Cond: (t1.id = t2.id)
->Index Only Scan using t1_pkey on t1(cost=0.00..3050.36 rows=100000 width=4)
->Index Only Scan using t2_pkey on t2(cost=0.00..3298.63 rows=99901 width=4)
Index Cond: (id > 100)
(5 行记录)

千问 · 2012-5-21 10:19:41

〇〇发表于 2012-10-3 20:15
只写一半是不会断开的
test_en=# explain select * from t1
test_en-# left outer join t2 on t2.id=t1.i ...
这次不知道老外还否认是个bug不？

千问 · 2012-5-21 10:19:41

myth8860 发表于 2012-10-8 17:10
这次不知道老外还否认是个bug不？
这个没否认