On Thu, Aug 17, 2017 at 6:00 AM, Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote: > I checked with the storage team in the company and they saw that I have alot > of io on the server. How should I reduce the io that the postgresql uses ? Do you have concurrent activity on that server? What filesystem are you using wherever the data is sitting? If you've got concurrent fsyncs happening, some filesystems handle that poorly. When you've got WAL and data mixed in a single disk, or worse, filesystem, it happens often that the filesystem won't handle the write barriers for the WAL efficiently. I/O gets intermingled with bulk operations, and even small fsyncs will have to flush writes from bulk operations, which makes a mess of things. It is a very good idea, and in fact a recommended practice, to put WAL on its own disk for that reason mainly. With that little RAM, you'll also probably cause a lot of I/O in temp files, so I'd also recommend setting aside another disk for a temp tablespace so that I/O doesn't block other transactions as well. This is all assuming you've got concurrent activity on the server. If not, install iotop and try to see who's causing that much I/O. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
