| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Natalie Wenz <nataliewenz(at)ebureau(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Insert result does not match record count |
| Date: | 2013-07-22 16:20:10 |
| Message-ID: | CAMkU=1yyCqGh1gSi_Wt1TTnpAVVpMq+q6=rY4V4v-scLDKb-Hw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wenz <nataliewenz(at)ebureau(dot)com> wrote:
> Hi all,
>
> I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario:
>
> insert into newtable select data from oldtable where proc_date >= x and proc_date < y;
>
> INSERT 0 78551642
>
> select count(*) from newtable where proc_date >= x and proc_date < y;
> count
> -----------
> 4373518938
It looks to me like the status report is 32 bits and overflowed.
4,373,518,938 - 2^32 = 78,551,642
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ondrej Chaloupka | 2013-07-22 16:33:57 | Re: Different transaction log for database/schema |
| Previous Message | Natalie Wenz | 2013-07-22 16:12:34 | Re: Insert result does not match record count |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2013-07-22 16:43:41 | Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) |
| Previous Message | Greg Stark | 2013-07-22 16:19:35 | Re: Review: UNNEST (and other functions) WITH ORDINALITY |