Re: Limit + group + join

От: Merlin Moncure
Тема: Re: Limit + group + join
Дата: ,
Msg-id: 6EE64EF3AB31D5448D0007DD34EEB3417DD207@Herge.rcsinc.local
(см: обсуждение, исходный текст)
Ответ на: Limit + group + join  (Tobias Brox)
Список: pgsql-performance

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

Limit + group + join  (Tobias Brox, )
 Re: Limit + group + join  ("Jeffrey W. Baker", )
  Re: Limit + group + join  (Tobias Brox, )
  Re: Limit + group + join  ("Jeffrey W. Baker", )
 Re: Limit + group + join  (Mark Kirkwood, )
  Re: Limit + group + join  (Tobias Brox, )
  Re: Limit + group + join  (Stephan Szabo, )
  Re: Limit + group + join  (Tom Lane, )
   Re: Limit + group + join  (Mark Kirkwood, )
    Re: Limit + group + join  (Tom Lane, )
   Re: Limit + group + join  (Mark Kirkwood, )
    Re: Limit + group + join  (Tom Lane, )
     Re: Limit + group + join  (Mark Kirkwood, )
      Re: Limit + group + join  (Tobias Brox, )
   Re: Limit + group + join  (Greg Stark, )
 Re: Limit + group + join  ("Merlin Moncure", )
 Re: Limit + group + join  ("Merlin Moncure", )

Tobias wrote:
> Splendid :-) Unfortunately we will not be upgrading for some monthes
> still,
> but anyway I'm happy.  This provides yet another good argument for
> upgrading
> sooner.  I'm also happy to see such a perfect match:
>
>  - A problem that can be reduced from beeing complex and
>    production-specific, to simple and easily reproducible.
>
>  - Enthusiastic people testing it and pinpointing even more precisely
what
>    conditions will cause the condition
>
>  - Programmers actually fixing the issue
>
>  - Testers verifying that it was fixed
>
> Long live postgresql! :-)

In the last three or so years since I've been really active with
postgresql, I've found two or three issues/bugs which I was able to
reproduce and reduce to a test case.  In all instances the fix was in
cvs literally within minutes.

Merlin


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

От: asif ali
Дата:
Сообщение: Re: Weird performance drop after VACUUM
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: shared buffers