2017年6月28日
postgresql 排序索引
摘要： 官方网站 In addition to simply finding the rows to be returned by a query, an index may be able to deliver them in a specific sorted order. This allows a 阅读全文
posted @ 2017-06-28 16:27 cdongyang 阅读(3177) 评论(0) 推荐(0)
postgresql 外键约束是否自动索引，unique约束是否自动建索引，主键是否自动建索引
摘要： 官网文档 Since a DELETE of a row from the referenced table or an UPDATE of a referenced column will require a scan of the referencing table for rows match 阅读全文
posted @ 2017-06-28 14:42 cdongyang 阅读(2101) 评论(0) 推荐(0)