Postgres Pro
Downloads
Home   >   mailing lists

Re: Too many waits on extension of relation - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Too many waits on extension of relation
Date
Msg-id CAHOFxGqtKtd56iTNcUHm9ZxTVEy7S=GSAHfoKhyWNKcpNjy-4A@mail.gmail.com
Whole thread Raw
In response to Too many waits on extension of relation  (avinash varma <avinashvarma443@gmail.com>)
Responses Re: Too many waits on extension of relation  (Sushant Pawar <sushant.pawar@ashnik.com>)
Re: Too many waits on extension of relation  (avinash varma <avinashvarma443@gmail.com>)
List pgsql-performance
Tree view
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?

pgsql-performance by date:

Previous
From: avinash varma
Date:
Subject: Too many waits on extension of relation
Next
From: avinash varma
Date:
Subject: Re: Too many waits on extension of relation