thank you very much justin, i am seeing install the product you recommended
me!
--
Sent from:
https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
thank you very much jeff I'll see with the team that manages the operating
system to see if they can help me with this data that you have given me
--
Sent from:
https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
On Mon, Oct 14, 2019 at 1:25 PM dangal wrote:
> Do you think it should increase bgwriter_lru_maxpages due to the value of
> maxwritten_clean?
>
I find the background writer to be pretty unimportant these days. If the
kernel is freely accepting writes without blocking, the backends can
probably
Excuse me, can you tell me how can I achieve this?
"The question is how that compared to database size, and size of the
active set (fraction of the database accessed by the application /
queries)."
--
Sent from:
https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
Hi Tomas, restart the statistics and take 24-hour samples to see if you can
help me
24 gb server memory 6 gb sharred buffers
# select now,
# pg_size_pretty(buffers_checkpoint*8192)AS buffers_checkpoint,
# pg_size_pretty(buffers_clean*8192)AS buffers_clean,
# pg_size_pretty(buffers_backend*8192)
On Mon, Oct 14, 2019 at 01:12:43PM -0700, dangal wrote:
Thanks a lot, always helping
I attached a snapshot that I take every 12 hours of the pg_stat_bgwriter
select now,buffers_checkpoint,buffers_clean, buffers_backend from
pg_stat_bgwriter_snapshot;
Please show us the deltas, i.e. subtract th
On Mon, Oct 14, 2019 at 08:18:47PM +0200, Tomas Vondra wrote:
> Note: FWIW, a single snapshot of pg_stats* may be misleading, because
> it's cumulative, so it's not clear how accurately it reflects current
> state. Next time take two snapshots and subtract them.
For bonus points, capture it with t
Thanks a lot, always helping
I attached a snapshot that I take every 12 hours of the pg_stat_bgwriter
select now,buffers_checkpoint,buffers_clean, buffers_backend from
pg_stat_bgwriter_snapshot;
now | buffers_checkpoint | buffers_clean |
buffers_backend
On Sun, Oct 13, 2019 at 06:27:35PM -0700, dangal wrote:
Dear I would like to share with you to see what you think about the
statistics of pg_stat_bgwriter
postgres = # select * from pg_stat_bgwriter;
 checkpoints_timed | checkpoints_req | checkpoint_write_time |
checkpoint_sync_time | buffers_ch
