| From: | harisankar(dot)valiyattil(at)capitalone(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | harisankar(dot)valiyattil(at)capitalone(dot)com |
| Subject: | BUG #14831: Intermittent write blocks |
| Date: | 2017-09-27 20:59:33 |
| Message-ID: | 20170927205933.28566.16411@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14831
Logged by: Harisankar Valiyattil
Email address: harisankar(dot)valiyattil(at)capitalone(dot)com
PostgreSQL version: 9.4.7
Operating system: linux
Description:
We use postgres on amazon RDS. We have a table with close to 15 million data
now and an application is constantly firing some update(insert/update)
operations to this table at around 25 transactions per second. the table has
a jsonb column which has a gin index on it; the jonb data has appx 20-40
attrinbutes in an average. The application keep on updating data on this
jsonb column.
While the traffic is running, we see that there is a sudden drop in the
write operations (no write happening in DB) causing increase in RDS cpu,
queue depth etc. after a few seconds (30 sec, 60 sec) things come back to
normal. If the traffic is constant this repeats at constant intervals.
Our work_mem is 4MB.
What could be causing this? What kind of troubleshooting we can do? What is
the process that runs in the background that causes this intermittant write
delay?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2017-09-27 21:06:10 | Re: BUG #14831: Intermittent write blocks |
| Previous Message | Tom Lane | 2017-09-27 18:52:54 | Re: [HACKERS] BUG #14825: enum type: unsafe use? |