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.
[ Parent
| on HN ]
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.