From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@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