Hi Justin,
I executed the same query first time it's takes 6+ sec, but if I run again
same query that is taking 34 mill seconds, it's seems shared buffer reads
are taking, but the second time shared buffer reads are not showing us, so
Please suggest me ig I need to change any parameters to tune
On 3/29/22 14:04, 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.
Please suggest to us do we need to change and config parameters at
system level or Postgres
On Wed, Mar 30, 2022 at 10:17:38AM +0530, Rambabu g wrote:
> Hi Justin,
>
> Only one query is causing the issue, sharing the def of indexes. Please
> have a look.
>
> > > There are three indexes defined on the table, each one is around 20 to
> > > 25GB
>
> tp| character varying(2000) |
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 ?
> > > How large are they ?
> >
> >
On Wed, Mar 30, 2022 at 12:52:05AM +0530, Rambabu g wrote:
> > What indexes are defined on this table ?
> > How large are they ?
>
> There are three indexes defined on the table, each one is around 20 to 25GB
> and the indexes is create on
Did you mean to say something else after "on" ?
Show the
Hi Justin,
Thanks for the quick response and your help, Please go through the inputs
and let me know if need to change anything at OS level parameters tune and
DB parameters.
On Tue, 29 Mar 2022 at 23:54, Justin Pryzby wrote:
> Hi,
>
> Thanks for providing all this info.
>
> On Tue, Mar 29,
Hi,
Thanks for providing all this info.
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.
What indexes are defined
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();