Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples
Дата
Msg-id 7911.1527004526@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY FROM WITH HEADER skips a tuple every 4 billion tuples  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples  (Andres Freund <andres@anarazel.de>)
Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes:
> while it might not look too scary by itself, it gets a bit more so
> when you learn that the cur_lineno is only 32 bits wide. This will
> result in skipping a tuple every time the 32-bit variable wraps back
> around to 0 again.

Hm, so why is the correct rowcount returned --- are we running
a separate counter for that purpose, and if so why?

            regards, tom lane


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

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Postgres, fsync, and OSs (specifically linux)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ppc64le support in 9.3 branch?