On Wed, May 23, 2018 at 07:03:18AM -0700, pavan95 wrote:
> Please find the explain plan which got increased again vastly. Is this
> because of the increase in rows?
>
> Link : https://explain.depesz.com/s/Ifr <http://>
That's explain without "analyze", so not very useful.
There's handful of questions:
On Wed, May 23, 2018 at 08:43:22AM -0500, Justin Pryzby wrote:
> - postgres parameters: what are shared_buffers, work_mem, effective_cache_size ?
> + https://wiki.postgresql.org/wiki/Server_Configuration
> - are there other DBs/applications running on the server/VM ?
> - kernel tuning (readahead, VM parameters, write cache, scheduler, THP, etc)
> - server hardware (what OS? storage? RAM? filesystem?)
> - how does the storage perform outside of postgres?
> + something like this: /usr/sbin/bonnie++ -f -n0 -x4 -d /var/lib/pgsql
Justin