[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?

To: Andrew Dunstan <andrew@xxxxxxxxxxxx>
Subject: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
From: Claudio Freire <klaussfreire@xxxxxxxxx>
Date: Thu, 1 Mar 2012 21:23:20 -0300
Authentication-results: mr.google.com; spf=pass (google.com: domain of klaussfreire@xxxxxxxxx designates 10.152.123.68 as permitted sender) smtp.mail=klaussfreire@xxxxxxxxx; dkim=pass header.i=klaussfreire@xxxxxxxxx
Cc: postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <4F500163.9090200@dunslane.net>
References: <CAFcOn28A3dkmCEGsu-7Chi0gH1qAPYcfbSp8op9gswFawS6ECA@mail.gmail.com> <4F4A4DD6.6090904@squeakycode.net> <CAFcOn2-n=fCmJEwB81V-SDo00RzTPrQbrh=GAgxoE1DWLqhtDw@mail.gmail.com> <4F4A861A.3000301@squeakycode.net> <CAFcOn28oCqoNJFVL8wdc6+QcMNuzLC5YuoamCJGF5npe8JT+WA@mail.gmail.com> <CAMkU=1wJ7ciYC_qX1es8oGQSc08jM7Vpvg52ahxU39ao93EC0w@mail.gmail.com> <CAFcOn29S7KMe+0qQY459OoGGZUEuF=zo4NPFw8=1CW=LB2yEGA@mail.gmail.com> <CAGTBQpY16=6GLsQG=O2FFh4zfBKof6u9r=C94YA0Em6vPL76zg@mail.gmail.com> <CAFcOn2-b2ZAi-Zy7v29sqfL+4s5mp8Zpnq1UpHoORQ7ctikNTA@mail.gmail.com> <CAMkU=1zUHzWzCWJWiUkq+rhC_yZuK8h6FaTC-wjPRPgZXTfzNA@mail.gmail.com> <CAFcOn2-bhKg3hbLMUDK1=_9FookxP6xbqeubzO9uwcP=dqnwyw@mail.gmail.com> <4F500163.9090200@dunslane.net>

On Thu, Mar 1, 2012 at 8:08 PM, Andrew Dunstan <andrew@xxxxxxxxxxxx> wrote:
> These are extremely low settings on virtually any modern computer. I usually
> look to set shared buffers in numbers of Gb and work_mem at least in tens if
> not hundreds of Mb for any significantly sized database.

For a read-only database, as was discussed, a lower shared_buffers
settings makes sense. And 128M is low enough, I'd guess.

Setting work_mem to hundreds of MB in a 4G system is suicide. Tens
even is dangerous.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Follow-Ups:
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Peter van Hardenberg

References:
- PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Andy Colson
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Andy Colson
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Jeff Janes
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Claudio Freire
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Jeff Janes
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Stefan Keller
- Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
  - From: Andrew Dunstan

Prev by Date: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Next by Date: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Previous by thread: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Next by thread: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]