On 04/02/2014 03:11 PM, Adrian Klaver wrote:
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?
I labour under the delusion that it is through the controller one reads
and writes and that there might be some slight advantage to not doing
both against one drive if avoidable. Wrong again?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
