Re: [GENERAL] [HACKERS] psql
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
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
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