Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 COPY performance regression on Solaris - Mailing list pgsql-performance

From Kenneth Marshall
Subject Re: 8.4 COPY performance regression on Solaris
Date
Msg-id 20090619133349.GI23785@it.is.rice.edu
Whole thread Raw
In response to 8.4 COPY performance regression on Solaris  (Alan Li <ali@truviso.com>)
Responses Re: 8.4 COPY performance regression on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Hi,

Looking at the XLogInsert() from 8.3 and 8.4, the 8.4
version includes a call to RecoveryInProgress() at
the top as well as a call to TRACE_POSTGRESQL_XLOG_INSERT().
Could either of those have caused a context switch or
cache flush resulting in worse performance.

Cheers,
Ken

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: select max() much slower than select min()
Next
From: "Dave Dutcher"
Date:
Subject: Re: select max() much slower than select min()