Hi Shaheed,
Maybe these considerations could help you or give any hint to the problem ?
Check if wal_receiver_timeout being set to 0 could potentially cause
issues, like not detecting network issues quickly enough. Consider
re-evaluating this setting if you see connection issues.
If you notice
Hi, community,
The START_REPLICATION command accepts a lsn parameter, but according to the
document that replication "starts at either WAL location XXX/XXX or the
slot's confirmed_flush_lsn (see Section 54.19), whichever is greater." I
wonder if there is a way to go back, like a command to set
con
On Sun, Sep 1, 2024 at 5:44 PM Pavel Luzanov wrote:
> I see a perfectly working TID-store optimization.
> With reduced maintenance_work_mem it used only one 'vacuuming indexes'
> phase instead of 21 in v16.
> But I also expected to see a reduction in the number of WAL records
> and the total size
Hello,
While playing with optimizations to vacuum in v17 I can't understand
how to measure this one:
"Allow vacuum to more efficiently remove and freeze tuples".
My test script and results:
CREATE TABLE t(id integer) WITH (autovacuum_enabled = off);
INSERT INTO t SELECT gen.id FROM generate_ser
On 8/31/24 11:02, Peter J. Holzer wrote:
On 2024-08-31 10:35:01 -0700, Adrian Klaver wrote:
On 8/31/24 09:54, Peter J. Holzer wrote:
'Tis the season again.
Ubuntu 24.04.1 has just been released, so many Ubuntu LTS users will now
be prompted to upgrade from 22.04 to 24.04.
Which I ignore.
Since nobody more knowledgeable has replied...
I'm very interested in this area and still surprised that there is no
official/convenient/standard way to approach this (see
https://www.postgresql.org/message-id/CAHAc2jdAHvp7tFZBP37awcth%3DT3h5WXCN9KjZOvuTNJaAAC_hg%40mail.gmail.com
).
Based partly
On 8/31/24 19:32, Justin Clift wrote:
On 2024-09-01 02:54, Peter J. Holzer wrote:
'Tis the season again.
As usual, a newer Ubuntu version comes with a newer Postgres version (16
instead of 14). Also as usual, I got a message during the upgrade that
Postgres 14 is obsolete,. but the binaries h
On Sun, 1 Sept 2024 at 11:38, veem v wrote:
>
> On Sun, 1 Sept 2024 at 10:03, veem v wrote:
>
>>
>> On Sun, 1 Sept 2024 at 09:13, David G. Johnston <
>> david.g.johns...@gmail.com> wrote:
>>
>>> On Saturday, August 31, 2024, veem v wrote:
>>>
iii)And then alter the datatype of th
