https://forum.postgresql.org.pl/viewtopic.php?id=108 Fri, 28 Nov 2008 17:16:32 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=386#p386 Fri, 28 Nov 2008 17:16:32 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=386#p386 https://forum.postgresql.org.pl/viewtopic.php?pid=385#p385 28.11.2008_pec_muarab_rosliny.sql DROP TABLE muarab_rosliny; \i 28.11.2008_pec_muarab_rosliny.sql CZasy już są normalne. DZięki rski za POMOC ! Jak będziesz w pobliżu Legionowa to zajrzyj po pivko :)]]> Fri, 28 Nov 2008 16:30:33 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=385#p385 https://forum.postgresql.org.pl/viewtopic.php?pid=382#p382 Wed, 26 Nov 2008 11:32:17 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=382#p382 https://forum.postgresql.org.pl/viewtopic.php?pid=381#p381 Seq Scan on muarab_przedmiot (cost=0.00..1859.72 rows=56072 width=4) (actual time=0.012..143.361 rows=56924 loops=1) Total runtime: 217.389 ms (3 rows)]]> Wed, 26 Nov 2008 11:30:29 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=381#p381 https://forum.postgresql.org.pl/viewtopic.php?pid=380#p380 Seq Scan on muarab_rosliny (cost=0.00..353200.84 rows=39684 width=4) (actual time=405.285..48602.345 rows=40612 loops=1) Total runtime: 48656.311 ms (3 rows)]]> Wed, 26 Nov 2008 11:28:26 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=380#p380 https://forum.postgresql.org.pl/viewtopic.php?pid=379#p379 Wed, 26 Nov 2008 09:21:46 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=379#p379 https://forum.postgresql.org.pl/viewtopic.php?pid=378#p378 Wed, 26 Nov 2008 07:14:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=378#p378 https://forum.postgresql.org.pl/viewtopic.php?pid=377#p377 Seq Scan on muarab_przedmiot (cost=0.00..1859.72 rows=56072 width=4) (2 rows) q=# explain SELECT count(id_muarab_rosliny) FROM muarab_rosliny; QUERY PLAN ----------------------------------------------------------------------------- Aggregate (cost=353300.05..353300.06 rows=1 width=4) -> Seq Scan on muarab_rosliny (cost=0.00..353200.84 rows=39684 width=4) (2 rows)]]> Tue, 25 Nov 2008 23:21:30 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=377#p377 https://forum.postgresql.org.pl/viewtopic.php?pid=376#p376 Tue, 25 Nov 2008 23:20:20 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=376#p376 https://forum.postgresql.org.pl/viewtopic.php?pid=375#p375 Seq Scan on muarab_rosliny (cost=0.00..547800.01 rows=19640401 width=4) q=# explain SELECT count(id_muarab_przedmiot) FROM muarab_przedmiot; QUERY PLAN ------------------------------------------------------------------------------ Aggregate (cost=2676.80..2676.81 rows=1 width=4) -> Seq Scan on muarab_przedmiot (cost=0.00..2401.24 rows=110224 width=4)]]> Tue, 25 Nov 2008 22:01:41 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=375#p375 https://forum.postgresql.org.pl/viewtopic.php?pid=374#p374 Tue, 25 Nov 2008 18:02:55 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=374#p374 https://forum.postgresql.org.pl/viewtopic.php?pid=373#p373 Tue, 25 Nov 2008 15:38:54 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=373#p373 https://forum.postgresql.org.pl/viewtopic.php?pid=368#p368 Fri, 14 Nov 2008 16:02:43 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=368#p368 https://forum.postgresql.org.pl/viewtopic.php?pid=367#p367 Fri, 14 Nov 2008 14:25:46 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=367#p367