(1)How PostgreSQL Processes a Query

(2) why can not alter table column to serial?

postgres=# d
No relations found.
postgres=# create table t1(id1 int,id2 int,id3 serial);
CREATE TABLE
postgres=# d
List of relations
Schema | Name | Type | Owner
--------+------------+----------+-------
public | t1 | table | wln
public | t1_id3_seq | sequence | wln
(2 rows)


postgres=# alter table t1 alter column id2 set DATA TYPE text;
ALTER TABLE
postgres=# alter table t1 alter column id1 set DATA TYPE serial;
ERROR: type "serial" does not exist

LOCATION: typenameType,parse_type.c:205

（3）全球级的分布式数据库 Google Spanner原理

http://blogread.cn/it/article/5862?f=wb

（4）read article:THE IMPLEMENTATION OF POSTGRES

(文章写于1989)

2014.07.29 07:00:00 ---2014.07.29 21:24

（5）how the heartbeat works?

2014.09.14--

（6）how to make prime postgres switch to standby postgres using the heartbeat software?

and do it in the linux enviroment.

2014.09.14--

（7）阅读分布式数据库系统及应用

2014.11.23--

参考

（1）PostgreSQL Hardware Performance Tuning

（2）How PostgreSQL Processes a Query

（3）Postgre Executor学习资源

（8）

http://bbs.chinaunix.net/thread-951213-1-1.html

http://blog.chinaunix.net/uid-20722281-id-160013.html

http://wenku.baidu.com/view/b3a41a49c281e53a5902ff4f.html

(9) postgres streaming

http://www.pgcon.org/2008/schedule/attachments/61_Synchronous%20Log%20Shipping%20Replication.pdf

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!