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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match