Re: Sanity check requested

От: Shridhar Daithankar
Тема: Re: Sanity check requested
Дата: ,
Msg-id: 3F13E18A.21241.4B86CB0@localhost
(см: обсуждение, исходный текст)
Ответ на: Sanity check requested  ("Nick Fankhauser")
Ответы: Re: Sanity check requested  ("Nick Fankhauser")
Список: pgsql-performance

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

Sanity check requested  ("Nick Fankhauser", )
 Re: Sanity check requested  ("Shridhar Daithankar", )
  Re: Sanity check requested  ("Nick Fankhauser", )
   Re: Sanity check requested  (Josh Berkus, )
    Re: Sanity check requested  ("Nick Fankhauser", )
     Re: Sanity check requested  (Joe Conway, )
   Re: Sanity check requested  ("Shridhar Daithankar", )
    Clearing rows periodically  (Martin Foster, )
     Re: Clearing rows periodically  (Paul Thomas, )
     Re: Clearing rows periodically  (Andrew Sullivan, )
     Re: Clearing rows periodically  (Tom Lane, )
    Re: Sanity check requested  (Ang Chin Han, )
     File systems (RE: Sanity check requested)  ("Nick Fankhauser", )
      Re: File systems (RE: Sanity check requested)  (Tom Lane, )
     Re: Sanity check requested  ("scott.marlowe", )
   Re: Sanity check requested  (Vincent van Leeuwen, )
    Re: Sanity check requested  ("Nick Fankhauser", )
     Re: Sanity check requested  (Josh Berkus, )
     Re: Sanity check requested  (Rod Taylor, )
 Re: Sanity check requested  ("Oliver Scheit", )
  Re: Sanity check requested  (Vincent van Leeuwen, )
 Re: Sanity check requested  ("Oliver Scheit", )

On 14 Jul 2003 at 12:51, Nick Fankhauser wrote:
> Any thoughts? Is this a sane plan? Are there other parameters I should
> consider changing first?

Well, everything seems to be in order and nothing much to suggest I guess. But
still..

1. 30 users does not seem to be much of a oevrhead. If possible try doing away
with connection pooling. Buta test benchmark run is highly recommended.

2. While increasing sort memory, try 4/8/16 in that order. That way you will
get a better picture of load behaviour. Though whatever you put appears
reasonable, having more data always help.

3. I don't know how this affects on SCSI drives, but what file system you are
using? Can you try diferent ones? Like reiserfs/ext3 and XFS? See what fits
your bill.

4. OK, this is too much but linux kernel 2.6 is in test and has vastly improved
IO scheduler. May be you should look at it if you are up to experimentation.

HTH

Bye
 Shridhar

--
You're dead, Jim.        -- McCoy, "The Tholian Web", stardate unknown



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

От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Sanity check requested
От: Stephan Szabo
Дата:
Сообщение: Re: [GENERAL] Query Optimisation