Re: Too many waits on extension of relation

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: avinash varma <avinashvarma443(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Too many waits on extension of relation
Date: 2020-10-05 16:44:10
Message-ID: CAHOFxGqtKtd56iTNcUHm9ZxTVEy7S=GSAHfoKhyWNKcpNjy-4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

What is relation 266775 of database 196511? Is
it cms_c207c1e2_0ce7_422c_aafb_77d43f61e563.cms_item or some system catalog
table?

When I search google for "ExclusiveLock on extension of relation" I find
one thread about shared_buffers being very high but not big enough to fit
the entire data in the cluster. How much ram, what is shared buffers and
what is the total size of the database(s) on that Postgres instance?

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message avinash varma 2020-10-05 17:06:12 Re: Too many waits on extension of relation
Previous Message avinash varma 2020-10-05 05:02:55 Too many waits on extension of relation