| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Jakub Glapa <jakub(dot)glapa(at)gmail(dot)com> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, Fabio Isabettini <fisabettini(at)voipfuture(dot)com>, Arne Roland <A(dot)Roland(at)index(dot)de>, Sand Stone <sand(dot)m(dot)stone(at)gmail(dot)com>, Rick Otten <rottenwindfish(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: dsa_allocate() faliure |
| Date: | 2019-02-08 02:29:27 |
| Message-ID: | CAEepm=2LOk6WgOcS31n0xJ9akgKP7E0gbYmbqz27D8vP6s1Rrw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Fri, Feb 8, 2019 at 4:49 AM Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> I don't have the answer yet but I have some progress: I finally
> reproduced the "could not find %d free pages" error by running lots of
> concurrent parallel queries. Will investigate.
Sometimes FreeManagerPutInternal() returns a
number-of-contiguous-pages-created-by-this-insertion that is too large
by one. If this happens to be a new max-number-of-contiguous-pages,
it causes trouble some arbitrary time later because the max is wrong
and this FPM cannot satisfy a request that large, and it may not be
recomputed for some time because the incorrect value prevents
recomputation. Not sure yet if this is due to the lazy computation
logic or a plain old fence-post error in the btree consolidation code
or something else.
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2019-02-08 02:39:36 | Re: speeding up planning with partitions |
| Previous Message | Tsunakawa, Takayuki | 2019-02-08 01:50:40 | RE: speeding up planning with partitions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | keith anderson | 2019-02-08 11:13:51 | Partitioning Optimizer Questions and Issues |
| Previous Message | Thomas Munro | 2019-02-07 17:49:05 | Re: dsa_allocate() faliure |