Thanks for your help. But 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?
Sorry for my English
Tuan Hoang ANh
On Sat, Aug 6, 2011 at 11:26 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:
"Kevin Grittner" wrote:It ate part of what I had on that line. (Note to self: don't use
> WITH x AS SELECT * FROM x ORDER BY d.data_id;
angle-bracketing in posts.)
Trying again with different punctuation:
WITH x AS [original query] SELECT * FROM x ORDER BY d.data_id;
-Kevin
