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
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... |
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 |