From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Amit Kapila > > shared_buffers tps > > 256MB 990 > > 512MB 813 > > 1GB 1189 > > 2GB 2258 > > 4GB 5003 > > 8GB 5062 > > > > "512MB is the largest effective size" seems to be a superstition, although > I don't know the reason for the drop at 512MB. > > > > It is difficult to say why the performance drops at 512MB, it could be > run-to-run variation. How long have you run each test?
5 minutes (-T 300). I avoided 20-30 minutes runs for fear of wearing out and destroying my disk... Regards Takayuki Tsunakawa -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
