Home Postgresql tuning - effective_cache_size
Reply: 0

Postgresql tuning - effective_cache_size

JSStuball
1#
JSStuball Published in 2018-01-12 20:50:22Z

In the postgresql.conf file the effective_cache_size option is commented out when shipped, but the value coincides with my RAM. Am I right in assuming that it defaults to the same value as my RAM? Should I uncomment it to guarantee it is using all my RAM?

Edit: the output of

explain select * from table1 buffers;

is as follows:

 Seq Scan on table1 buffers  (cost=0.00..1792216.09 rows=91771209 width=48)

(1 row)

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.300047 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO