SURANTYN Jean Fran+AOc-ois wrote:
> Many thanks for your quick reply
>
> In fact, that issue comes from a recent migration from Oracle to
> Postgresql, and even if some queries were not optimized by the past
> (example: where n=1 and n=1), Oracle was able to rewrite them and to
> "hide" the bad queries". But now that we have migrated to Postgresql,
> we have discovered that some queries were indeed badly wroten I will
> tell to the developpers to try to optimize their queries for them to
> work efficiently on Postgresql
If nothing else it will help when / if you decide to use prepared
queries - there's no way to optimise "n=+ACQ-1 or n=+ACQ-2" at planning time.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
