We came across an error while using the hash_search function to find a
database entry in the pg_statdbhash hash table. Just wondering if there
are any recorded errors using this function when doing the initdb. It
seems to work fine while using sql statements but internally something is
going wrong.
What i am trying to do is to maintain a linked list of all the relations
in a database. When i create a db then i want it to insert into the linked
list the relation ids. As it stands now, i can create a db fine and i see
the relation id's in the linked list. BUT, as soon as i psql into the db
then
into the BP cluster
linked list fine and every time i call psql, it automatically deletes.
hope i gave u a better explanation
On Thu, 19 Jun 2003, Bruno Wolff III wrote:
> On Thu, Jun 19, 2003 at 17:07:43 -0400,
> Nailah Ogeer <[EMAIL PROTECTED]> wrote:
>
> Please don't
his 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 wh
just have a quick question. What i need to do is to create a shared memory
structure (which i can do) and maintain in it a linked list which should
be in shared memory too. I found the shmemqueue in postgres, but am having
some problems using it. I just need to have the linked list store
relation
Hello,
I have written code to support multiple buffer pools in postgres 7.3.2.
Now i am looking at changing the sizes of these buffer pools, but first i
need to write all pages to disk.
I also need to incorporate this code into the backend instead of it being
a sql statement as it is now. I noticed
the only way you can do this is to change your kernel parameters or use 32
connections and 64 buffers
On Wed, 23 Jul 2003, Errol Neal wrote:
> Hi All,
>
> I am using Postgresql 7.3.2 on Solaris 5.9 compiled with gcc and solaris
> ld. Right now, our max number of connections and buffers are set t
Hi all,
Just wanted to know how postgres handles semaphores. Was hoping that i can
can use the locks defined in lwlock.h and lwlock.c . If i create a new
lock and then use LockAcquire and
LockRelease when I want a process to start and stop will this work?
Nailah
---(end
Just wondering how often the stats collector resets it self. Is this a
parameter i can change?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
