From: | "Sven Kerkling" <kerkling(at)bds-online(dot)com> |
---|---|
To: | "'Albe Laurenz'" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "'postgres performance list'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Performance problems with postgres and null Values? |
Date: | 2016-04-26 10:13:03 |
Message-ID: | 002801d19fa4$3aa6adf0$aff409d0$@bds-online.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thx.
All queries are now running as usual.
Thx for helping me.
Best regards
Sven
-----Ursprüngliche Nachricht-----
Von: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] Im Auftrag von Albe Laurenz
Gesendet: Montag, 25. April 2016 10:08
An: 'Sven Kerkling *EXTERN*'; 'Merlin Moncure'
Cc: 'postgres performance list'
Betreff: Re: [PERFORM] Performance problems with postgres and null Values?
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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
From | Date | Subject | |
---|---|---|---|
Next Message | Artem Tomyuk | 2016-04-26 14:03:08 | Poor disk (virtio) Performance Inside KVM virt-machine vs host machine |
Previous Message | Adam Brusselback | 2016-04-25 17:23:28 | Re: Performant queries on table with many boolean columns |