Vivek Khera wrote:
If you've got the time, could you try also doing the full bulk insert
test with the checkpoint log files on another physical disk? See if
that's any faster.
We have been doing that for a few weeks, but the performance
improvements are less than what we expected. There is
Florian Weimer wrote:
After an upgrade to 7.4.1 (from 7.3) we see a severe performance
regression in bulk INSERTs.
In turns out that we were running the default configuration, and not the
tuned one in /etc/postgresql. *blush*
After increasing the number of checkpoint segments and the
Would turning autocommit off help?
Vivek Khera wrote:
FW == Florian Weimer [EMAIL PROTECTED] writes:
FW After increasing the number of checkpoint segments and the shared-memory
FW buffers, performance is back to the expected levels. It might even be a
FW bit faster.
If you've got the time,
FW == Florian Weimer [EMAIL PROTECTED] writes:
FW After increasing the number of checkpoint segments and the shared-memory
FW buffers, performance is back to the expected levels. It might even be a
FW bit faster.
If you've got the time, could you try also doing the full bulk insert
test with
