Christopher Petrilli <[EMAIL PROTECTED]> writes: > As I'm doing this, I'm noticing something *VERY* disturbing to me: > postmaster backend: 20.3% CPU > psql frontend: 61.2% CPU
> WTF? The only thing going through the front end is the COPY command, > and it's sent to the backend to read from a file? Are you sure the backend is reading directly from the file, and not through psql? (\copy, or COPY FROM STDIN, would go through psql.) But even so that seems awfully high, considering how little work psql has to do compared to the backend. Has anyone ever profiled psql doing this sort of thing? I know I've spent all my time looking at the backend ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq