| From: | Edson Carlos Ericksson Richter <edsonrichter(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | After upgrade from 9.2.9 to 9.3.5 got reduced contention |
| Date: | 2014-09-13 22:44:44 |
| Message-ID: | BLU436-SMTP5896B9026772B9138E7349CFCA0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
After a week or so since upgrade from 9.2.9 to 9.3.5 I'm very surprised
(in a good way) by the gain of performance.
Most noticeable change is the reduced contention for records by
exclusive/shared locks.
I can see increased numbers of requests fulfilled per minute (but I
can't be exact on those numbers, just I can see graph going high - which
is good).
Also, I've noticed that backup time dropped from 44 minutes to 30
minutes (for about 60Gb in multiple databases) - which is really good
change (35% decrease) on same hardware.
I still had no time to measure how much gain on improved indexing and
other topics I know received improvements.
Thanks, PostgreSQL team!
Regards,
Edson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-09-14 00:52:42 | Re: After upgrade from 9.2.9 to 9.3.5 got reduced contention |
| Previous Message | Edson Carlos Ericksson Richter | 2014-09-13 20:11:59 | Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? |