Re: BUG #17336: logtape sort performance and overflow - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17336: logtape sort performance and overflow
Date
Msg-id 262745.1639499287@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17336: logtape sort performance and overflow  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> In logtape.c,  

> * Each  `swap_nodes`  will execute assignment statement three times, while
> we only need execute once like in tuplesort.c

Yeah, that could be improved.  I see similar coding in binaryheap.c, too.

> * right_offset(unsigned i) parameter i seemed should be `unsigned long`

Ugh, that's surely wrong.  I don't know that anyone could get to >4G entries
in this heap, but it's still wrong.

Thanks for the report!

> Here's a patch

FYI, patches tend not to survive being passed through email unless
you add 'em as attachments.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: When Update balloons memory
Next
From: Dmitry Dolgov
Date:
Subject: Re: BUG #17326: Postgres crashed when pg_reload_conf() with ssl certificate parameters