Re: Is there a good discussion of optimizations?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Guyren Howe <guyren(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Is there a good discussion of optimizations?
Date: 2020-12-24 03:50:42
Message-ID: 20201224035042.GA13195@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 23, 2020 at 05:55:57PM -0800, Guyren Howe wrote:
> I’d be interested in any comments anyone has about useful things to discuss
> here, and in particular I’m interested in an accessible discussion of the sorts
> of query optimizations Postgres can do for us.

I have a few talks on this:

https://momjian.us/main/presentations/performance.html#optimizer
https://momjian.us/main/presentations/internals.html#internal_pics

and this webpage:

http://www.interdb.jp/pg/pgsql03.html

Robert Haas has a number of them:

https://sites.google.com/site/robertmhaas/presentations

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim Gündüz 2020-12-24 10:41:58 Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
Previous Message Tom Lane 2020-12-24 03:22:21 Re: Problem with ssl and psql in Postgresql 13