Performance tunning

2020-05-30 Thread sugnathi hai
Hi , Can you help to tune the below plan Limit (cost=0.87..336777.92 rows=100 width=57) (actual time=599302.173..599481.552 rows=100 loops=1) Buffers: shared hit=78496066 -> Nested Loop (cost=0.87..11005874.67 rows=3268 width=57) (actual time=599302.170..599481.506 rows=100 loops=1) Buffers: sh

Configuration

2020-06-01 Thread sugnathi hai
Hi , In PGtune I can able to get configuration changes based on RAM and Disk and No of Connection. but if we want to recommend RAM, DISK, and No of connection based on DB size. any calculation is there For Example, 1 TB Database how much RAM and DISK Space required for better performance the DB