TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

New Features Coming in PostgreSQL 10

517 点作者 ioltas大约 8 年前

26 条评论

avar大约 8 年前
This bit about ICU support v.s. glibc:<p><pre><code> &gt; [...] Furthermore, at least on Red Hat, glibc regularly whacks &gt; around the behavior of OS-native collations in minor releases, &gt; which effectively corrupts PostgreSQL&#x27;s indexes, since the index &gt; order might no longer match the (revised) collation order. To &gt; me, changing the behavior of a widely-used system call in a &gt; maintenance release seems about as friendly as locking a family &gt; of angry racoons in someone&#x27;s car, but the glibc maintainers &gt; evidently don&#x27;t agree. </code></pre> Is a reference to the PostgreSQL devs wanting to make their index order a function of strxfrm() calls and to not have it change when glibc updates, whereas some on the glibc list think it should only be used for feeding it to the likes of strcmp() in the same process:<p><pre><code> &gt; The only thing that matters about strxfrm output is its strcmp &gt; ordering. If that changes, it&#x27;s either a bug fix or a bug &gt; (either in the code or in the locale data). If the string &gt; contents change but the ordering doesn&#x27;t, then it&#x27;s an &gt; implementation detail that is allowed to change. </code></pre> -- <a href="https:&#x2F;&#x2F;sourceware.org&#x2F;ml&#x2F;libc-alpha&#x2F;2015-09&#x2F;msg00197.html" rel="nofollow">https:&#x2F;&#x2F;sourceware.org&#x2F;ml&#x2F;libc-alpha&#x2F;2015-09&#x2F;msg00197.html</a>
评论 #14067268 未加载
评论 #14075432 未加载
fiatjaf大约 8 年前
Ok, I&#x27;m not a database manager for enormous projects, so these changes may be great, but I don&#x27;t understand them and don&#x27;t care about them. Postgres is already the most awesome thing in Earth to me.<p>Still, if my opinion counts I think SELF-UPDATING MATERIALIZED VIEWS should be the next priority.
评论 #14067912 未加载
评论 #14068955 未加载
评论 #14067807 未加载
jacques_chester大约 8 年前
I deeply appreciate the great care that Postgres committers take in writing their merge messages.<p>I think of it as a sign of respect for future developers to take the time to write a clear account of what has happened.
评论 #14068080 未加载
评论 #14067529 未加载
qaq大约 8 年前
Even a single feature from the list would make 10 an amazing release, all of them together is just unbelievable. Very happy we are using PG :)
iEchoic大约 8 年前
I&#x27;m so excited for table partitioning. I use table inheritance in several places in my current project, but have felt the pain of foreign key constraints not applying to inherited children. Reading about table partitioning, I&#x27;m realizing that this is a much better fit for my use case.<p>Postgres continues to amaze me with the speed at which they introduce the right features into such a heavily-used and production-critical product. Thanks Postgres team!
评论 #14068435 未加载
lazzlazzlazz大约 8 年前
How is Postgres so consistently the best open-source DB project from features to documentation? It&#x27;s unreal.
评论 #14069756 未加载
评论 #14069834 未加载
评论 #14068967 未加载
jordanthoms大约 8 年前
Will DDL replication for the logical replication be landing in 10 or later?<p>We have some use cases where logical replication would be very helpful, but keeping the schema in sync manually seems like a pain - will there be a documented workaround if DDL replication doesn&#x27;t make it in?
djcj88大约 8 年前
I did read the article, but I can&#x27;t find any mention of addressing the &quot;Write amplification&quot; issue as described by Uber when they moved away from postgres. <a href="https:&#x2F;&#x2F;eng.uber.com&#x2F;mysql-migration&#x2F;" rel="nofollow">https:&#x2F;&#x2F;eng.uber.com&#x2F;mysql-migration&#x2F;</a> I had heard talk on Software Engineering Daily that this new major revision was supposed to address that.<p>Is this issue resolved by the new &quot;Logical replication&quot; feature? It doesn&#x27;t seem directly related, but it seems like maybe that is what he is referring to in this blog post?
评论 #14067384 未加载
评论 #14067406 未加载
评论 #14067548 未加载
nickpeterson大约 8 年前
Can anyone recommend a decently up to date book on postgres administration? Or are docs really the only way? I&#x27;ve used SQL Server for years but would likely choose postgres for an independent project if I intended to commercialize it. That said, I don&#x27;t use it at work so it&#x27;s hard to get in depth experience.
评论 #14068142 未加载
评论 #14068315 未加载
评论 #14068382 未加载
评论 #14069076 未加载
评论 #14074978 未加载
Normal_gaussian大约 8 年前
Extended Statistics! I was following the replication changes, but have just discovered the extended statistics and am more excited about them.<p>The directory renaming at the bottom of the post is interesting - I wonder if many other projects have to do things like this?
评论 #14067320 未加载
评论 #14067823 未加载
评论 #14067259 未加载
评论 #14067782 未加载
api大约 8 年前
The feature I&#x27;d really love is master selection with Raft or similar and automatic query redirection to the master for all write queries (and maybe for reads with a query keyword).<p>That would make it very easy and robust to cluster pg without requiring a big complicated (a.k.a. high admin overhead and failure prone) stack with lots of secondary tools.<p>This kind of fire and forget cluster is really the killer feature of things like MongoDB and RethinkDB. Yes people with really huge deployments might want something more tunable, but that&#x27;s only like 1% of the market.<p>Of course those NoSQL databases also offer eventual and other weaker but more scalable consistency modes, but like highly tuned manual deployment these too are features for the 1% of the market that actually needs that kind of scale.<p>A fire and forget cluster-able fully consistent SQL database would be nirvana for most of the market.
评论 #14068159 未加载
评论 #14069330 未加载
elvinyung大约 8 年前
Dumb question: does declarative partitioning pave the way for native sharding in Postgres? I&#x27;m not super super familiar, but it <i>seems</i> like along with some other features coming in Postgres 10, like parallel queries and logical replication, that this is eventually the goal.
评论 #14067288 未加载
smac8大约 8 年前
Wow, so awesome. I do hope at some point we can see some language improvements to PLPGSQL. More basic data structures could go a long way in making that language really useful, and I still consider views&#x2F;stored procedures a superior paradigm to client side sql logic
评论 #14067894 未加载
acdha大约 8 年前
What&#x27;s the ops experience for a replicated setup like these days? i.e. assuming you want basic fault-tolerance at non-exotic size &#x2F; activity levels, how much of a job is someone acquiring if, say, there are reasons they can&#x27;t just use AWS RDS?
评论 #14067600 未加载
评论 #14068254 未加载
StreamBright大约 8 年前
For analytical loads the following is going to be great:<p><pre><code> While PostgreSQL 9.6 offers parallel query, this feature has been significantly improved in PostgreSQL 10, with new features like Parallel Bitmap Heap Scan, Parallel Index Scan, and others. Speedups of 2-4x are common with parallel query, and these enhancements should allow those speedups to happen for a wider variety of queries.</code></pre>
hodgesrm大约 8 年前
Impressive feature list. Glad to see logical replication is finally making it in.
评论 #14067310 未加载
hartator大约 8 年前
I am considering more and more a move back from MongoDB to PostgreSQL. I will be missing being schema less so much though. Migrations - particularly Rails migrations - left a bad taste in my mouth. Anyone did the move recently and what are their feelings?
评论 #14069503 未加载
评论 #14067690 未加载
评论 #14067488 未加载
knv大约 8 年前
Any recommendations for scaling Postgresql&#x27;s best practices? Really appreciate it.
mark_l_watson大约 8 年前
I know that several RDF data stores use PostgreSQL as a backend data store. With new features like better XML support, as well as older features for storing hierarchical data, I am wishing for a plugin or extension for handling RDF with limited (not RDFS or OWL) SPARQL query support. I almost always have PostgreSQL available, and for RDF applications it would be very nice to not have to run a separate service.<p>I tend to view PostgreSQL as a &quot;Swiss Army knife&quot; and having native RDF support would reinforce that.
评论 #14067466 未加载
评论 #14067650 未加载
评论 #14067503 未加载
ams6110大约 8 年前
A question on this statement, in the SCRAM authentication description: <i>stealing the hashed password from the database or sniffing it on the wire is equivalent to stealing the password itself</i><p>How is that the case? That&#x27;s exactly the thing that hashed passwords prevent. Of course, if it&#x27;s just an MD5 hash that&#x27;s feasibly vulnerable to brute-forcing today, but it&#x27;s still not &quot;equivalent&quot; to having the clear-text password.
评论 #14068419 未加载
bladecatcher大约 8 年前
This is great because I couldn&#x27;t go to production with earlier releases of logical decoding. Now we don&#x27;t have to depend on a third party add on!
评论 #14067396 未加载
mozumder大约 8 年前
I could use a count of the number of file I&#x2F;Os that each query takes, in order to optimize my queries further...
评论 #14067981 未加载
awinter-py大约 8 年前
fascinating that the road to improving the expr evaluator is better opcode dispatch and jit -- same tradeoffs every programming language project is looking at right now.
qxmat大约 8 年前
DECLARE @please VARCHAR(3) = &#x27;???&#x27;;
MR4D大约 8 年前
You guys are awesome - keep up the good work!
awinter-py大约 8 年前
the join speedup for provably unique operands sounds awesome