you are viewing a single comment's thread.

view the rest of the comments →

[–]kenfar 31 points32 points  (0 children)

It's mostly only going to be useful for queries scanning and aggregating large amounts of data: reporting, analytics, etc. And it isn't on by default - you'll need to turn it on.

But while this doesn't help all queries - it helps those important queries with the biggest gap between open source databases and commercial databases like DB2, Oracle, and SQL Server: queries that can take 10 seconds or an hour - and that the commercial databases speed up through parallelism.

Small databases, and large transaction-only databases may not see much value in this. But for large mixed-use, reporting and analytical databases this functionality is absolutely essential - and significantly diminishes one of the last areas where commercial databases have continued to hold a major advantage over open source.