What stood out to me the most was: On Sep 22, 2005, at 2:20 PM, Jean-Pierre Pelletier wrote:
a) is the index there, b) have you analyzed, c) perhaps the planners have different default values for when to use an index vrs a seqscan... if you turn off seqscan, are the timings similar? |
- [PERFORM] Queries 15 times slower on 8.1 beta 2 than... Jean-Pierre Pelletier
- Re: [PERFORM] Queries 15 times slower on 8.1 be... Gavin M. Roy
- Re: [PERFORM] Queries 15 times slower on 8.... Jean-Pierre Pelletier
- Re: [PERFORM] Queries 15 times slower on 8.1 be... John Arbash Meinel
- Re: [PERFORM] Queries 15 times slower on 8.... Jean-Pierre Pelletier
- Re: [PERFORM] Queries 15 times slower o... John Arbash Meinel
- Re: [PERFORM] Queries 15 times slow... Jean-Pierre Pelletier
- Re: [PERFORM] Queries 15 times slower o... Josh Berkus
- Re: [PERFORM] Queries 15 times slow... Michael Fuhr
- Re: [PERFORM] Queries 15 times... Jean-Pierre Pelletier
- Re: [PERFORM] Queries 15 times... Tom Lane
- Re: [PERFORM] Queries 15 times... Michael Fuhr