Re: Impact of checkpoint_segments under continual load conditions

From: Christopher Petrilli <petrilli(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PFC <lists(at)boutiquenumerique(dot)com>, Vivek Khera <vivek(at)khera(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Impact of checkpoint_segments under continual load conditions
Date: 2005-07-19 16:54:35
Message-ID: 59d991c4050719095440cd3de5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gmail(dot)com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-07-19 17:05:25 Re: Impact of checkpoint_segments under continual load conditions
Previous Message Tom Lane 2005-07-19 16:54:22 Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?