tuanhoanganh <hatuan05@xxxxxxxxx> wrote: > I can not change the query because it is generate by SymmetricDS > program. So I only can create index on table and change config of > postgres to tunning the query. Is there any way to do that? I'm not familiar with SymetricDS. Would it be possible for you to create a VIEW which used the faster technique and have SymetricDS use the view? -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance