Re: Using index for IS NULL query
От
Matthew Wakeling
Тема
Re: Using index for IS NULL query
Дата
Msg-id
alpine.DEB.1.10.0811121327550.4666@aragorn.flymine.org
Ответ на
Re: Using index for IS NULL query (Tom Lane)
Список
Дерево обсуждения
Using index for IS NULL query "Andrus" <kobruleht2@hot.ee>
Re: Using index for IS NULL query Tom Lane <tgl@sss.pgh.pa.us>
Re: Using index for IS NULL query Andreas Kretschmer <akretschmer@spamfence.net>
Re: Using index for IS NULL query Matthew Wakeling <matthew@flymine.org>
Re: Using index for IS NULL query Andreas Kretschmer <akretschmer@spamfence.net>
Re: Using index for IS NULL query Tomas Vondra <tv@fuzzy.cz>
Index usage with sub select or inner joins "Julien Theulier" <julien@squidsolutions.com>
Re: Index usage with sub select or inner joins Joshua Tolley <eggyknap@gmail.com>
Re: Index usage with sub select or outer joins "Julien Theulier" <julien@squidsolutions.com>
Re: Using index for IS NULL query "Vladimir Sitnikov" <sitnikov.vladimir@gmail.com>
Re: Using index for IS NULL query Tomas Vondra <tv@fuzzy.cz>
Re: Using index for IS NULL query "Scott Marlowe" <scott.marlowe@gmail.com>
On Tue, 11 Nov 2008, Tom Lane wrote: >> Index is not used for >> is null >> How to fix ? > > Update to something newer than 8.1 (specifically, you'll need 8.3). Oooh, that's useful to know. We can get rid of all our extra nulls indexes. Thanks. Matthew -- As you approach the airport, you see a sign saying "Beware - low flying airplanes". There's not a lot you can do about that. Take your hat off? -- Michael Flanders
В списке pgsql-performance по дате отправления
