[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: Stefan Keller <sfkeller@xxxxxxxxx>
Subject: 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 <andrew@xxxxxxxxxxxx>
Date: Thu, 01 Mar 2012 18:08:19 -0500
Cc: Jeff Janes <jeff.janes@xxxxxxxxx>, Claudio Freire <klaussfreire@xxxxxxxxx>, postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <CAFcOn2-bhKg3hbLMUDK1=_9FookxP6xbqeubzO9uwcP=dqnwyw@mail.gmail.com>
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>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0) Gecko/20120131 Thunderbird/10.0



On 03/01/2012 05:52 PM, Stefan Keller wrote:

These are the current modified settings in postgresql.conf:
shared_buffers = 128MB
work_mem = 3MB

These are extremely low settings on virtually any modern computer. Iusually look to set shared buffers in numbers of Gb and work_mem atleast in tens if not hundreds of Mb for any significantly sized database.


cheers

andrew

--
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: Claudio Freire

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

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]