Re: reducing statistics write overhead
От | Joshua Drake |
---|---|
Тема | Re: reducing statistics write overhead |
Дата | |
Msg-id | 20080905122708.462a0f44@jd-laptop обсуждение исходный текст |
Ответ на | Re: reducing statistics write overhead (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Fri, 05 Sep 2008 15:23:18 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote: > Martin Pihlak <martin.pihlak@gmail.com> writes: > > So, as a simple optimization I am proposing that the file should be > > only written when some backend requests statistics. This would > > significantly reduce the undesired write traffic at the cost of > > slightly slower stats access. > > How necessary is this given the recent fixes to allow the stats file > to be kept on a ramdisk? From an usability and integration perspective this patch is a nice touch. On demand is a nice feature when used correctly. Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-hackers по дате отправления: