Re: [PERFORM] postgres 8.2 seems to prefer Seq Scan

2007-04-09 Thread Alex Deucher
On 4/9/07, Alex Deucher <[EMAIL PROTECTED]> wrote: On 4/9/07, Alex Deucher <[EMAIL PROTECTED]> wrote: > On 4/6/07, Michael Fuhr <[EMAIL PROTECTED]> wrote: > > On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote: > > > One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded >

Re: [PERFORM] postgres 8.2 seems to prefer Seq Scan

2007-04-09 Thread Alex Deucher
On 4/9/07, Alex Deucher <[EMAIL PROTECTED]> wrote: On 4/6/07, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote: > > One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded > > onto 8.2, both have locale set to C. 8.2 seems to pre

Re: [PERFORM] postgres 8.2 seems to prefer Seq Scan

2007-04-09 Thread Alex Deucher
On 4/6/07, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote: > One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded > onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans > for the first query while the ordering in

Re: [PERFORM] postgres 8.2 seems to prefer Seq Scan

2007-04-06 Thread Alex Deucher
On 4/6/07, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote: > One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded > onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans > for the first query while the ordering in

Re: [PERFORM] postgres 8.2 seems to prefer Seq Scan

2007-04-06 Thread Michael Fuhr
On Fri, Apr 06, 2007 at 04:38:33PM -0400, Alex Deucher wrote: > One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded > onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans > for the first query while the ordering in the second query seems to > perform worse on 8.2. I