Torsten Förtsch <torsten.foertsch@xxxxxxx> wrote: > I'd try 2 things: > > 1) set work_mem to ~100Mb. You don't have to do that globally in > postgresql.conf. You can set it for the current session only. > > set work_mem to '100MB'; > > Then run your query. > > 2) change the common table expression to a subquery: Yeah, agree. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
