Re: Query stucked in pg_stat_activity

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Query stucked in pg_stat_activity
Дата
Msg-id 20050809143520.GA18405@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Query stucked in pg_stat_activity  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
On Tue, Aug 09, 2005 at 04:25:30PM +0200, Csaba Nagy wrote:
> The logs don't show the "statistics buffer is full" message as suggested
> by Tom, but ITOH "log_min_messages = info", and that message might be a
> debug level one.

The message is in src/backend/postmaster/pgstat.c:

    if (!overflow)
    {
        ereport(LOG,
                (errmsg("statistics buffer is full")));
        overflow = true;
    }

For log_min_messages, LOG is just above FATAL and PANIC, so I'd
expect those messages to appear in the logs if they're happening.
But I don't recall seeing them either.

> In any case it seems my system can readily reproduce the issue whenever
> I place a bigger load on it...

I was also able to reproduce the behavior when running pgbench with
sufficiently high settings.

--
Michael Fuhr

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

Предыдущее
От: Lowell.Hought@faa.gov
Дата:
Сообщение: Database syncronization
Следующее
От: TJ O'Donnell
Дата:
Сообщение: best way to reference tables