Re: [PROPOSAL] timestamp informations to pg_stat_statements

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [PROPOSAL] timestamp informations to pg_stat_statements
Дата
Msg-id CAM3SWZRSY9Fa3Ve1E=xFL-qsOQHH92xaV-zeFPV+j5k9kMXvkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PROPOSAL] timestamp informations to pg_stat_statements  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PROPOSAL] timestamp informations to pg_stat_statements  (Jason Kim <dialogbox@gmail.com>)
Список pgsql-hackers
On Sun, Jul 17, 2016 at 4:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The concern I've got about this proposal is that the results get very
> questionable as soon as we start dropping statement entries for lack
> of space.  last_executed would be okay, perhaps, but first_executed
> not so much.

Agreed.

Also, for what it's worth, I should point out to Jun that
GetCurrentTimestamp() should definitely not be called when a spinlock
is held like that.

-- 
Peter Geoghegan



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Obsolete comment within fmgr.c
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: DO with a large amount of statements get stuck with high memory consumption