• ▸ PHP
• ▸ Java
• ▸ Java SE
• ▸ Python
• ▸ C#
• ▸ C&C++
• ▸ Ruby
• ▸ VB
• ▸ asp.Net
• ▸ Go
• ▸ Perl
• ▸ netty
• ▸ Django
• ▸ Delphi
• ▸ Jsp
• ▸ .NET Core
• ▸ Spring
• ▸ Flask
• ▸ Springboot
• ▸ SpringMVC
• ▸ Lua
• ▸ Laravel
• ▸ Mybatis
• ▸ Asp
• ▸ Groovy
• ▸ ThinkPHP
• ▸ Yii
• ▸ swoole
• ▸ HTML
• ▸ HTML5
• ▸ JavaScript
• ▸ CSS
• ▸ jQuery
• ▸ Bootstrap
• ▸ Angularjs
• ▸ TypeScript
• ▸ Vue
• ▸ Dojo
• ▸ Json
• ▸ Electron
• ▸ Node.js
• ▸ extjs
• ▸ Express
• ▸ XML
• ▸ ES6
• ▸ Ajax
• ▸ Flash
• ▸ Unity
• ▸ React
• ▸ Flex
• ▸ Ant Design
• ▸ Web前端
• ▸ 微信小程序
• ▸ 微信公众号
• ▸ iOS
• ▸ Android
• ▸ Swift
• ▸ Hybrid
• ▸ Cocos2d-x
• ▸ Flutter
• ▸ Xcode
• ▸ Silverlight
• ▸ cocoa
• ▸ Cordova

• 前端之家
• Postgre SQL
• work need to do

(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）

@H_301_94@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