Re: [HACKERS] psql

From: Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, <pgsql-general(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] psql
Date: 2003-06-20 17:32:52
Message-ID: Pine.SOL.4.33.0306201328310.4641-100000@innovate
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-general pgsql-hackers pgsql-patches

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 <ogeer(at)cs(dot)queensu(dot)ca> 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
>

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Sailesh Krishnamurthy 2003-06-20 21:23:08 Re: [HACKERS] psql
Previous Message Tom Lane 2003-06-20 17:01:14 Re: [HACKERS] psql

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-06-20 17:49:16 Re: dropping sequences
Previous Message Csaba Nagy 2003-06-20 17:21:30 Re: Incremental backups, and backup history

Browse pgsql-hackers by date

  From Date Subject
Next Message Jason Earl 2003-06-20 17:44:33 Re: Two weeks to feature freeze
Previous Message Tom Lane 2003-06-20 17:01:14 Re: [HACKERS] psql

Browse pgsql-patches by date

  From Date Subject
Next Message Sean Chittenden 2003-06-20 18:03:26 Re: Patch to be verbose about being unable to read ~/.pgpasss...
Previous Message Tom Lane 2003-06-20 17:01:14 Re: [HACKERS] psql