pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutovacuum and Insert wait
3+ messages / 2 participants
[nested] [flat]
* Autovacuum and Insert wait
@ 2023-10-25 10:19 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rajesh Kumar @ 2023-10-25 10:19 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi all,
Can autovacuum cause insert wait?
I could see in log that there are lot of insert waiting for a table ...At
the same time autovacuum is running for table.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Autovacuum and Insert wait
@ 2023-10-25 11:15 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Alvaro Herrera @ 2023-10-25 11:15 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On 2023-Oct-25, Rajesh Kumar wrote:
> Can autovacuum cause insert wait?
Yes, in unlucky situations.
> I could see in log that there are lot of insert waiting for a table ...At
> the same time autovacuum is running for table.
Did you examine pg_locks and pg_stat_activity in detail to see what
exactly was going on? It's easy to jump to wrong conclusions.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Autovacuum and Insert wait
@ 2023-10-25 11:36 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 3+ messages in thread
From: Rajesh Kumar @ 2023-10-25 11:36 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
It was the time I was sleeping .
On Wed, 25 Oct 2023, 16:45 Alvaro Herrera, <alvherre@alvh.no-ip.org> wrote:
> On 2023-Oct-25, Rajesh Kumar wrote:
>
> > Can autovacuum cause insert wait?
>
> Yes, in unlucky situations.
>
> > I could see in log that there are lot of insert waiting for a table ...At
> > the same time autovacuum is running for table.
>
> Did you examine pg_locks and pg_stat_activity in detail to see what
> exactly was going on? It's easy to jump to wrong conclusions.
>
> --
> Álvaro Herrera Breisgau, Deutschland —
> https://www.EnterpriseDB.com/
> "Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-25 11:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-25 10:19 Autovacuum and Insert wait Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-10-25 11:15 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-10-25 11:36 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox