Hello Jeff,
Thanks for the reply!
Yes, you are right, the database size has grown from 5 GB database to 100
GB database and may be there is problem in slowness in disk. However we
cannot replace the disk right now.
Sure. i will try to increase the shared_buffer value to 90% and see the
performan
On Sat, Sep 10, 2016 at 4:19 PM, Samir Magar wrote:
> Hello,
>
>
> My Application has normally 25 to 30 connections and it is doing lot of
> insert/update/delete operation.
> The database size is 100GB.
> iowait is at 40% to 45 % and CPU idle time is at 45% to 50%
> TOTAL RAM = 8 GB TOTAL CPU
Hello Venkata,
Thank you for the reply!
I forgot to specify the application name.It is ZABBIX tool using postgreSQL
database. All types of queries are running slow and i can see application
is writing continuously.
Yesterday , i updated effective_io_concurrency to 25 which earlier set as
default.
On Sat, Sep 10, 2016 at 3:49 AM, Samir Magar wrote:
> Hello,
>
>
> My Application has normally 25 to 30 connections and it is doing lot of
> insert/update/delete operation.
> The database size is 100GB.
> iowait is at 40% to 45 % and CPU idle time is at 45% to 50%
> TOTAL RAM = 8 GB TOTAL CPU
On Sat, Sep 10, 2016 at 8:49 PM, Samir Magar wrote:
> Hello,
>
>
> My Application has normally 25 to 30 connections and it is doing lot of
> insert/update/delete operation.
> The database size is 100GB.
> iowait is at 40% to 45 % and CPU idle time is at 45% to 50%
> TOTAL RAM = 8 GB TOTAL CPU
Hello,
My Application has normally 25 to 30 connections and it is doing lot of
insert/update/delete operation.
The database size is 100GB.
iowait is at 40% to 45 % and CPU idle time is at 45% to 50%
TOTAL RAM = 8 GB TOTAL CPU = 4
postgresql.conf parametre:
shared_buffers = 2GB
work_mem = 100
