Re: [GENERAL] shared memory - progress

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> OK,
> I can assign and manipulate shared memory in BSD/OS3.0 notes to follow.
> Now the problem is that as I vary the number of shared buffers and amount of
> shared memory I vary between two kinds of errors. If shared mem is too low
> that generates an error - 'out of buffers', if too high, I get palloc
> errors - memory exhausted.

Too low means you are asking for more shared memory than was configured
for your kernel. palloc errors are because there is not enough memory
left for your query to complete.

Most palloc errors are caused by some user error, or too many OR's in a
query, which will be fixed in the next release.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026