Re: [PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Shane Ambler
Yannick Le Guédart wrote: Greetings, I was trying to get informations on #portgresql about a query plan I think is quite strange, and I was said to post on this list. I hope my mail will be clear enough. I have included the query, the query plan, and the table definitions. I just

Re: [PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Guillaume Cottenceau
Yannick Le Guédart writes: > Greetings, > > I was trying to get informations on #portgresql about a query plan I > think is quite strange, and I was said to post on this list. I hope my > mail will be clear enough. I have included the query, the query plan, > and the table definitions

[PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Yannick Le Guédart
Greetings, I was trying to get informations on #portgresql about a query plan I think is quite strange, and I was said to post on this list. I hope my mail will be clear enough. I have included the query, the query plan, and the table definitions. I just don't understand the "Seq