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
Tue, 15 May 2001 12:19:29 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
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

Tue, 15 May 2001 10:14:43 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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

Tue, 15 May 2001 11:02:58 -0400
Tom Lane <tgl@sss.pgh.pa.us>
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

Tue, 15 May 2001 13:09:47 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: please apply patch for GiST (7.1.1, current cvs)