Re: Performance problems with postgres and null Values?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sven Kerkling wrote:
> 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

I think the problem is here:

Bitmap Index Scan on masterNew_2016_pi_idx (cost=0.00..5.34 rows=181 width=0) (actual time=805.225..805.225 rows=4,764,537 loops=1)

Perhaps you should ANALYZE "masterNew" to get better statistics.

Yours,
Laurenz Albe

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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux