On Sun, Oct 22, 2023 at 4:56 AM Vik Fearing wrote:
> On 10/22/23 09:50, sirisha chamarthi wrote:
> > Is there any specific reason hot_standby_feedback default is set to off?
>
>
> Yes. No one wants a rogue standby to ruin production.
>
Agreed. I believe that any reason
Hi Andres,
On Sun, Oct 22, 2023 at 12:08 PM Andres Freund wrote:
> Hi,
>
> On October 22, 2023 4:56:15 AM PDT, Vik Fearing
> wrote:
> >On 10/22/23 09:50, sirisha chamarthi wrote:
> >> Is there any specific reason hot_standby_feedback default is set to off?
> >
Hi Hackers,
Is there any specific reason hot_standby_feedback default is set to off? I
see some explanation in the thread [1] about recovery_min_apply_delay value
> 0 causing table bloat. However, recovery_min_apply_delay is set to 0 by
default. So, if a server admin wants to change this value, th
Hi
On Mon, Apr 17, 2023 at 9:38 PM Michael Paquier wrote:
> On Mon, Apr 17, 2023 at 07:57:58PM -0700, sirisha chamarthi wrote:
> > On Fri, Apr 14, 2023 at 1:01 AM Kyotaro Horiguchi <
> horikyota@gmail.com>
> > wrote:
> >> So, I personally think it should b
Hi,
On Fri, Apr 14, 2023 at 1:01 AM Kyotaro Horiguchi
wrote:
> At Thu, 13 Apr 2023 12:01:04 -0700, sirisha chamarthi <
> sirichamarth...@gmail.com> wrote in
> > The documentation [1] says max_wal_size and min_wal_size defaults are 1GB
> > and 80 MB respectively. Howev
Hi,
The documentation [1] says max_wal_size and min_wal_size defaults are 1GB
and 80 MB respectively. However, these are configured based on the
wal_segment_size and documentation is not clear about it. Attached a patch
to fix the documentation.
[1] https://www.postgresql.org/docs/devel/runtime-c
Hi,
pg_create_logical_replication_slot can take longer than usual on a standby
when there is no activity on the primary. We don't have enough information
in the pg_stat_activity or process title to debug why this is taking so
long. Attached a small patch to update the process title while waiting f
Hi Hackers,
vacuum is not able to clean up dead tuples when OldestXmin is not moving
(because of a long running transaction or when hot_standby_feedback is
behind). Even though OldestXmin is not moved from the last time it checked,
it keeps retrying every autovacuum_naptime and wastes CPU cycles a
On Thu, Dec 1, 2022 at 9:50 PM Bharath Rupireddy <
bharath.rupireddyforpostg...@gmail.com> wrote:
> On Wed, Nov 30, 2022 at 5:15 PM Bharath Rupireddy
> wrote:
> >
> > I don't have a strong opinion about changing column names. However, if
> > we were to change it, I prefer to use names that
> > Pg
On Tue, Nov 22, 2022 at 11:44 PM David Rowley wrote:
> On Wed, 23 Nov 2022 at 20:29, sirisha chamarthi
> wrote:
> > I ran your test1 exactly like your setup except the row count is 300
> (with 13275 blocks). Shared_buffers is 128MB and the hardware configuration
> detail
On Tue, Nov 22, 2022 at 1:58 PM David Rowley wrote:
> On Thu, 3 Nov 2022 at 06:25, Andres Freund wrote:
> > Attached is an experimental patch/hack for that. It ended up being more
> > beneficial to make the access ordering more optimal than prefetching the
> tuple
> > contents, but I'm not at al
On Mon, Nov 21, 2022 at 10:56 AM Alvaro Herrera
wrote:
> On 2022-Nov-21, sirisha chamarthi wrote:
>
> > I have a old .partial file in the data directory to reproduce this.
>
> I don't think the .partial file is in itself important. But I think
> this whole thing is
On Mon, Nov 21, 2022 at 10:40 AM sirisha chamarthi <
sirichamarth...@gmail.com> wrote:
>
>
> On Mon, Nov 21, 2022 at 10:11 AM Alvaro Herrera
> wrote:
>
>> On 2022-Nov-21, sirisha chamarthi wrote:
>>
>> > It appears to be. wal_sender is setting restart_
On Mon, Nov 21, 2022 at 10:11 AM Alvaro Herrera
wrote:
> On 2022-Nov-21, sirisha chamarthi wrote:
>
> > It appears to be. wal_sender is setting restart_lsn to a valid LSN even
> > when the slot is invalidated.
>
> > postgres@pgvm:~$ /usr/local/pgsql/bin/pg_receivewal -
On Mon, Nov 21, 2022 at 9:12 AM Alvaro Herrera
wrote:
> On 2022-Nov-21, sirisha chamarthi wrote:
>
> > On Mon, Nov 21, 2022 at 8:05 AM Alvaro Herrera
> > wrote:
>
> > > Thank you. I had pushed mine for CirrusCI to test, and it failed the
> > > assert
On Mon, Nov 21, 2022 at 8:05 AM Alvaro Herrera
wrote:
> On 2022-Nov-21, sirisha chamarthi wrote:
>
> > > > I am a fan of stricter, all-assumption-covering conditions. In case
> we
> > > > don't want to check restart_lsn, an Assert might be usefu
Thanks Alvaro, Ashutosh for your comments.
On Mon, Nov 21, 2022 at 6:20 AM Alvaro Herrera
wrote:
> On 2022-Nov-21, Ashutosh Bapat wrote:
>
> > Maybe. In that case pg_get_replication_slots() should be changed. We
> > should use the same criteria to decide whether a slot is invalidated
> > or no
Hi Hackers,
At present, calling pg_stat_reset* functions requires super user access
unless explicitly grant execute permission on those. In this thread, I am
proposing to grant execute on them to users with pg_monitor role
permissions. This comes handy to the monitoring users (part of pg_monitor
r
Amit, thanks for looking into this!
On Sun, Nov 20, 2022 at 11:38 PM Amit Kapila
wrote:
> On Mon, Nov 21, 2022 at 12:45 PM sirisha chamarthi
> wrote:
> >
> > Hi Hackers,
> >
> > The comments atop seem to indicate that it is only showing active
> replication s
Hi Hackers,
The comments atop seem to indicate that it is only showing active
replication slots. The comment is ambiguous as it also shows all the slots
including lost and inactive slots. Attached a small patch to fix it.
Thanks,
Sirisha
0001-Fix-atop-pg_get_replication_slots-function-to-reflec
Hi Hackers,
forking this thread from the discussion [1] as suggested by Amit.
Catalog_xmin is not advanced when a logical slot is invalidated (lost)
until the invalidated slot is dropped. This patch ignores invalidated slots
while computing the oldest xmin. Attached a small patch to address this
t;
Thanks! If there is a general agreement on this in this forum, I would like
to start working on this patch,
>
> At Tue, 8 Nov 2022 19:39:58 -0800, sirisha chamarthi <
> sirichamarth...@gmail.com> wrote in
> > > If it's a streaming replication slot, the standby wi
On Wed, Nov 9, 2022 at 2:37 AM Amit Kapila wrote:
> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> wrote:
> >
> Is the intent of setting restart_lsn to InvalidXLogRecPtr was to
> disallow reviving the slot?
> >
>
> I think the intent is to
On Mon, Nov 7, 2022 at 11:17 PM Bharath Rupireddy <
bharath.rupireddyforpostg...@gmail.com> wrote:
> On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
> wrote:
> >
> > On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila
> wrote:
> >>
> >> On Fri, Nov 4,
On Tue, Nov 8, 2022 at 1:36 AM Amit Kapila wrote:
> On Tue, Nov 8, 2022 at 12:08 PM sirisha chamarthi
> wrote:
> >
> > On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila
> wrote:
> >>
> >> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> >> wrote:
&
Hi Amit,
Thanks for your comments!
On Fri, Nov 4, 2022 at 11:02 PM Amit Kapila wrote:
> On Fri, Nov 4, 2022 at 1:40 PM sirisha chamarthi
> wrote:
> >
> > A replication slot can be lost when a subscriber is not able to catch up
> with the load on the primary and the WA
Hi,
A replication slot can be lost when a subscriber is not able to catch up
with the load on the primary and the WAL to catch up exceeds
max_slot_wal_keep_size. When this happens, target has to be reseeded
(pg_dump) from the scratch and this can take longer. I am investigating the
options to revi
On Wed, Oct 19, 2022 at 7:59 PM Kyotaro Horiguchi
wrote:
> At Wed, 19 Oct 2022 13:06:08 +0530, Bharath Rupireddy <
> bharath.rupireddyforpostg...@gmail.com> wrote in
> > On Wed, Oct 19, 2022 at 12:39 PM sirisha chamarthi
> > wrote:
> > >
> > > The curr
Hi Hackers,
The current code comment says that the replication stream on a slot with
the given targetLSN can't continue after a restart but even without a
restart the stream cannot continue. The slot is invalidated and the
walsender process is terminated by the checkpoint process. Attaching a
smal
Hi hackers.
I am unable to connect to my Postgres server (version 13 running) in Azure
Postgres from the PSQL client built on the latest master. However, I am
able to connect to the Postgres 15 server running locally on the machine. I
installed an earlier version of the PSQL client (v 12) and was
Hi,
I was going through pg_stat_recovery_prefetch documentation and saw an
issue with formatting. Attached a small patch to fix the issue. This is the
first time I am sending an email to hackers. Please educate me if I
miss something.
https://www.postgresql.org/docs/devel/monitoring-stats.html#PG
31 matches
Mail list logo
