Re: [PERFORM] performance problem on big tables

2017-08-19 Thread Mariel Cherkassky
This server is dedicated to be a postgresql production database, therefore postgresql is the only thing the runs on the server. The fs that I`m using is xfs. I`ll add two different disks - one for the wals and one for the temp tablespace. Regarding the disk, what size should they be considering tha

[PERFORM] Performance Issue -- "Materialize"

2017-08-19 Thread anand086
I am a Postgres Newbie and trying to learn :)We have a scenario wherein, one of the SQL with different input value for import_num showing different execution plan.As an example, with import_num = '4520440' the execution plan shows Nested Loop and is taking ~12secs. With import_num = '4520460' exec