On 04/02/2014 02:04 PM, Rob Sargent wrote:
On 04/02/2014 02:36 PM, Adrian Klaver wrote:
On 04/02/2014 01:14 PM, Rob Sargent wrote:
On 04/02/2014 01:56 PM, Steve Atkins wrote:
Well indeed there are copious LOG/HINT pairs along the lines of
LOG: checkpoints are occurring too frequently ([8 <= n <=29]
seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
and these are during non-load periods. During the COPYs I see
uncountable numbers of
WARNING: pgstat wait timeout
As you guys have probably already concluded, I have some config/tuning
to do.
At a guess some of the problem comes from here:
"The input file and postgres data are on separate disks, but only one
controller."
Have you tried moving the input file to the same disk as the server, to
factor out the controller?
Cheers,
rjs
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
