Re: [SQL] [HACKERS] Index of a table is not used (in any case)

2001-10-23 Thread Doug McNaught
Reiner Dassing <[EMAIL PROTECTED]> writes: > Hello PostgreSQl Users! > > PostSQL V 7.1.1: > > I have defined a table and the necessary indices. > But the index is not used in every SELECT. (Therefore, the selects are > *very* slow, due to seq scan on > 20 million entries, which is a test setup

Re: [SQL] [HACKERS] Index of a table is not used (in any case)

2001-10-23 Thread Christopher Kings-Lynne
> Hello PostgreSQl Users! > > PostSQL V 7.1.1: You should upgrade to 7.1.3 at some point... > I have defined a table and the necessary indices. > But the index is not used in every SELECT. (Therefore, the selects are > *very* slow, due to seq scan on > 20 million entries, which is a test setup u