[BUGS] inet/cidr indexes almost not used

2003-01-17 Thread Gleb Kouzmenko
Your name : Gleb Kouzmenko Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.19 PostgreSQL version (ex

Re: [BUGS] inet/cidr indexes almost not used

2003-01-17 Thread Bruce Momjian
OK, see the FAQ on index usage and run some tests. I have just added the following to our FAQ section on index usage: If you believe the optimizer is incorrect in choosing a sequential scan, use SET enable_seqscan TO 'off' and run tests to see if an index scan is indeed faster. ---