SQL Performance Explained - Markus Winand - Excellent book that gets into the internals of what developers need to know about SQL and covers each part as it relates to the 4 major SQL databases (Oracle, SQL Server, Postgres,…
…papers are particularly fine reading. For people who looked at this wanting to get going with using database systems (as opposed to creating them), I'd recommend: Learning SQL by Alan Beaulieu SQL Performance Explained by Markus Winand SQL Cookbook by Anthony Molinaro The three of these will take you up to a pretty useful level of SQL knowledge/understanding. The first two are fairly easy reading to boot.
如果你找的是一本通用的书（不一定只针对 Postgres），那我极力推荐“Use The Index, Luke”[1] 教程以及 Markus Winand 的配套书籍《SQL Performance Explained》。它没扯太多关系型理论，但确实相对偏底层地讲清楚了索引和数据库数据是如何存储的，以及为什么你要使用不同的……
If what you are looking is a general book (not necessarily just for Postgres) I can't recommend the "Use The Index, Luke"[1] tutorial, and the accompanying book "SQL Performance Explained" by Markus Winand, enough. It doesn't go into a lot of relational theory, but it does provide a somewhat low-level description on how indices and database data are stored, and why you want to use different…
如果你是需要查询数据库的应用程序员，我由衷推荐 Markus Winand 的《SQL Performance Explained》，或者他的网站：https://use-the-index-luke.com/
If you are an application programmer needing to query the database, I wholeheartedly recommend "SQL Performance Explained" by Markus Winand, or his website: https://use-the-index-luke.com/
正如另一位评论者推荐的那样，《SQL Antipatterns》很不错。但在这个主题上我最喜欢的书是 Markus Winand 的《SQL Performance Explained》。大部分内容都在线公开在这里：https://use-the-index-luke.com/，但我还是建议买一本，因为它篇幅精炼，字字珠玑。书很薄，所以你真能读完，甚至可能会重读。它是为了……
SQL Antipatterns is good as another commenter recommended. But my favourite book on the topic is Markus Winand's SQL Performance Explained. Most of it is online here: https://use-the-index-luke.com/ but I recommend buying it since it's tiny and worth its weight in gold. It's short so you actually read it and possibly reread it. It's to…
……目前为止：- Andy Hunt 的《Pragmatic Thinking & Learning》- Don Norman 的《The Design of Everyday Things》- Edmond Lau 的《The Effective Engineer*》- Andy Hunt 和 Dave Thomas 的《The Pragmatic Programmer》- Markus Winand 的《SQL Performance Explained》。而且 http://teachyourselfcs.com 的课程也相当不错。顺便说一句，我们能从游戏程序员和操作系统/数据库/编译器工程师身上学到的东西实在太多了。
…so far: - Pragmatic Thinking & Learning by Andy Hunt - The Design of Everyday Things by Don Norman - The Effective Engineer* by Edmond Lau - The Pragmatic Programmer by Andy Hunt and Dave Thomas - SQL Performance Explained by Markus Winand And http://teachyourselfcs.com curriculum is pretty good as well. As a side note, there's so much we can learn from game programmers and OS/database/compiler engineers.
《SQL Performance Explained》- Markus Winand - 非常棒的一本书，深入剖析了开发者需要了解的 SQL 底层机制，并覆盖了与 4 大主流 SQL 数据库（Oracle、SQL Server、Postgres、…
SQL Performance Explained - Markus Winand - Excellent book that gets into the internals of what developers need to know about SQL and covers each part as it relates to the 4 major SQL databases (Oracle, SQL Server, Postgres,…
……论文读起来尤其过瘾。对于看这个是想上手使用数据库系统（而不是开发数据库系统）的人，我推荐：Alan Beaulieu 的《Learning SQL》、Markus Winand 的《SQL Performance Explained》、Anthony Molinaro 的《SQL Cookbook》。这三本书能帮你把 SQL 知识/理解提升到一个相当实用的水平。而且前两本读起来还挺轻松的。
…papers are particularly fine reading. For people who looked at this wanting to get going with using database systems (as opposed to creating them), I'd recommend: Learning SQL by Alan Beaulieu SQL Performance Explained by Markus Winand SQL Cookbook by Anthony Molinaro The three of these will take you up to a pretty useful level of SQL knowledge/understanding. The first two are fairly easy reading to boot.
如果你找的是一本通用的书（不一定只针对 Postgres），那我极力推荐“Use The Index, Luke”[1] 教程以及 Markus Winand 的配套书籍《SQL Performance Explained》。它没扯太多关系型理论，但确实相对偏底层地讲清楚了索引和数据库数据是如何存储的，以及为什么你要使用不同的……
If what you are looking is a general book (not necessarily just for Postgres) I can't recommend the "Use The Index, Luke"[1] tutorial, and the accompanying book "SQL Performance Explained" by Markus Winand, enough. It doesn't go into a lot of relational theory, but it does provide a somewhat low-level description on how indices and database data are stored, and why you want to use different…
如果你是需要查询数据库的应用程序员，我由衷推荐 Markus Winand 的《SQL Performance Explained》，或者他的网站：https://use-the-index-luke.com/
If you are an application programmer needing to query the database, I wholeheartedly recommend "SQL Performance Explained" by Markus Winand, or his website: https://use-the-index-luke.com/
正如另一位评论者推荐的那样，《SQL Antipatterns》很不错。但在这个主题上我最喜欢的书是 Markus Winand 的《SQL Performance Explained》。大部分内容都在线公开在这里：https://use-the-index-luke.com/，但我还是建议买一本，因为它篇幅精炼，字字珠玑。书很薄，所以你真能读完，甚至可能会重读。它是为了……
SQL Antipatterns is good as another commenter recommended. But my favourite book on the topic is Markus Winand's SQL Performance Explained. Most of it is online here: https://use-the-index-luke.com/ but I recommend buying it since it's tiny and worth its weight in gold. It's short so you actually read it and possibly reread it. It's to…
……目前为止：- Andy Hunt 的《Pragmatic Thinking & Learning》- Don Norman 的《The Design of Everyday Things》- Edmond Lau 的《The Effective Engineer*》- Andy Hunt 和 Dave Thomas 的《The Pragmatic Programmer》- Markus Winand 的《SQL Performance Explained》。而且 http://teachyourselfcs.com 的课程也相当不错。顺便说一句，我们能从游戏程序员和操作系统/数据库/编译器工程师身上学到的东西实在太多了。
…so far: - Pragmatic Thinking & Learning by Andy Hunt - The Design of Everyday Things by Don Norman - The Effective Engineer* by Edmond Lau - The Pragmatic Programmer by Andy Hunt and Dave Thomas - SQL Performance Explained by Markus Winand And http://teachyourselfcs.com curriculum is pretty good as well. As a side note, there's so much we can learn from game programmers and OS/database/compiler engineers.