i'm curious if there is any way to hint postgresql which data should be more likely cached in memory. in my scenario the server would be handling mostly read traffic, whole data-set is much larger than available memory but some of the tables [ which are not necessarily most frequently accessed ] should be stored in memory, while other do not require high performance and can be accessed from the disk.
i know that memcached or similar can be reasonable workaround, but maybe it all can be done without that.
is this question better suited for stackoverflow?