CYBERTEC Logo

Tag: optimizer

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: optimizer. You can go back to all blog posts or take a look into our other categories & tags.

Tech preview: How PostgreSQL 12 handles prepared plans

by Hans-Jürgen Schönig | 06.2019
PostgreSQL 12 is just around the corner and therefore we already want to present some of the new features we […]

PostgreSQL v12 new feature: optimizer support for functions

by Laurenz Albe | 05.2019
  PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. […]

PostgreSQL performance: How the optimizer handles views

by Hans-Jürgen Schönig | 02.2018
“How does the PostgreSQL optimizer handle views?” or “Are views good or bad?” I assume that every database consultant and […]

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
A couple of weeks ago I have seen a horribly designed, 370 billion (with a “b”) row Oracle database monster […]

Exploding runtime: How nested loops can destroy speed

by Hans-Jürgen Schönig | 08.2016
Sometimes it happens that a query slows down dramatically for no obvious reason. In other cases queries go south in […]

Join pruning - Cool stuff in PostgreSQL

by Hans-Jürgen Schönig | 12.2015
UPDATED July 2023: The PostgreSQL optimizer is really a wonderful piece of software which is capable of doing great things. […]
1 2
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram