[HACKERS] Connecting to Postgres

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

[HACKERS] pg_stat

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

[HACKERS] Semaphores

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

[HACKERS] Code insertion

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

[HACKERS] File Cache

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

Re: [HACKERS] Postgres hash tables

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

[HACKERS] Checkpoints

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

[HACKERS] SHM_QUEUE

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

Re: [GENERAL] [HACKERS] psql

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

Re: [HACKERS] psql

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

[HACKERS] psql

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

[HACKERS] Hash Tables

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.

[HACKERS] Relation hash table

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