Re: shared_buffers advice

От: Tom Lane
Тема: Re: shared_buffers advice
Дата: ,
Msg-id: 15895.1268778326@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: shared_buffers advice  (Alvaro Herrera)
Ответы: Re: shared_buffers advice  (Alvaro Herrera)
Список: pgsql-performance

Скрыть дерево обсуждения

shared_buffers advice  (Paul McGarry, )
 Re: shared_buffers advice  (Dave Crooke, )
  Re: shared_buffers advice  (Greg Smith, )
   Re: shared_buffers advice  ("Pierre C", )
    Re: shared_buffers advice  (Nikolas Everett, )
     Re: shared_buffers advice  ("Pierre C", )
      Re: shared_buffers advice  (Greg Stark, )
      Re: shared_buffers advice  (Greg Smith, )
    Re: shared_buffers advice  (Tom Lane, )
     Re: shared_buffers advice  (Greg Stark, )
      Re: shared_buffers advice  (Greg Smith, )
      Re: shared_buffers advice  (Alvaro Herrera, )
       Re: shared_buffers advice  (Tom Lane, )
        Re: shared_buffers advice  (Alvaro Herrera, )
         Re: shared_buffers advice  (Tom Lane, )
          Re: shared_buffers advice  (Alvaro Herrera, )
           Re: shared_buffers advice  (Tom Lane, )
            Re: shared_buffers advice  (Alvaro Herrera, )
       Re: shared_buffers advice  (Greg Smith, )
        Re: shared_buffers advice  (Dimitri Fontaine, )
         Re: shared_buffers advice  (Greg Smith, )
          Re: shared_buffers advice  (Dimitri Fontaine, )
 Fwd: shared_buffers advice  (VJK, )
 Re: shared_buffers advice  (Konrad Garus, )
  [SPAM] Re: shared_buffers advice  (Ben Chobot, )
  Re: shared_buffers advice  (Cédric Villemain, )
   Re: shared_buffers advice  (Konrad Garus, )
    Re: shared_buffers advice  (Cédric Villemain, )
     Re: shared_buffers advice  (Konrad Garus, )
      Re: shared_buffers advice  (Cédric Villemain, )
       Re: shared_buffers advice  (Konrad Garus, )
        Re: shared_buffers advice  (Cédric Villemain, )
         Re: shared_buffers advice  (Konrad Garus, )
          Re: shared_buffers advice  (Cédric Villemain, )
           Re: shared_buffers advice  (Konrad Garus, )
            Re: shared_buffers advice  (Cédric Villemain, )
 Re: shared_buffers advice  (Merlin Moncure, )
  Re: shared_buffers advice  (Konrad Garus, )
   Re: shared_buffers advice  (Merlin Moncure, )
    Re: shared_buffers advice  (Greg Smith, )
     Re: shared_buffers advice  (Merlin Moncure, )
      Re: shared_buffers advice  (Greg Smith, )
       Re: shared_buffers advice  (Merlin Moncure, )
  Re: shared_buffers advice  (Scott Marlowe, )
   Re: shared_buffers advice  (Dave Crooke, )

Alvaro Herrera <> writes:
> Tom Lane escribió:
>> That's not going to do anything towards reducing the actual I/O volume.
>> Although I suppose it might be useful if it just cuts the number of
>> seeks.

> Oh, they had no problems with I/O volume.  It was relation extension
> lock that was heavily contended for them.

Really?  I guess that serialized all the I/O ... I'll bet if we got rid
of that locking somehow, they *would* have a problem with I/O volume.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Rob Wultsch
Дата:
Сообщение: Building multiple indexes concurrently
От: Ben Chobot
Дата:
Сообщение: Re: Building multiple indexes concurrently