Re: High WriteLatency RDS Postgres 9.3.20

2018-06-19 Thread Juan Manuel Cuello
On Tue, Jun 19, 2018 at 12:16 AM Benjamin Scherrey < scher...@proteus-tech.com> wrote: > I would also add that AWS' I/O capabilities are quite poor and expensive. > I assume that you have tried purchasing additional IOOPs on that setup to > see whether you got an expected speed up? If not you shou

Re: High WriteLatency RDS Postgres 9.3.20

2018-06-19 Thread Juan Manuel Cuello
On Mon, Jun 18, 2018 at 7:23 PM Andres Freund wrote: > > So far it's been almost two months of investigation > > and people at AWS technical support don't seem to find the cause. I think > > it could be related to Postgres and the number of schema/tables in the > > database, that's why I post thi

Re: High WriteLatency RDS Postgres 9.3.20

2018-06-18 Thread Benjamin Scherrey
I would also add that AWS' I/O capabilities are quite poor and expensive. I assume that you have tried purchasing additional IOOPs on that setup to see whether you got an expected speed up? If not you should try that as a diagnostic tool even if you wouldn't want to pay that on an ongoing basis. W

Re: High WriteLatency RDS Postgres 9.3.20

2018-06-18 Thread Andres Freund
On 2018-06-18 18:43:06 -0300, Juan Manuel Cuello wrote: > I'm experiencing high WriteLatency levels in a Postgres server 9.3.20 > hosted in Amazon RDS. A lot of performance improvements have been made since 9.3, and it'll soon-ish be out of support. If you can reproduce the issue on postgres prop

High WriteLatency RDS Postgres 9.3.20

2018-06-18 Thread Juan Manuel Cuello
Hi, I'm experiencing high WriteLatency levels in a Postgres server 9.3.20 hosted in Amazon RDS. So far it's been almost two months of investigation and people at AWS technical support don't seem to find the cause. I think it could be related to Postgres and the number of schema/tables in the datab