| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Vladimir Borodin <root(at)simply(dot)name> |
| Cc: | Александр Коротков <aekorotkov(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Ildus Kurbangaliev <i(dot)kurbangaliev(at)postgrespro(dot)ru>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "andres(at)anarazel(dot)de" <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us> |
| Subject: | Re: RFC: replace pg_stat_activity.waiting with something more descriptive |
| Date: | 2015-09-21 01:17:00 |
| Message-ID: | CA+TgmobJqaO9YzAbuh35a_wQfQuybPJYucxWM5FaSxWvAU3dCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Sep 18, 2015 at 4:43 PM, Vladimir Borodin <root(at)simply(dot)name> wrote:
> No, probably you misunderstood the results, let me explain one more time.
Yeah, I did, sorry.
> Unpatched PostgreSQL from REL9_4_STABLE gave 15500 tps. Version with timings
> - 14500 tps which is 6,5% worse. Version with sampling wait events every 10
> ms gave 13800 tps (11% worse than unpatched and 5% worse than with timings).
OK.
So, I don't really care about the timing stuff right now. I want to
get the stuff without timings done first. To do that, we need to come
to an agreement on how much information we're going to try to expose
and from where, and we need to make sure that doing that doesn't cause
a performance hit. Then, if we want to add timing as an optional
feature for people who can tolerate the overhead, that's fine.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gurjeet Singh | 2015-09-21 02:03:43 | Limit GIST_MAX_SPLIT_PAGES to XLR_MAX_BLOCK_ID |
| Previous Message | Peter Geoghegan | 2015-09-21 01:04:28 | Re: Speed up Clog Access by increasing CLOG buffers |