larger shared buffers slows down cluster

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема larger shared buffers slows down cluster
Дата
Msg-id 50354595.5070004@dunslane.net
обсуждение исходный текст
Ответы Re: larger shared buffers slows down cluster
Re: larger shared buffers slows down cluster
Список pgsql-hackers
This problem has been reported by a client.

Consider the following very small table test case:
   create table bar as select a,b,c,d,e from generate_series(1,2) a,   generate_series(3,4) b, generate_series( 5,6) c,
 generate_series(7,8) d, generate_series(9,10) e;   create index bar_a on bar(a);   create index bar_b on bar(b);
createindex bar_c on bar(c);   create index bar_d on bar(d);   create index bar_e on bar(e);   create unique index
bar_abcdeon bar(a,b,c,d,e);
 


Now running:
   cluster bar using bar_abcde;


appears to be very sensitive to the shared buffers setting. In an amazon 
very large memory instance (64GB) and PostgreSQL 9.1.4, I observed the 
following timings:

    Shared Buffers   Time      48Gb           2058ms       8Gb            372ms       1gb             67ms


Is this expected behaviour? If so, is there a good explanation? I'm not 
sure what other operations might be affected this way.

cheers

andrew



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Audit Logs WAS: temporal support patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: larger shared buffers slows down cluster