Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Tom Lane
Nailah Ogeer [EMAIL PROTECTED] writes:
 So what is happening is that i enter the relation ids into the BP cluster
 linked list fine and every time i call psql, it automatically deletes.

Sounds to me like you are trying to keep stuff in backend-local memory
that needs to be in shared memory.

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Nailah Ogeer
Well here's the thing. Before i was trying to use ShmemInitStruct in
buf_init.c. The problem with this is that you can't shrink or grow shared
memory. That is why i switched over and just used malloc. So i seem to be
in a big dilemma, on one hand, if i use malloc, i can't keep this info i
need; and on the other if i use shmeminitstruct then i can't shrink or
grow the BP clusters.
But i will try to test your hypothesis to see if shared memory will take
care of this.

On Fri, 20 Jun 2003, Tom Lane wrote:

 Nailah Ogeer [EMAIL PROTECTED] writes:
  So what is happening is that i enter the relation ids into the BP cluster
  linked list fine and every time i call psql, it automatically deletes.

 Sounds to me like you are trying to keep stuff in backend-local memory
 that needs to be in shared memory.

   regards, tom lane

 ---(end of broadcast)---
 TIP 8: explain analyze is your friend



---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Sailesh Krishnamurthy
 Nailah == Nailah Ogeer [EMAIL PROTECTED] writes:

Nailah Well here's the thing. Before i was trying to use
Nailah ShmemInitStruct in buf_init.c. The problem with this is
Nailah that you can't shrink or grow shared memory. That is why i
Nailah switched over and just used malloc. So i seem to be in a

We've implemented a Shared Memory MemoryContext in TelegraphCQ. We
used the opensource libmm from the Apache project. Maybe you can try
using it - it's fairly easy to use. The current version in the web is
based off of 7.2 code, but I hope to refresh with a beta based on 7.3
code in the next few weeks.

http://telegraph.cs.berkeley.edu/telegraphcq

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings