*** Dejan has joined #ingres | 00:52 | |
Dejan | hello :) | 00:52 |
---|---|---|
*** PaulM05 has joined #ingres | 01:12 | |
PaulM05 | morning all | 01:12 |
*** stliu has joined #ingres | 02:22 | |
Dejan | hey Paul | 04:09 |
Dejan | :) | 04:09 |
PaulM05 | hi | 04:09 |
*** PaulM05 is now known as PaulM05_lunch | 04:54 | |
*** stliu has quit IRC | 04:55 | |
*** PaulM05_lunch is now known as PaulM05 | 05:37 | |
Dejan | wb | 05:43 |
Dejan | :) | 05:43 |
Dejan | PaulM05, is there any document about how the data are stored for a particular storage type? | 05:43 |
Dejan | lets say HASH | 05:44 |
PaulM05 | the internal structure? | 05:45 |
Dejan | that too, but i am just wondering how data are stored/retrieved | 05:45 |
Dejan | say we use 8k pages | 05:46 |
Dejan | do we assume the actual file is 8x * X where X = number of total pages, etc | 05:47 |
Dejan | what is the hash algorithm used in the case of HASH tables, etc | 05:47 |
PaulM05 | you'd need to look in the code for the algorithm, but it's the same one the HASH() function uses | 05:47 |
PaulM05 | I know that you can't necessarily say it's 8X because it depends on overflow and how many keys hit the same page | 05:48 |
Dejan | s/8x/8k/ | 05:49 |
Dejan | and X includes overflow pages | 05:49 |
PaulM05 | OK so in that case you have a few extra pages for space management so ~8k*X would be right - unless you have defined a large extend value - that's the amount it increases the file by when it needs to add new pages | 05:51 |
PaulM05 | have you used "MODIFY ... TO TABLE_DEBUG" before? | 05:52 |
Dejan | yep :) | 06:01 |
Dejan | i just love that feature of Ingres | 06:01 |
Vroomfon1le | what's that do? | 06:02 |
PaulM05 | it shows you the layout of the data file in page types | 06:05 |
*** Alex| has joined #ingres | 09:02 | |
*** ChanServ sets mode: +o Alex| | 09:02 | |
*** PaulM05 has quit IRC | 09:30 | |
*** Alex| has quit IRC | 12:05 | |
*** rczak has quit IRC | 12:35 | |
*** rczak has joined #ingres | 12:41 | |
*** DerMeister has joined #ingres | 13:38 | |
*** Mud has quit IRC | 13:50 | |
*** rczak has quit IRC | 13:55 | |
*** DerMeister has quit IRC | 14:10 | |
*** stliu has joined #ingres | 20:16 | |
*** cytrinox_ has joined #ingres | 21:20 | |
*** cytrinox has quit IRC | 21:23 | |
*** cytrinox_ is now known as cytrinox | 21:23 | |
*** Alex| has joined #ingres | 22:37 | |
*** ChanServ sets mode: +o Alex| | 22:37 | |
*** Alex| has quit IRC | 23:09 | |
*** Alex| has joined #ingres | 23:33 | |
*** ChanServ sets mode: +o Alex| | 23:33 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!