Postgres Pro
Downloads
Home   >   mailing lists

Re: Impact of checkpoint_segments under continual load conditions - Mailing list pgsql-performance

From Christopher Petrilli
Subject Re: Impact of checkpoint_segments under continual load conditions
Date
Msg-id 59d991c4050719095440cd3de5@mail.gmail.com
Whole thread Raw
In response to Re: Impact of checkpoint_segments under continual load conditions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Impact of checkpoint_segments under continual load conditions
List pgsql-performance
Tree view 
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?

Chris
--
| Christopher Petrilli
| petrilli@gmail.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Next
From: Tom Lane
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions