Re: Speed up the query

Torsten Förtsch <torsten.foertsch@gmx.net> 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°