Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.

From: Joel Jacobson <joel(at)trustly(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Marko Tiikkaja <marko(at)trustly(dot)com>
Subject: Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.
Date: 2016-03-11 20:44:19
Message-ID: CAASwCXe-W74-LKZRiKCfjiMz3HrvxYdxeCasZ2TDBT3-kZTBuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Mar 11, 2016 at 11:14 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I'm not direly opposed to most of what's on that page,
> but I'm not excited about most of it, either.

May I ask, what improvements of PL/pgSQL would you personally be most
excited about,
if you or someone else would have unlimited resources to hack on it?

> I bet if we canvassed 10 different companies that made heavy use of PL/pgsql they'd all have
> a list of proposed changes like that, and I bet some of them would
> conflict with each other, and I bet if we did all that stuff the
> average PL/pgsql user's life would not be much better, but the manual
> would be much longer.

You as a professional PostgreSQL consultant obviously have a lot of more
contact than me with other companies who make heavy use of PL/pgSQL.

I'm assuming your bet on these proposed changes in conflict you talk about
are based on things you've picked up IRL from companies you've been
working with.

What would you say are the top most commonly proposed changes
from companies that make heavy use of PL/pgSQL, and which of those are
in conflict?

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-03-11 21:08:49 Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.
Previous Message Robert Haas 2016-03-11 17:36:34 pgsql: pg_upgrade: Convert old visibility map format to new format.

Browse pgsql-hackers by date

  From Date Subject
Next Message Vladimir Borodin 2016-03-11 20:53:15 Re: Background Processes and reporting
Previous Message Tom Lane 2016-03-11 20:35:49 Re: eXtensible Transaction Manager API (v2)