Re: shared_buffers advice

От: Alvaro Herrera
Тема: Re: shared_buffers advice
Дата: ,
Msg-id: 20100316222922.GJ3037@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: shared_buffers advice  (Tom Lane)
Список: 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, )

Tom Lane escribió:
> 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.

Well, that would solve the problem as far as I'm concerned and they'd
have to start talking to their storage provider ;-)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

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