On 3/31/15 10:58 AM, Kevin Viraud wrote:
Touche ! Thanks a lot. Looking more at the data yes it goes very often to ELSE Clause. And therefore reaching the MAX_CACHED_RES. In there anyway to increase that value ?
Sure, change it and re-compile. But be aware that increasing it will probably increase the cost of some other stuff, so it's a tradeoff.
If this is that complex though you very likely would do better in plperl, especially if you could pre-compile the RE's. AFAIK there's no way to do that in Postgres, though it might be interesting to add that ability.
-- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
