public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: MVCC and all that...
Date: Wed, 10 Sep 2025 20:11:15 -0400
Message-ID: <CANzqJaD2jy5tQ4XBUDE-NUrn1DjbACOovB9hdybBCQH6=+aDOg@mail.gmail.com> (raw)
In-Reply-To: <CALL-XeOVhXeGTxQ-m=a__YqKrhWROTdv6Ea-zfN2-rFtRQyfSg@mail.gmail.com>
References: <CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com>
<CAHyXU0yrwoEYia0mZhpjQLMdd-WXpWFM+Au1jXQpk3MtBvdogw@mail.gmail.com>
<CAMLfE0MWqALMJ99dpFniZ1xknCgHj4ETPWro+Ry9awPUG1OKMw@mail.gmail.com>
<CAHyXU0y2gZfH_ZomazQB7H0KkuyV3QofvuvZcSYXEhpotG=hMA@mail.gmail.com>
<CALL-XeM=0oH=2ECawmyCOv2umKF1nyqr97CuQXiPfO39uhCucQ@mail.gmail.com>
<aMHtafqqx6UmC5T9@ubby>
<CALL-XeOVhXeGTxQ-m=a__YqKrhWROTdv6Ea-zfN2-rFtRQyfSg@mail.gmail.com>
On Wed, Sep 10, 2025 at 6:20 PM Justin <[email protected]> wrote:
> On Wed, Sep 10, 2025 at 5:28 PM Nico Williams <[email protected]>
> wrote:
>
>> [snip]
> I would really like out-of-band hints. These would be hints not
>> specified in the SQL itself but to be sent separately and which address
>> table sources or joins by name, like this:
>>
>> psql> SELECT .. FROM x x1 JOIN y y1 ON .. JOIN y y2 ON .. WHERE ..;
>> ...> \hint y1 indexed by ..
>> ...> \hint y2 indexed by ..
>> ...> ;
>>
>
> I humbly disagree, the point of SQL being a 4th generation language is,
> I tell it what I want, not how to go get what I want.
>
And the point of high-level languages is to eliminate GOTO, and yet GOTO
still exists.
The real problem is requiring the application to carry the hints.
My old RDBMS let you CREATE HINT to which you (the DBA) would put a SELECT,
UPDATE or DELETE statement (similar to PREPARE), and what indices to use.
That way, the application doesn't carry them, and "you" can update them as
needed.
Rarely useful, but occasionally *VERY* useful.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (21+ 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: MVCC and all that...
In-Reply-To: <CANzqJaD2jy5tQ4XBUDE-NUrn1DjbACOovB9hdybBCQH6=+aDOg@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