Re: Performance problems with postgres and null Values?

This one is quick, running in 20ms:

SELECT b.id, b.status
FROM export b, masterOld mb
WHERE mb.sperre IS NULL
AND mb.status IS NULL
AND b.id_firma = mb.id_firma
LIMIT 100;

http://explain.depesz.com/s/SCBo

This one ist the burden, running at least 100 seconds:

SELECT b.id, b.status
FROM export b, masterNew mb
WHERE mb.sperre IS NULL
AND mb.status IS NULL
AND b.id = mb.id
LIMIT 100;

http://explain.depesz.com/s/eAqG

There should be only slight differences between them.

Sven

-----Ursprüngliche Nachricht-----
Von: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] Im Auftrag von Merlin Moncure
Gesendet: Samstag, 23. April 2016 00:11
An: Sven Kerkling
Cc: postgres performance list
Betreff: Re: [PERFORM] Performance problems with postgres and null Values?

On Thu, Apr 21, 2016 at 4:49 AM, Sven Kerkling <kerkling(at)bds-online(dot)com> wrote:
> Can somebody help me with these performance Problem.
>
> What can I try to solve this?

can you explain what the problem actually is? Which query is running slow and how fast do you think it should run?

merlin

--
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance