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

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples
Дата
в 00:31:11
Msg-id
20180522213111.7cxyfmgrdjqfa7yv@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
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 Tom Lane <tgl@sss.pgh.pa.us>
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 Tom Lane <tgl@sss.pgh.pa.us>
Re: 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 Tom Lane <tgl@sss.pgh.pa.us>
Re: 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 Vik Fearing <vik.fearing@2ndquadrant.com>
Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples David Rowley <david.rowley@2ndquadrant.com>
On 2018-05-23 09:04:35 +1200, David Rowley wrote:
> Thanks for pushing.
> 
> On 23 May 2018 at 03:55, Tom Lane  wrote:
> > Hm, so why is the correct rowcount returned --- are we running
> > a separate counter for that purpose, and if so why?
> 
> I thought the output I pasted was clearly showing it not to be the
> same. 4299999999 vs 4300000000.
> 
> Did I misunderstand you?

Well, the row-returned counter is obviously wide enough, otherwise
4299999999 couldn't be returned. Tom's point, as I understood it, is
that we obviously have one wide enough counter - why can't we reuse that
for the one you made wider.  And it doesn't seem entirely trivial to do
so, so your patch is easier.

Greetings,

Andres Freund

В списке pgsql-hackers по дате отправления
От: David Rowley
Дата:
От: David Rowley
Дата:
FAQ