Re: [PATCH] Better logging of COPY queries if log_statement='all'

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: [PATCH] Better logging of COPY queries if log_statement='all'
Дата
Msg-id 20161017151343.GA7111@e733.localdomain
обсуждение исходный текст
Ответ на Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Stephen Frost <sfrost@snowman.net>)
Re: [PATCH] Better logging of COPY queries if log_statement='all'  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-hackers
> > I'm not in favor of this, especially if it's not even optional.
>
> I'm not either.  It sounds good when you're looking at toy examples,
> but not when it means repeating gigabytes of COPY data into the log.

I understand your concern. Perhaps we could create and additional
parameter for enabling/disabling this feature or a new log_statement
value, or maybe both - i.e. rename log_statement and add a new possible
value?

According to my colleagues it would be very nice to have this feature.
For instance, if you are trying to optimize PostgreSQL for application
that uses COPY and you don't have access to or something like this.
It could also be useful in some other cases.

This feature is very simple and easy to maintain. I'm sure we could find
a solution that will make happy both developers and users.

--
Best regards,
Aleksander Alekseev

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Replace PostmasterRandom() with a stronger way of generating ran
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Replace PostmasterRandom() with a stronger way of generating ran