Hello,
I have a table of tree nodes with a tsquery column. To get a subtree's
tsquery, I need to OR all of its nodes' tsqueries together.
I defined a custom aggregate using tsquery_or:
CREATE AGGREGATE tsquery_or_agg (tsquery)
(
sfunc = tsquery_or,
stype = tsquery
);
Folks,
Just encountered another case of critical fail for abort-early query
plans. In this case, it will completely prevent a user from upgrading
to 9.3; this is their most common query, and on 9.3 it takes 1000X longer.
Maybe we should think about removing abort-early plans from 9.5?
Clearly we
On 1 July 2014 20:20, Tom Lane wrote:
> Jeff Frost writes:
>>> On Jun 30, 2014, at 4:04 PM, Tom Lane wrote:
Did you check whether the locks were all on temp tables of the
ON COMMIT DROP persuasion?
>
>> And indeed it did catch up overnight and the lag increased shortly after a
>> corr
