Re: Measuring database IO for AWS RDS costings

Поиск
Список
Период
Сортировка
От David Osborne
Тема Re: Measuring database IO for AWS RDS costings
Дата
Msg-id CAKmpXCeJMJ-VsisJe8_Cc2d3soKH4VvgZmUz5oTquxcVvK7bkw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Measuring database IO for AWS RDS costings  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin

You're right that they are 8kB blocks (by default). But it's not read from disk, is more "postgresql asks the OS to give it the blocks". They may come from the disk, but they also may come from the OS disk cache. You can't find actual disk reads and writes from PostgreSQL.

Thanks.
That makes it a bit tricky then.
So my best bet might be running iostat on the physical server and calculating Blk_read + Blk_wrtn for a period (4kb blocks in this case) and using that to estimate how many 16kb IO's that might translate to on AWS's RDS service for a month.


--
David 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade hangs
Следующее
От: John Scalia
Дата:
Сообщение: Re: pg_upgrade hangs