2007/10/22, Martin Marques <martin@xxxxxxxxxxxxxxx>: > Pavel Stehule wrote: > > 2007/10/22, Martin Marques <martin@xxxxxxxxxxxxxxx>: > >> 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 .. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
