From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Chris Redekop <chris(at)replicon(dot)com>
Subject:
Re: pg_last_xact_insert_timestamp
Date:
2011-09-08 13:03:14
Message-ID:
CA+TgmoZMeb0w9g0oCP88MGvdVFaO+gqRsxrA=szChrvzQwgsBQ@mail.gmail.com (view raw or flat )
Thread:
2011-09-08 08:36:38 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-08 08:55:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-09-08 10:14:46 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-08 13:03:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-08 22:33:39 from Chris Redekop <chris(at)replicon(dot)com>
2011-09-09 00:42:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-09 15:32:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-11 04:24:10 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-14 09:21:08 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)oss(dot)ntt(dot)co(dot)jp>
2011-09-15 08:52:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-23 13:34:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-29 08:20:33 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)oss(dot)ntt(dot)co(dot)jp>
2011-09-29 12:21:32 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-30 02:24:43 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)oss(dot)ntt(dot)co(dot)jp>
2011-09-30 07:18:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-09-30 19:11:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-30 19:22:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-09-30 19:57:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-30 20:07:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-10-02 11:10:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-10-02 12:21:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-10-03 19:07:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-10-03 20:25:01 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-10-03 20:33:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-10-04 12:05:29 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-10-04 13:15:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-10-13 12:25:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-12-06 11:49:29 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-12-10 12:29:39 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2011-12-12 12:17:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-14 16:06:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-12 13:45:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-12-12 14:24:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-12 14:47:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-12-12 14:51:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-12 14:53:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-12-12 22:08:51 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2011-10-03 09:56:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-10-02 11:19:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-10-02 21:35:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-10-03 09:31:47 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-10-04 11:52:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Lists:
pgsql-hackers
On Thu, Sep 8, 2011 at 6:14 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> OTOH, new function enables users to monitor the delay as a timestamp.
> For users, a timestamp is obviously easier to handle than LSN, and the delay
> as a timestamp is more intuitive. So, I think that it's worth adding
> something like pg_last_xact_insert_timestamp into core for improvement
> of user-friendness.
It seems very nice from a usability point of view, but I have to agree
with Simon's concern about performance. Actually, as of today,
WALInsertLock is such a gigantic bottleneck that I suspect the
overhead of this additional bookkeeping would be completely
unnoticeable. But I'm still reluctant to add more centralized
spinlocks that everyone has to fight over, having recently put a lot
of effort into getting rid of some of the ones we've traditionally
had.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
Responses
pgsql-hackers by date
Next :From: Aidan Van DykDate: 2011-09-08 13:09:37Subject : Re: postgresql.conf archive_command examplePrevious :From : Marti RaudseppDate : 2011-09-08 12:59:57Subject : Re: [PATCH] Don't truncate integer part in to_char for 'FM99.'
