From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Amit Kapila
> Okay, not a problem. However, I am not sure the results in this thread
> are sufficient proof as for read-only tests, there is no noticeable win
> by increasing shared buffers and read-write tests seems to be quite short
> (60 seconds) to rely on it.
I think the reason why increasing shared_buffers didn't give better performance for read-only tests than you expect is
thatthe relation files are cached in the filesystem cache. The purpose of this verification is to know that the
effectiveupper limit is not 512MB (which is too small now), and I think the purpose is achieved. There may be another
threshold,say 32GB or 128GB, over which the performance degrades due to PostgreSQL implementation, but that's another
topicwhich also applies to other OSes.
How about 3 minutes for read-write tests? How long do you typically run?
Regards
Takayuki Tsunakawa