[et_pb_section fb_built=”1″ specialty=”on” disabled_on=”on|on|on” admin_label=”Section” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”0px||0px||false|false” disabled=”on” ab_subject=”on” ab_subject_id=”1″ locked=”off” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”3_4″ specialty_columns=”3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][/et_pb_column][/et_pb_section][et_pb_section fb_built=”1″ specialty=”on” _builder_version=”4.20.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”2_3″ specialty_columns=”2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_row_inner module_class=”top-row-res” _builder_version=”4.20.4″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”23px||19px|||” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”February 2, 2024″ use_icon=”on” font_icon=”||fa||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Date” _builder_version=”4.23.4″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][/et_pb_blurb][et_pb_blurb title=”Brussels, Belgium” use_icon=”on” font_icon=”||divi||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Location” _builder_version=”4.23.1″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” global_colors_info=”{}”][/et_pb_blurb][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner admin_label=”Row” _builder_version=”4.18.0″ _module_preset=”default” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.23.4″ _module_preset=”default” custom_padding=”|0px||||” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]
Yoann La Cancellera (Senior Support Engineer, Percona) will be presenting a talk Learning advanced data types, the reverse way at FOSDEM PGDay 2024 on February 2, 2024.
This repeatable demo will show how arrays with GIN indexes and LTREE structures can help optimize a concrete example from real public data
Usually, datatypes are introduced using textbook examples, starting with the datatype when there is not data yet. Here we will do the opposite: adapt those types to existing data to alleviate a limitation.
About the event.
FOSDEM PGDay 2024 is a one day conference that will be held ahead of the main FOSDEM event in Brussels, Belgium, on February 2nd, 2024. This will be a one-day PostgreSQL focused event with a single track of talks.
[/et_pb_text][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoiY3VzdG9tX21ldGFfZXZlbnRfbGluayIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIiwiZW5hYmxlX2h0bWwiOiJvZmYifX0=@” url_new_window=”on” button_text=”Go to event link” admin_label=”Event Link” _builder_version=”4.20.4″ _dynamic_attributes=”button_url” _module_preset=”default” custom_button=”on” button_text_size=”14px” button_text_color=”#FFFFFF” button_bg_color=”#00162B” button_border_width=”0px” button_icon=”||fa||900″ button_icon_placement=”left” button_on_hover=”off” custom_padding=”5px|15px|5px|35px|false|false” global_colors_info=”{}”][/et_pb_button][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_title title=”off” meta=”off” admin_label=”Event Thumbnail” _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][/et_pb_post_title][/et_pb_column][/et_pb_section]
