public inbox for [email protected]
help / color / mirror / Atom feedFrom: John Naylor <[email protected]>
To: pgsql-hackers <[email protected]>
Subject: Re: cutting down the TODO list thread
Date: Wed, 19 May 2021 13:52:03 -0400
Message-ID: <CAFBsxsE6Wg_HFtAfk0C8FpiWEtypu6zZ7bscO2H9e-RQY+_u8g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFBsxsEd_-WJ78_Sv=iP+T3-bM5+b6ORONBQTZVb0RDETvmqDQ@mail.gmail.com>
<[email protected]>
<CAFBsxsGP+qiLnC2KkOEW2URvvwC0zeYjYcEBsbZoBkiL5JSCKg@mail.gmail.com>
<CAFBsxsFTD45K5S3oJQbDSvA-nuB6DiykCGMk7OfU7VijT9bJMw@mail.gmail.com>
<CAFBsxsF-uA=SvFNJGNin68KRfrCautEwEN0JL4EimGaUM0zcsg@mail.gmail.com>
<[email protected]>
<CAFBsxsEJs036Bc-gEho0Dw00Smbo3PnOdQf-ZOB5f5EUWEEUuQ@mail.gmail.com>
<CAFBsxsGQCwrdMu2ThR8xTvu4pG9kv7mbt542OhZ=YKnxqW92cw@mail.gmail.com>
<[email protected]>
<CAFBsxsGekd50U0SpxUfUaG7mWz1_q+pkNcFHv1Ct40PkBVY+Dg@mail.gmail.com>
<[email protected]>
Hi,
I let this drop off my radar a few months ago, but I'm going to try to get
back into the habit of looking at a few items a week. As before, let me
know in the next few days if anyone has thoughts or objections.
(Optimizer / Executor)
- Consider increasing the default values of from_collapse_limit,
join_collapse_limit, and/or geqo_threshold
http://archives.postgresql.org/message-id/[email protected]
This seems to have been rejected.
- Improve use of expression indexes for ORDER BY
http://archives.postgresql.org/pgsql-hackers/2009-08/msg01553.php
Skimming the thread, I'm not quite sure if index-only scans (not available
at the time) solves the problem, or is orthogonal to it?
- Modify the planner to better estimate caching effects
http://archives.postgresql.org/pgsql-performance/2010-11/msg00117.php
Huge discussion. This sounds like a research project, and maybe a risky one.
- Allow shared buffer cache contents to affect index cost computations
http://archives.postgresql.org/pgsql-hackers/2011-06/msg01140.php
Related to the above, but has a more specific approach in mind. The
discussion thread is not useful for getting one's head around how to think
about the problem, much less to decide if it's worth working on -- it's
mostly complaining about the review process. Independent of that, the idea
of inspecting the buffer cache seems impractical.
--
John Naylor
EDB: http://www.enterprisedb.com
view thread (42+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: cutting down the TODO list thread
In-Reply-To: <CAFBsxsE6Wg_HFtAfk0C8FpiWEtypu6zZ7bscO2H9e-RQY+_u8g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox