Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept)
Date
Msg-id 20141002122309.GK28859@tamriel.snowman.net
Whole thread Raw
In response to Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept)  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
* Craig Ringer (craig@2ndquadrant.com) wrote:
> > The patch https://commitfest.postgresql.org/action/patch_view?id=885
> > (discussion starts here I hope -
> > http://www.postgresql.org/message-id/4FE8CA2C.3030809@uptime.jp)
> > demonstrates performance problems; LWLOCK_STAT,  LOCK_DEBUG and
> > DTrace-like approach are slow, unsafe for production use and a bit
> > clumsy for using by DBA.
>
> It's not at all clear to me that a DTrace-like (or perf-based, rather)
> approach is unsafe, slow, or unsuitable for production use.

I've certainly had it take production systems down (perf, specifically),
so I'd definitely consider it "unsafe".  I wouldn't say it's unusable,
but it's certainly not what we should have as the end-goal for PG.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: pgcrypto: PGP signatures
Next
From: Robert Haas
Date:
Subject: Re: Replication identifiers, take 3