Relation hash table

From: Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Relation hash table
Date: 2003-05-27 15:41:50
Message-ID: Pine.SOL.4.33.0305271136440.21040-100000@innovate
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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 table to do this similar to the buf_table.c file. Right now i
don't know how many relations there are in total. I have just initialized
it to 100. The key is relation and the data is the cluster information.
Can anyone see any problems in using this approach.
Feed back will be greatly appreciated.

PS i am aware that because of OS caching this may not cause any
improvements.

thanks
nailah

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-05-27 15:47:19 Re: speed w/ OFFSET/LIMIT
Previous Message Stephan Szabo 2003-05-27 15:41:17 Re: newbie sql question...

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-05-27 16:15:27 Re: [BUGS] Bug #928: server_min_messages (log_min_messages
Previous Message scott.marlowe 2003-05-27 15:05:07 Re: Postgresql on SUN Server