On 16/2/26 04:49, Clive Boughton wrote:
For reasons of security I can't provide all the SQL code, but I can (if
it is necessary) provide an outline of what the code does.
In principle, you can provide EXPLAIN and schema in a private email so
we can invent a synthetic example for public discussion based on your
problem (I wonder if it is related to one of the typical Postgres issues
like index picking or Subplan transformation).
I already had such an experience with a company from Sydney, and it
worked well.
--
regards, Andrei Lepikhov,
pgEdge