https://forum.postgresql.org.pl/viewtopic.php?id=157 Thu, 19 Mar 2009 13:56:30 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=640#p640 Index Scan using muarab_broniereczne_a_id_ekwipunek on muarab_broniereczne (cost=0.00..7.03 rows=2 width=4) Index Cond: ((id_muarab_ekwipunek = 1) AND (a = 'A'::text)) (3 rows) Może ktoś ma pomysła jak więcej wycisnąc sekund z takiego zapytania :D]]> Thu, 19 Mar 2009 13:56:30 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=640#p640 https://forum.postgresql.org.pl/viewtopic.php?pid=639#p639 Thu, 19 Mar 2009 13:14:40 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=639#p639 https://forum.postgresql.org.pl/viewtopic.php?pid=635#p635 Wed, 18 Mar 2009 07:23:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=635#p635 https://forum.postgresql.org.pl/viewtopic.php?pid=631#p631 Bitmap Heap Scan on muarab_broniereczne (cost=14.27..18.28 rows=1 width=4) Recheck Cond: ((id_muarab_ekwipunek = 1) AND (a = 'A'::text)) -> BitmapAnd (cost=14.27..14.27 rows=1 width=0) -> Bitmap Index Scan on index_id_muarab_ekwipunek (cost=0.00..2.15 rows=42 width=0) Index Cond: (id_muarab_ekwipunek = 1) -> Bitmap Index Scan on index_a (cost=0.00..11.88 rows=1679 width=0) Index Cond: (a = 'A'::text) (8 rows)]]> Tue, 17 Mar 2009 15:09:37 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=631#p631 https://forum.postgresql.org.pl/viewtopic.php?pid=630#p630 Tue, 17 Mar 2009 14:59:07 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=630#p630 https://forum.postgresql.org.pl/viewtopic.php?pid=628#p628 Tue, 17 Mar 2009 14:36:33 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=628#p628