News for hackers. Stuff that matters.
Re:What PostgreSQL has over other open source SQL databases:... by ww520 on Saturday October 24, 2015 @08:27PM (#10445419)
Postgres has come a long way. Some of these features are very cool, like the WITH RECURSIVE. I wonder what's the performance implication is. Often you can gauge the performance by looking at the query, like a table scan or using index. Assuming the parent topic column is indexed, would the recursive walk take INDEX + SCAN? Where the INDEX is the parent topic look up and the SCAN is the aggregate look up of the subtopic.
Re:What PostgreSQL has over other open source SQL databases:... by simoncion on Saturday October 24, 2015 @09:32PM (#10445592)
Is the information provided by

  explain select ...
insufficient?
Re:What PostgreSQL has over other open source SQL databases:... by brobinson on Saturday October 24, 2015 @11:08PM (#10445805)
There's also EXPLAIN ANALYZE which may yield different output than just an EXPLAIN.
Re:What PostgreSQL has over other open source SQL databases:... by mazelife on Sunday October 25, 2015 @12:55AM (#10446023)
Or EXPLAIN (ANALYZE, BUFFERS), which is very useful when you suspect disk IO may be a choke point.
Re:What PostgreSQL has over other open source SQL databases:... by brobinson on Sunday October 25, 2015 @02:02AM (#10446136)
Didn't know about BUFFERS. Thanks!