ISNULL performance tweaks

Поиск
Список
Период
Сортировка
Искать
От
Matt Mello
Тема
ISNULL performance tweaks
Дата
Msg-id
3E67989F.7030001@spaceship.com
Список
Дерево обсуждения
ISNULL performance tweaks Matt Mello <alien@spaceship.com>
Re: ISNULL performance tweaks Josh Berkus <josh@agliodbs.com>
Re: ISNULL performance tweaks Josh Berkus <josh@agliodbs.com>
I have some existing code running in a production environment with 
embedded SELECTs whose WHERE's use ISNULL tests on indexed foreign key 
fields.  This is obviously very slow.

My ISNULL *queries *take anywhere from 6 to 40 seconds.  These queries 
are used to generate reports to a device which times out at 20 seconds, 
so half the time these devices don't get their reports, which makes my 
customers VERY angry.

I recall seeing an email (I believe on this list) about how to improve 
performance of ISNULL's with some sort of tweak or trick.  However, I 
can't find that email anywhere, and couldn't find it searching the 
maillist archives.

So, until I have the time to code the fixes I need to prevent the use of 
ISNULL, does anybody know how I can speed up this existing system?

Man, I wish PG indexed nulls!  Is there any plan on adding these in the 
future?

Thanks for any help you can give!

-- 
Matt Mello

В списке pgsql-performance по дате отправления
От: Josh Berkus
Дата:
От: Josh Berkus
Дата:
Сообщение: Re: ISNULL performance tweaks
FAQ