Re: [HACKERS] Performance testing of COPY (SELECT) TO

Поиск
Список
Период
Сортировка
От Böszörményi Zoltán
Тема Re: [HACKERS] Performance testing of COPY (SELECT) TO
Дата
Msg-id 4213.213.163.11.81.1156755523.squirrel@www.dunaweb.hu
обсуждение исходный текст
Ответы Re: [HACKERS] Performance testing of COPY (SELECT) TO  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: [HACKERS] Performance testing of COPY (SELECT) TO  (Böszörményi Zoltán <zboszor@dunaweb.hu>)
Список pgsql-patches
Hi,

what's the problem with COPY view TO, other than you don't like it? :-)
That was the beginning and is used in production
according to the original authors.

> I also broke the check for a FOR UPDATE clause.  Not sure where but it
> must be easy to fix :-)  I'd do it myself but I'm heading to bed right
> now.

Fixed.

> I also wanted to check these hunks in your patch, which I didn't like
> very much:
>
> -ERROR:  column "a" of relation "test" does not exist
> +ERROR:  column "a" does not exist

It was because of too much code sharing. I fixed it by passing
the relation name to CopyGetAttnums() in the relation case,
so the other regression tests aren't bothered now.

The docs and the regression test is modified according to your version.

Best regards,
Zoltán Böszörményi

Вложения

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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: [HACKERS] Interval aggregate regression failure (expected seems
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes