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
Дата
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
Дата: