unsuscribe mailing list
От | ingrim |
---|---|
Тема | unsuscribe mailing list |
Дата | |
Msg-id | 002601c39197$ac832170$7d64a8c0@ingridma обсуждение исходный текст |
Ответ на | Re: go for a script! / ex: PostgreSQL vs. MySQL (Vivek Khera <khera@kcilink.com>) |
Список | pgsql-performance |
-----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Vivek Khera Sent: Viernes, 10 de Octubre de 2003 03:14 p.m. To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] go for a script! / ex: PostgreSQL vs. MySQL >>>>> "JB" == Josh Berkus <josh@agliodbs.com> writes: JB> Vivek, NB> shared_buffers = 1/16th of total memory NB> effective_cache_size = 80% of the supposed kernel cache. >> >> Please take into account the blocksize compiled into PG, too... JB> We can;t change the blocksize in a script that only does the .conf JB> file. Or are you suggesting something else? when you compute optimal shared buffers and effective cache size, these are in terms of blocksize. so if I have 16k block size, you can't compute based on default 8k blocksize. at worst, it would have to be a parameter you pass to the tuning script. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
В списке pgsql-performance по дате отправления: