work need to do

来源：互联网发布：mysql合并表编辑：程序博客网时间：2024/05/04 18:00

(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

0 0