Hi Raj,
I have long time without working on pgsql performance, but you can try
materialized views or if you are already using its try apply some
performance tips...
This are some link i found in a fast search, but if you solution is going
by this way this can be a kickstart to solve your problem.
Hi Kenia,
Take a look of this link
https://wiki.postgresql.org/wiki/Monitoring#pg_activity
I think you are looking for something line pg_activity
But in that official pgsql documentation you'll find all you need to
monitor queries and pgsql cluster behavior
On Wed, Mar 6, 2019, 7:45 PM Kenia V
Hi,
If your problem is the sort, try creating an index on the Field that you
consider thst could be needed (you can star with smtoc that is the one you
are grouping and sorting)
Another thing that i noticed is your work_mem, I thing is too high for a
global config (if you think 2gb can hel for t
