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
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