От: Dennis Bjorklund
Тема: Re: Need for speed
Дата: ,
Msg-id: Pine.LNX.4.44.0508162045480.2995-100000@zigo.dhs.org
(см: обсуждение, исходный текст)
Ответ на: Need for speed  (Ulrich Wisser)
Ответы: Re: Need for speed  (Ulrich Wisser)
Список: pgsql-performance

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

Need for speed  (Ulrich Wisser, )
 Re: Need for speed  (Richard Huxton, )
 Re: Need for speed  (John A Meinel, )
 Re: Need for speed  ("Jeffrey W. Baker", )
 Re: Need for speed  (Alex Turner, )
  Re: Need for speed  ("Jim C. Nasby", )
 Re: Need for speed  (Dennis Bjorklund, )
  Re: Need for speed  (Ulrich Wisser, )
   Re: Need for speed  (Tom Lane, )
   Re: Need for speed  ("Jeffrey W. Baker", )
   Re: Need for speed  (Josh Berkus, )
   Re: Need for speed  (Ron, )
 Re: Need for speed  (Ron, )
  Re: Need for speed  (Matthew Nuzum, )
   Need for speed 2  (Ulrich Wisser, )
    Re: Need for speed 2  (Frank Wiles, )
    Re: Need for speed 2  (Ron, )
     Re: Need for speed 2  (Kelly Burkhart, )
      Re: Need for speed 2  (Alex Turner, )
    Re: Need for speed 2  ("Merlin Moncure", )
     What *_mem to increase when running CLUSTER  (Andrew Lazarus, )
      Re: What *_mem to increase when running CLUSTER  (Steve Poe, )
      Re: What *_mem to increase when running CLUSTER  (Tom Lane, )
 Re: Need for speed  ("Roger Hand", )
  Re: Need for speed  (Christopher Browne, )

On Tue, 16 Aug 2005, Ulrich Wisser wrote:

> Still when several users are on line the reporting gets very slow.
> Queries can take more then 2 min.

Could you show an exampleof such a query and the output of EXPLAIN ANALYZE
on that query (preferably done when the database is slow).

It's hard to say what is wrong without more information.

--
/Dennis Björklund



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

От: John A Meinel
Дата:
Сообщение: Re: PG8 Tuning
От: "Anjan Dave"
Дата:
Сообщение: Re: choosing RAID level for xlogs