Postgres Pro
Downloads
Home   >   mailing lists

Re: A little COPY speedup - Mailing list pgsql-patches

From Simon Riggs
Subject Re: A little COPY speedup
Date
Msg-id 1172827751.3760.1362.camel@silverbirch.site
Whole thread Raw
In response to A little COPY speedup  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: A little COPY speedup
Re: A little COPY speedup
List pgsql-patches
Tree view 
On Thu, 2007-03-01 at 17:01 +0000, Heikki Linnakangas wrote:

> I ran oprofile on a COPY FROM to get an overview of where the CPU time
> is spent. To my amazement, the function at the top of the list was
> PageAddItem with 16% of samples.

Excellent.

I'm slightly worried though since that seems to have changed from 8.2,
which I oprofiled over Christmas. I can't recall what's changed though.
Was this just on one system? Is it possible there is an effect on one
system and not another?

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Numeric patch to add special-case representations for < 8 bytes
Next
From: Heikki Linnakangas
Date:
Subject: Re: A little COPY speedup