Re: What is the most optimal config parameters to keep stable write TPS ?..

From: bock@openit.de (Julian v. Bock)
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Date: ,
Msg-id: lpab5isbro.fsf@warpcore.i.openit.de
(view: Whole thread, Raw)
In response to: Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri)
Responses: Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri)
List: pgsql-performance

Tree view

What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
 Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
  Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
     Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
      Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  (Scott Marlowe, )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  (Laurent Laborde, )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  ( (Julian v. Bock), )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
 Re: What is the most optimal config parameters to keep stable write TPS ?..  (Greg Smith, )
  Re: What is the most optimal config parameters to keep stable write TPS ?..  (Scott Marlowe, )

Hi

>>>>> "D" == Dimitri  <> writes:

D> current postgresql.conf:

D> #================================
D> max_connections = 2000 # (change requires restart)
D> temp_buffers = 200MB

temp_buffers are kept per connection and not freed until the session
ends. If you use some kind of connection pooling this can eat up a lot
of ram that could be used for caching instead.

Regards,
Julian


pgsql-performance by date:

From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..
From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..