{"id":"https://openalex.org/W4407390570","doi":"https://doi.org/10.1145/3709659","title":"An Elephant Under the Microscope: Analyzing the Interaction of Optimizer Components in PostgreSQL","display_name":"An Elephant Under the Microscope: Analyzing the Interaction of Optimizer Components in PostgreSQL","publication_year":2025,"publication_date":"2025-02-10","ids":{"openalex":"https://openalex.org/W4407390570","doi":"https://doi.org/10.1145/3709659"},"language":"en","primary_location":{"id":"doi:10.1145/3709659","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3709659","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5027843498","display_name":"Rico Bergmann","orcid":"https://orcid.org/0009-0005-1514-7253"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Rico Bergmann","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034533320","display_name":"Claudio Hartmann","orcid":"https://orcid.org/0000-0002-5334-059X"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Claudio Hartmann","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057703543","display_name":"Dirk Habich","orcid":"https://orcid.org/0000-0002-8671-5466"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Dirk Habich","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5027843498"],"corresponding_institution_ids":["https://openalex.org/I78650965"],"apc_list":null,"apc_paid":null,"fwci":2.9775,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.89761289,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"3","issue":"1","first_page":"1","last_page":"28"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9945999979972839,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.48017898201942444},{"id":"https://openalex.org/keywords/computer-graphics","display_name":"Computer graphics (images)","score":0.39830633997917175},{"id":"https://openalex.org/keywords/biological-system","display_name":"Biological system","score":0.3361477851867676},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.23144742846488953}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.48017898201942444},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.39830633997917175},{"id":"https://openalex.org/C186060115","wikidata":"https://www.wikidata.org/wiki/Q30336093","display_name":"Biological system","level":1,"score":0.3361477851867676},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.23144742846488953}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3709659","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3709659","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":59,"referenced_works":["https://openalex.org/W1519039476","https://openalex.org/W2119885577","https://openalex.org/W2132823934","https://openalex.org/W2153180521","https://openalex.org/W2153329411","https://openalex.org/W2158679027","https://openalex.org/W2396309311","https://openalex.org/W2596218679","https://openalex.org/W2906910993","https://openalex.org/W2946026089","https://openalex.org/W2950833175","https://openalex.org/W2955798121","https://openalex.org/W2970148517","https://openalex.org/W2991530444","https://openalex.org/W3013555795","https://openalex.org/W3030994385","https://openalex.org/W3097225903","https://openalex.org/W3099273181","https://openalex.org/W3100077023","https://openalex.org/W3111141572","https://openalex.org/W3124277639","https://openalex.org/W3129744650","https://openalex.org/W3173622057","https://openalex.org/W3177390287","https://openalex.org/W3183953540","https://openalex.org/W3197977787","https://openalex.org/W3198024709","https://openalex.org/W3201461576","https://openalex.org/W4206830372","https://openalex.org/W4210689632","https://openalex.org/W4221142004","https://openalex.org/W4226086155","https://openalex.org/W4281754544","https://openalex.org/W4281771843","https://openalex.org/W4282041278","https://openalex.org/W4283371524","https://openalex.org/W4289706945","https://openalex.org/W4312625213","https://openalex.org/W4313138291","https://openalex.org/W4317641620","https://openalex.org/W4366492480","https://openalex.org/W4366502978","https://openalex.org/W4375928354","https://openalex.org/W4375956844","https://openalex.org/W4380433098","https://openalex.org/W4380433122","https://openalex.org/W4380433183","https://openalex.org/W4380433194","https://openalex.org/W4380433215","https://openalex.org/W4381621940","https://openalex.org/W4386128208","https://openalex.org/W4386128230","https://openalex.org/W4386148280","https://openalex.org/W4386251853","https://openalex.org/W4386768940","https://openalex.org/W4389609658","https://openalex.org/W4389609916","https://openalex.org/W4389628219","https://openalex.org/W4393180319"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Despite":[0],"an":[1,48,70,149],"ever-growing":[2],"corpus":[3],"of":[4,11,15,83,101,117,122,147],"novel":[5,192],"query":[6,16],"optimization":[7,95],"strategies,":[8],"the":[9,12,33,52,107,123,126,131,143],"interaction":[10],"core":[13,144],"components":[14,43],"optimizers":[17],"is":[18,75],"still":[19],"not":[20],"well":[21],"understood.":[22],"This":[23],"situation":[24],"can":[25,56],"be":[26,201],"problematic":[27],"for":[28,72],"two":[29,42],"main":[30],"reasons:":[31],"On":[32,51],"one":[34,73],"hand,":[35,54],"this":[36,55,112],"may":[37],"cause":[38],"surprising":[39],"results":[40,116],"when":[41,69,176],"influence":[44,169],"each":[45,170],"other":[46,53,108,171],"in":[47,61,125],"unexpected":[49],"way.":[50],"lead":[57],"to":[58,63,92],"wasted":[59],"effort":[60],"regard":[62],"both":[64],"engineering":[65],"and":[66,140,158,172,194],"research,":[67],"e.g.,":[68],"improvement":[71],"component":[74,96],"dwarfed":[76],"or":[77],"entirely":[78],"canceled":[79],"out":[80],"by":[81],"problems":[82],"another":[84],"component.":[85],"Therefore,":[86],"we":[87,114,163,190],"argue":[88],"that":[89],"making":[90],"improvements":[91],"a":[93,98,118],"single":[94],"requires":[97],"thorough":[99],"understanding":[100],"how":[102,165,173,198],"these":[103,166,199],"changes":[104],"might":[105],"affect":[106],"components.":[109],"To":[110],"achieve":[111],"understanding,":[113],"present":[115],"comprehensive":[119],"experimental":[120],"analysis":[121,141],"interplay":[124],"traditional":[127],"optimizer":[128],"architecture":[129],"using":[130],"widely-used":[132],"PostgreSQL":[133],"system":[134],"as":[135,182],"prime":[136],"representative.":[137],"Our":[138],"evaluation":[139],"revisit":[142],"building":[145,167],"blocks":[146,168],"such":[148,181],"optimizer,":[150],"i.e.":[151],"per-column":[152],"statistics,":[153],"cardinality":[154,184],"estimation,":[155],"cost":[156],"model,":[157],"plan":[159],"generation.":[160],"In":[161],"particular,":[162],"analyze":[164],"they":[174],"react":[175],"faced":[177],"with":[178],"faulty":[179],"input,":[180],"imprecise":[183],"estimates.":[185],"Based":[186],"on":[187,197],"our":[188],"results,":[189],"draw":[191],"conclusions":[193],"make":[195],"recommendations":[196],"should":[200],"taken":[202],"into":[203],"account.":[204]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}