Phoenix Kiula <phoenix.kiula@xxxxxxxxx> writes: > I did a COPY FROM and populated the entire table. In my hard disk, the > space consumption went up by 64GB. > Yet, when I do a "SELECT * FROM mytable LIMIT 1" the entire DB > crashes. There is no visible record. There should certainly be a "visible record" somewhere, ie, the postmaster log. It might also be productive to look in the kernel log for events around the same time --- OOM kills would be recorded there, and if the true story here is hardware problems there might also be kernel log messages about that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
