Log message #3880167

# At Username Text
# May 25th 2016, 12:46 phpnut hmic I never noticed that
# May 25th 2016, 12:29 stopMe welcom to the Amsterdam :D
# May 25th 2016, 12:23 hmic wow, this is hillarious: i've just looked at the amsterdam city map the hotel has... it has 2 distinct tourist information signs: "tourist information" (red quare with an embedded i) and "gay tourist information" (rose triangle, upside down with an embedded i)
# May 25th 2016, 12:19 stopMe I can´t figure out how to "adapt" dates with this PR
# May 25th 2016, 12:18 ionas so awesome of a RDMBS
# May 25th 2016, 12:18 ionas working after only doing CREATE EXTENSION ltree; in postgres
# May 25th 2016, 12:18 ionas SELECT path FROM test WHERE path <@ 'Top.Science.Astronomy'; looks quite good
# May 25th 2016, 12:18 ionas stopMe: yes I am
# May 25th 2016, 12:17 stopMe ionas: are you there?
# May 25th 2016, 12:15 ionas hmic: understood - so people weak up and make hmic leave his laptop for food
# May 25th 2016, 12:15 ionas hmic must evolve around indexes
# May 25th 2016, 12:14 hmic anybody wants to play some hardware projects during cakefest? - i've got some nice stuff with me ;-)
# May 25th 2016, 12:13 hmic the question about lunch options was for the group, as i suspect ppl already be nearby
# May 25th 2016, 12:12 hmic thats what i said: go with the tree behaivor, its tested and working and does not eat your data ;-) i can tell you the quick hint on insert perfomrance later...
# May 25th 2016, 12:12 ionas Iâ??d try to look for a falafel place personally ;P
# May 25th 2016, 12:11 ionas sadly not I havenâ??t been to amsterdam for years
# May 25th 2016, 12:11 hmic any recommendations? local fast food in the area? - walking distance
# May 25th 2016, 12:11 ionas then stop being ;)
# May 25th 2016, 12:11 ionas I try biting my nails once and then probably will try to do 100% vanilla treebehavior
# May 25th 2016, 12:11 hmic still in the hotel at my notebook...
# May 25th 2016, 12:11 ionas enjoy your lunch
# May 25th 2016, 12:11 ionas hehe
# May 25th 2016, 12:09 hmic exactly like that
# May 25th 2016, 12:09 hmic composite keys are a thing on its own
# May 25th 2016, 12:09 hmic you dont need composite keys for storing multiple trees in a table
# May 25th 2016, 12:09 ionas I should have just created one root node per â??foreign keyâ?
# May 25th 2016, 12:09 ionas well basically composite primary key and storing multiple trees in one table
# May 25th 2016, 12:09 hmic you might have had, if not/misunderstandings happened or you screwed your data beause of manual interactions, sure
# May 25th 2016, 12:08 hmic tell about them
# May 25th 2016, 12:08 ionas I had bad xp with nested sets - you did not?
# May 25th 2016, 12:08 ionas hehe
# May 25th 2016, 12:08 ionas (stroke reading)
# May 25th 2016, 12:08 hmic i can help you on insert performance on large trees, if you need to
# May 25th 2016, 12:08 ionas hmic huh when I move parts of the table only those parts are affected in terms of reading and writing
# May 25th 2016, 12:07 hmic if you have a show stopper with it, lets talk about it!
# May 25th 2016, 12:07 hmic my 5ct on the topic: if you can go with a nested set and use tree behavior, by all menas do so!
# May 25th 2016, 12:07 hmic ionas, your materialized path is nothing but a written down nodelist, that is a nested set still!
# May 25th 2016, 12:06 ionas I ll take a harder look at https://www.postgresql.org/docs/current/static/ltree.html hmic and in case it takes too long just opt for build in treebehavior
# May 25th 2016, 12:05 lampsBR bernat1: It works! Thanks dude
# May 25th 2016, 12:04 jippi ionas: sorry, you are welcome to come to Denmark and visit :p
# May 25th 2016, 12:04 ionas hmic: its implemeted fast because tree behavior ships OOB