random_page_cost etc. per tablespace?

Поиск
Список
Период
Сортировка
От Jens-Wolfhard Schicke
Тема random_page_cost etc. per tablespace?
Дата
Msg-id 47397B6A.6070008@gmx.de
обсуждение исходный текст
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

how hard would it be to give users the ability to
configure different random_page and seq_page costs per tablespace?

Obviously this does not match with random_page_cost being a GUC variable
but nonetheless I think it'd make a nice feature.

I just came across this problem because I own a solid state
disk but not all data is stored there.

Regards,
   Jens-W. Schicke
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHOXtqzhchXT4RR5ARArkkAKCxljEjRF0vXDJyyLBVTVhnxJ/idwCeOYiD
ndXrD8ZFvh5XUmzz5nTZbiI=
=871T
-----END PGP SIGNATURE-----

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

Предыдущее
От: Rafael Martinez
Дата:
Сообщение: Re: Need to run CLUSTER to keep performance
Следующее
От: Stephane Bailliez
Дата:
Сообщение: Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table