Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread Tom Lane
"k...@rice.edu" writes: > On Tue, Dec 20, 2011 at 02:54:32PM +0100, Magnus Hagander wrote: >>> Seems very different to me - those change *what* happens when you do >>> certain things. sync_seqscans is just a performance tuning option, no? >>> It doesn't actually change the semantics of any operati

Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread k...@rice.edu
On Tue, Dec 20, 2011 at 02:54:32PM +0100, Magnus Hagander wrote: > On Tue, Dec 20, 2011 at 14:47, k...@rice.edu wrote: > > On Tue, Dec 20, 2011 at 02:41:54PM +0100, Magnus Hagander wrote: > >> On Tue, Dec 20, 2011 at 14:38, Robert Haas wrote: > >> > On Tue, Dec 20, 2011 at 8:35 AM, Magnus Hagande

Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread Magnus Hagander
On Tue, Dec 20, 2011 at 14:47, k...@rice.edu wrote: > On Tue, Dec 20, 2011 at 02:41:54PM +0100, Magnus Hagander wrote: >> On Tue, Dec 20, 2011 at 14:38, Robert Haas wrote: >> > On Tue, Dec 20, 2011 at 8:35 AM, Magnus Hagander >> > wrote: >> >> Is there any reason why the setting synchronize_seq

Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread k...@rice.edu
On Tue, Dec 20, 2011 at 02:41:54PM +0100, Magnus Hagander wrote: > On Tue, Dec 20, 2011 at 14:38, Robert Haas wrote: > > On Tue, Dec 20, 2011 at 8:35 AM, Magnus Hagander > > wrote: > >> Is there any reason why the setting synchronize_seqscans is in the > >> section "version/platform compatibilit

Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread Magnus Hagander
On Tue, Dec 20, 2011 at 14:38, Robert Haas wrote: > On Tue, Dec 20, 2011 at 8:35 AM, Magnus Hagander wrote: >> Is there any reason why the setting synchronize_seqscans is in the >> section "version/platform compatibility" in postgresql.conf? Is it >> just because nobody could find a better place

Re: [HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread Robert Haas
On Tue, Dec 20, 2011 at 8:35 AM, Magnus Hagander wrote: > Is there any reason why the setting synchronize_seqscans is in the > section "version/platform compatibility" in postgresql.conf? Is it > just because nobody could find a better place for it? ;) It seems a > bit wrong to me... Presumably t

[HACKERS] sync_seqscans in postgresql.conf

2011-12-20 Thread Magnus Hagander
Is there any reason why the setting synchronize_seqscans is in the section "version/platform compatibility" in postgresql.conf? Is it just because nobody could find a better place for it? ;) It seems a bit wrong to me... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-