2007/10/22, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>:
> Pavel Stehule wrote:
> > 2007/10/22, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>:
> >> Pavel Stehule wrote:
> >>> Hello
> >>>
> >>> I am unsure, did you check config values?
> >> Don't know which ones you are talking about, but all enable_* are set to on.
> >>
> >> Anything else?
> >>
> >
> > shared_buffers
>
> 8.1:
>
> 16000
~ 128M
>
>
> 8.2:
>
> 400MB
>
>
> > work_mem
>
> 8.1:
>
> 8192
8M !!!! 8>4
>
> 8.2:
>
> 4MB
>
>
> > effective_cache_size
>
> 8.1:
>
> 1000
8M
>
> 8.2:
>
> 128MB
>
>
try
set work_mem to '8MB';
and
explain analyze select ..