sql – Running select command on postgres relational Table containing data in tera bytes

sql – Running select command on postgres relational Table containing data in tera bytes

Killed suggests youre running on a system where the out-of-memory killer (OOM killer) is enabled by memory over-commit settings. This isnt recommended by the manual.

If you disable overcommit youll get a neater out of memory error to the client instead of a sigkill and server re-start.

As for the COPY … are you running COPY (SELECT ...) ? Or just COPY tablename TO .... ? Try a direct copy without a query, see if that helps.

When diagnosing faults you should be looking at the PostgreSQL error logs (which would tell you more about this problem) and system logs like the kernel logs or dmesg output.

When asking questions about PostgreSQL on Stack Overflow always include the exact server version from select version(), the exact command text/code run, the exact unedited text of any error messages, etc.

sql – Running select command on postgres relational Table containing data in tera bytes

Leave a Reply

Your email address will not be published.