> On 29/07/2023 08:42 CEST Alex Shan <3341...@gmail.com> wrote:
>
> In my DB I have a large object over 4GB in size.
> I need to get its MD5 or SHA256 from within psql query, i.e. without
> exporting it to FS first.
>
> “SELECT md5(lo_get(loid));” doesnt work — “large object is too large”.
>
> Is
Logical replication from PG 15.3 to 15.2 has been running without problems
until a few days ago.
Now the subscriber shows repeated messages like:
```
2023-07-29 08:25:04.523 UTC [26] LOG: checkpoint complete: wrote 8692 buffers
(53.1%); 0 WAL file(s) added, 1 removed, 14 recycled;
> On 29 Jul 2023, at 10:59, Peter J. Holzer wrote:
>
> On 2023-07-26 15:46:16 +0800, gzh wrote:
>> SET enable_seqscan TO off;
> [...]
>>-> Parallel Bitmap Heap Scan on tbl_sha
>> (cost=92112.45..2663789.14 rows=800650 width=18) (actual
>> time=260.540..21442.169
On 2023-07-26 15:46:16 +0800, gzh wrote:
> SET enable_seqscan TO off;
[...]
> -> Parallel Bitmap Heap Scan on tbl_sha
> (cost=92112.45..2663789.14 rows=800650 width=18) (actual
> time=260.540..21442.169 rows=804500 loops=3)
> Recheck Cond: (ms_cd =
Hello,
In my DB I have a large object over 4GB in size.
I need to get its MD5 or SHA256 from within psql query, i.e. without
exporting it to FS first.
“SELECT md5(lo_get(loid));” doesnt work — “large object is too large”.
Is there any other way to do it?
Regards,
Al
