Logo des Repositoriums
 
Textdokument

PgCuckoo – Injecting Physical Plans into PostgreSQL

Lade...
Vorschaubild

Volltext URI

Dokumententyp

Zusatzinformation

Datum

2019

Autor:innen

Zeitschriftentitel

ISSN der Zeitschrift

Bandtitel

Verlag

Gesellschaft für Informatik, Bonn

Zusammenfassung

Plan forcing is the most capable plan hinting that a database system can implement. It allows the specification of almost every aspect of an execution plan. The open source database system PostgreSQL does not implement any plan hints by default. We will show how an extension can be used to provide plan forcing for PostgreSQL. This extension allows to use the query executor directly and independently of SQL. We sketch some of the interesting use case scenarios for plan forcing in PostgreSQL.

Beschreibung

Hirn, Denis (2019): PgCuckoo – Injecting Physical Plans into PostgreSQL. BTW 2019 – Workshopband. DOI: 10.18420/btw2019-ws-24. Gesellschaft für Informatik, Bonn. PISSN: 1617-5468. ISBN: 978-3-88579-684-8. pp. 235-244. Studierendenprogramm. Rostock. 4.-8. März 2019

Zitierform

Tags