pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: wambacher@posteo.de
To: pgsql-admin@lists.postgresql.org
Subject: Re: tuple concurrently updated
Date: Tue, 28 Aug 2018 16:21:20 +0200
Message-ID: <29a5947f-d8b8-377e-d514-62e453646ce8@posteo.de> (raw)
In-Reply-To: <1495817175.367327613.1535463961983.JavaMail.root@zimbra82-e14.priv.proxad.net>
References: <1495817175.367327613.1535463961983.JavaMail.root@zimbra82-e14.priv.proxad.net>

see postgresql.auto.conf:

# Do not edit this file manually!
# It will be overwritten by ALTER SYSTEM command.
autovacuum = 'true'
shared_buffers = '16GB'
max_stack_depth = '4MB'
autovacuum_max_workers = '4'
work_mem = '1GB'
listen_addresses = '*'
max_connections = '300'
max_worker_processes = '8'
max_parallel_workers_per_gather = '2'
max_wal_size = '4GB'
max_wal_senders = '0'
max_locks_per_transaction = '128'
ssl = 'on'
log_min_messages = 'error'
log_connections = 'off'
log_hostname = 'off'
maintenance_work_mem = '4GB'
log_min_duration_statement = '30000'
checkpoint_completion_target = '0.85'
track_io_timing = 'on'
effective_cache_size = '2GB'
log_checkpoints = 'on'
wal_level = 'minimal'
wal_compression = 'on'
checkpoint_timeout = '5min'

and the storage hardware is on hdd


Am 28.08.2018 um 15:46 schrieb 066ce286@free.fr:
> AAMOF, what are your fsync/wal_sync_method parameters, and what is your storage hardware ?
>

view thread (28+ messages)  latest in thread

Message-ID: <29a5947f-d8b8-377e-d514-62e453646ce8@posteo.de>
Permalink:  ../29a5947f-d8b8-377e-d514-62e453646ce8@posteo.de/
Also on:    postgresql.org/message-id/29a5947f-d8b8-377e-d514-62e453646ce8@posteo.de

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: wambacher@posteo.de, pgsql-admin@lists.postgresql.org
  Subject: Re: tuple concurrently updated
  In-Reply-To: <29a5947f-d8b8-377e-d514-62e453646ce8@posteo.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox