Am 10.04.19 um 07:40 schrieb Daulat Ram:
We have two node postgresql database version 9.6 with streaming
replication which is running on docker environment, os Linux (Ubuntu)
and we have to migrate on PostgresQL11. I need your suggestions &
steps to compete the upgrade process successfully.
Duncan Kinnear wrote:
> Bingo! Adding 'SET LOCAL synchronous_commit TO OFF;' to my 'BEGIN; UPDATE
> ; COMMIT;'
> block has given me sub-1ms timings! Thanks Andres.
That's a pretty clear indication that your I/O subsystem was overloaded.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec
Hello team.
We have two node postgresql database version 9.6 with streaming replication
which is running on docker environment, os Linux (Ubuntu) and we have to
migrate on PostgresQL11. I need your suggestions & steps to compete the upgrade
process successfully.
Regards,
Daulat
- On 10 Apr, 2019, at 10:23 AM, Andres Freund and...@anarazel.de wrote:
> On 2019-04-09 17:12:27 -0500, Justin Pryzby wrote:
>> You could test that's the issue by comparing with fsync=off (please read what
>> that means and don't run your production cluster like that).
>> https://www.postgresq
