I am using a hash view on a table of about 4K elements.
Today I examined the database with the dump utility
and noticed that the hash view sometimes has 4K elements and
other times it has 8K..
What determines the size of the hash table?
--
email:[EMAIL PROTECTED] office:(805)893-4276
Kristian G. Kvilekval wrote:
I am using a hash view on a table of about 4K elements.
Today I examined the database with the dump utility
and noticed that the hash view sometimes has 4K elements and
other times it has 8K..
What determines the size of the hash table?
It's a power of two, and it's
On Tue, 2003-09-16 at 12:59, Jean-Claude Wippler wrote:
Kristian G. Kvilekval wrote:
What determines the size of the hash table?
It's a power of two, and it's always larger than the number of data
rows. I've written a bit more about hashed and blocked views on this
new page:
Kristian G. Kvilekval wrote:
Hmm... that's exactly what prompted the question. I have a
database with 4030 entries, but one machine it generates
a hash with 4096 and the other with 8192.. Is it checking
whether the database fits in memory?
Just infinitely curious:
Machine 1:
On Tue, 2003-09-16 at 13:24, Jean-Claude Wippler wrote:
Kristian G. Kvilekval wrote:
No, fits in memory is not considered.
What does matter is the order or adds/deletes. Space is reclaimed and
re-used, when fill drops too low - there is hysteresis, i.e. the same
number of rows can