All indexes are there, and I've analyzed the three
tables.
I turned off seq scan, the query plans became
identical but the performance
was not better.
----- Original Message -----
|
- [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
- Re: [PERFORM] Queries 15 t... Jean-Pierre Pelletier