Re: [PERFORM] help with too slow query

NSTRAINT ism_installation_longitude_minute_check CHECK (0 <= longitude_minute AND longitude_minute < 60),   CONSTRAINT ism_installation_longitude_second_check CHECK (0::double precision <= longitude_second AND longitude_second < 60::double precision),   CONSTRAINT ism_installation_name_check CHECK (name::text <> '

[PERFORM] help with too slow query

.75..2.75 rows=40 width=8) (actual time=390.274..390.274 rows=40 loops=1)" "  Buckets: 1024  Batches: 1  Memory Usage: 2kB" "          ->  Seq Scan on ism_groupxinstalla

Re: [PERFORM] limit order by performance issue

e changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance -- Pedro Jiménez Pérez p.jime...@ismsolar.com Innovación