Thread: Re: PostgreSQL 9.0.1 on Windows performance tunning help please

"Kevin Grittner"  wrote:

> WITH x AS SELECT * FROM x ORDER BY d.data_id;

It ate part of what I had on that line.  (Note to self: don't use
angle-bracketing in posts.)

Trying again with different punctuation:

WITH x AS [original query] SELECT * FROM x ORDER BY d.data_id;

-Kevin

tuanhoanganh <hatuan05@gmail.com> 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