please apply patch for GiST (7.1.1, current cvs)

Started by Oleg Bartunovalmost 25 years ago4 messageshackers
Jump to latest
#1Oleg Bartunov
oleg@sai.msu.su

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

Attachments:

patch_gisttext/plain; charset=US-ASCII; name=patch_gistDownload+27-20
#2Bruce Momjian
bruce@momjian.us
In reply to: Oleg Bartunov (#1)
Re: please apply patch for GiST (7.1.1, current cvs)

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, Pennsylvania 19026
#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#2)
Re: please apply patch for GiST (7.1.1, current cvs)

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

#4Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#3)
Re: please apply patch for GiST (7.1.1, current cvs)

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, Pennsylvania 19026