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

From: Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples
Date: 2018-05-22 21:16:43
Message-ID: a03aa5d0-2f88-61bd-7d12-423600f064b2@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 22/05/18 23:04, David Rowley wrote:
> Thanks for pushing.
>
> On 23 May 2018 at 03:55, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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?

I think Tom was wondering why it isn't showing 5032703.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-05-22 21:19:37 Re: Error on vacuum: xmin before relfrozenxid
Previous Message David Rowley 2018-05-22 21:04:35 Re: COPY FROM WITH HEADER skips a tuple every 4 billion tuples