port_id = volume.switchport_id
andv.insert_timestamp < volume.insert_timestamp);
I suppose I can check with an analyze before I execute it (I still
have to alter the table to add the delta columns).
Thanks,
Landreville
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To
and the only daemon is Postgres:
effective cache size is 768MB
shared buffers are 256MB
work_mem is 2MB (I changed it when the explain analyze was showing
1.5MB used for an on disk sort)
max locks per transaction is 3000 (I changed it when I started getting
the error that suggests I cha
