151 reputation
7
bio website iradix.com
location New York, United States
age
visits member for 7 months
seen Mar 24 at 21:50
stats profile views 1

Java/Scala consultant with 10+ years experience developing interactive web applications that leverage open source technologies like PostgreSQL, Lift, Apache, Nginx, etc...


Feb
6
reviewed Excellent mariadb ignoring force index
Feb
6
reviewed Reviewed selecting where two columns are in a set
Feb
6
reviewed Excellent Kerberos authentication not working with Linked Servers in SQL Server 2012
Feb
6
awarded  Custodian
Feb
6
reviewed Satisfactory What would be the correct size of redo logs?
Feb
6
reviewed Satisfactory Finding longest matching prefix
Feb
6
reviewed Reviewed Continuing failovers on production server
Feb
6
reviewed Satisfactory How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages?
Feb
6
reviewed Excellent Recovery time effects of AlwaysOn
Feb
6
awarded  Custodian
Feb
5
awarded  Scholar
Feb
5
accepted PostgreSQL pg_stat_activity shows COMMIT
Feb
5
answered PostgreSQL pg_stat_activity shows COMMIT
Jan
15
comment PostgreSQL pg_stat_activity shows COMMIT
@CraigRinger the controller does have a battery-backed write cache, and that is currently enabled. Await from iostat remained in the single to low double digits. We will continue to try some more profiling with perf. I also fixed the formatting of the second VMStat, thank you for pointing that out.
Jan
15
revised PostgreSQL pg_stat_activity shows COMMIT
formatted second VMStat output
Jan
14
revised PostgreSQL pg_stat_activity shows COMMIT
added VMStat output
Jan
14
comment PostgreSQL pg_stat_activity shows COMMIT
@trygvis - I Updated the question with the disk specs. The issue is happening on the Master node. I have not tried to promote the Slave and direct traffic to it, so I am not sure if it is an issue there as well under the same circumstances. As a slave, the machine does not seem to experience any issues.
Jan
14
awarded  Editor
Jan
14
revised PostgreSQL pg_stat_activity shows COMMIT
Added hardware summary
Jan
14
awarded  Student