Hi All,
We have an issue with high load and IO Wait's but less cpu on postgres
Database, The emp Table size is around 500GB, and the connections are very
less.
Please suggest to us do we need to change and config parameters at system
level or Postgres configuration.
postgres=# select version();
On Tue, Mar 29, 2022 at 11:34:18PM +0530, Rambabu g wrote:
> > Hi All,
> >
> > We have an issue with high load and IO Wait's but less cpu on postgres
> > Database, The emp Table size is around 500GB, and the connections are
> very
> > less.
>
> Wh
Hi Justin,
Only one query is causing the issue, sharing the def of indexes. Please
have a look.
On Wed, 30 Mar 2022 at 01:09, Justin Pryzby wrote:
> On Wed, Mar 30, 2022 at 12:52:05AM +0530, Rambabu g wrote:
> > > What indexes are defined on this table ?
> > &g
x27;::text)
Buffers: shared hit=46 read=718
Planning Time: 0.136 ms
Execution Time: 430.617 ms
(5 rows)
Regards,
Rambabu.
On Thu, 31 Mar 2022 at 12:19, Justin Pryzby wrote:
> On Wed, Mar 30, 2022 at 10:17:38AM +0530, Rambabu g wrote:
> > Hi Justin,
> >
> &
