Re: caching indexes and pages?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I tried work_mem and maintenance_work_mem but it does not seem to make much
> difference yet. Admittedly I had set it to 100M and 80M, so after reading a
> little bit more I have found that I could easily set it to several GBs. But
> I am not sure those are the correct config parameters to use for this. I
> havent found any others that are relevant so far.

You probably want to increase shared_buffers by quite a large amount
and maybe make work_mem not quite so big.

If you have 2GB of memory you might set shared_buffers to 1GB,
work_mem 16MB, maintenance_work_mem 64MB?

...Robert

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux