Re: go for a script! / ex: PostgreSQL vs. MySQL

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: go for a script! / ex: PostgreSQL vs. MySQL
Дата
Msg-id pupth43wgd.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на go for a script! / ex: PostgreSQL vs. MySQL  ("Nick Barr" <nicky@chuckie.co.uk>)
Ответы Re: go for a script! / ex: PostgreSQL vs. MySQL
Список pgsql-performance
In article <1065837333.12875.1.camel@jester>,
Rod Taylor <rbt@rbt.ca> writes:

>> Would anyone object to a patch that exports the blocksize via a
>> readonly GUC?  Too many tunables are page dependant, which is
>> infuriating when copying configs from DB to DB.  I wish pgsql had some
>> notion of percentages for values that end with a '%'.

> Rather than showing the block size, how about we change the tunables to
> be physical sizes rather than block based?

>         effective_cache_size = 1.5GB
>         shared_buffers = 25MB

Amen!  Being forced to set config values in some obscure units rather
than bytes is an ugly braindamage which should be easy to fix.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: sql performance and cache
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [SQL] sql performance and cache