Postgres Pro
Downloads
Home   >   mailing lists

Thread: please apply patch for GiST (7.1.1, current cvs)

please apply patch for GiST (7.1.1, current cvs)

From
Oleg Bartunov
Date:
Hi,

we found a problem in GiST with massive insert/update operations
with many NULLs ( inserting of NULL into indexed field cause
ERROR: MemoryContextAlloc: invalid request size)
As a workaround 'vacuum analyze' could be used.

This patch resolves the problem, please upply to 7.1.1 sources and
current cvs tree.
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: please apply patch for GiST (7.1.1, current cvs)

From
Bruce Momjian
Date:
Applied to 7.1.1 and 7.2.  Thanks.

> Hi,
> 
> we found a problem in GiST with massive insert/update operations
> with many NULLs ( inserting of NULL into indexed field cause
> ERROR: MemoryContextAlloc: invalid request size)
> As a workaround 'vacuum analyze' could be used.
> 
> This patch resolves the problem, please upply to 7.1.1 sources and
> current cvs tree.
> 
>     Regards,
>         Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

Content-Description: 

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

Re: please apply patch for GiST (7.1.1, current cvs)

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Applied to 7.1.1 and 7.2.  Thanks.

You seem to have missed the REL7_1_STABLE branch ...
        regards, tom lane

Re: please apply patch for GiST (7.1.1, current cvs)

From
Bruce Momjian
Date:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Applied to 7.1.1 and 7.2.  Thanks.
> 
> You seem to have missed the REL7_1_STABLE branch ...

Got it now.  Not sure how I missed the apply the first pass.  Thanks.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026