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 configuration.
The "emp" table is 500 GB? You're doing something wrong, The "emp" table
should have 14 rows and the "dept" table should have 4 rows The "bonus"
and "salgrade" tables should also be very small. The guy named Bruce
Scott could probably help you with that schema. Other than that, do you
have a SQL causing all this ruckus and a detailed explain plan ("explain
(analyze,costs,buffers)") for the SQL using most of the time? You can
analyze the log file with PgBadger to get the queries consuming the most
time.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
