PostgreSQL: How much memory should I allocate as ramdisk for "pg_stat_tmp"?
2
votes
0
answers
37
views
We have been facing a problem in an
Azure VM
running PostgreSQL13
where a recurring issue of disk availability
causing statistics collector process
to stall for few seconds followed by slow queries. After searching few threads I have found that changing pg_stat_tmp
to ramdisk
could resolve this and maybe improve performance as well.
What would be the best size to allocate ramdisk? Is there any way to calculate? What could possibly happen if collector run out of this allocated memory?
Asked by goodfella
(595 rep)
Apr 28, 2025, 04:45 AM