I am trying to divide the buffer pool into 5 parts and i call these
clusters (different from postgres db clusters). What i want to do is to
make a mapping from the relations to these clusters. One relation belongs
to one cluster and a cluster can obviously have more than one relations. I
use a hash
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
Sorry to bother you again but i am having a real hard time getting stats
from the relation. What i have is a shared memory linked list of
relfilenodes. I simply want to get the stats of all these relations and
add them up. I was using pgstat_fetch_stat_tabentry(relid) as an sql
statement and this w
Just wondering if you shut down postmaster and restart, if the contents of
the file cache are written out to disk or still in the file cache. In
other words, will the number of transactions per second change if you shut
down postmaster and restart compared to restarting the machine
thanks
nailah
Hi all,
Just wondering if someone could help me with this rather specific problem.
I am trying to figure out where i should insert some code that basically
resets stats after a certain number of transactions(or sql statements)
have been executed. Collects Stats after some more statements have been
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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTE
How do you connect to postgres if it is running on a different machine. I
am looking for a telnet command in place of postmaster -D data
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregi
13 matches
Mail list logo
