From: | Vladimír Houba ml(dot) <v(dot)houba(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: feature request ctid cast / sql exception |
Date: | 2021-04-18 06:50:37 |
Message-ID: | CAP=jTS79cq265sF4RM+T98a_bxg80rxVzm=jQrhm0Y46oxDHrA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is a specific use case, I have a big table without a pk. Updates with
ctid are blazing fast even without an index. I dont need it.
The argument behind this is that users excpect this functionality, its not
just me. Search stackoverflow. They end up using various suboptimal
solutions as I described earlier. This is a very very simple functionality
so please consider it. Im also writing an opensource lib that would make
use of this. My users will be thankfull to you.
On Sat, Apr 17, 2021, 23:05 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Sat, Apr 17, 2021 at 12:58 PM Vladimír Houba ml. <v(dot)houba(at)gmail(dot)com>
> wrote:
>
>> I use ctid as a row identifier within a transaction in a Java application.
>>
>
> This doesn't present a very compelling argument since an actual user
> declared primary key is what is expected to be used as a row identifier.
> And as those are typically bigint if you follow this norm you get exactly
> what you say you need.
>
> David J.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2021-04-18 11:23:33 | Re: Bogus collation version recording in recordMultipleDependencies |
Previous Message | Pavel Stehule | 2021-04-18 04:21:56 | Re: proposal - log_full_scan |