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

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

To: Jeff Janes <jeff.janes@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: Claudio Freire <klaussfreire@xxxxxxxxx>
Date: Wed, 29 Feb 2012 12:18:12 -0300
Authentication-results: mr.google.com; spf=pass (google.com: domain of klaussfreire@xxxxxxxxx designates 10.112.38.3 as permitted sender) smtp.mail=klaussfreire@xxxxxxxxx; dkim=pass header.i=klaussfreire@xxxxxxxxx
Cc: Stefan Keller <sfkeller@xxxxxxxxx>, postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <CAMkU=1wD8ajPYCYNpvhVf6HOnTE6TdFwMX1vg1UhutJX3Ffr3Q@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> <CAMkU=1wD8ajPYCYNpvhVf6HOnTE6TdFwMX1vg1UhutJX3Ffr3Q@mail.gmail.com>

On Wed, Feb 29, 2012 at 12:16 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
> But on many implementations, that will not work.  tar detects the
> output is going to the bit bucket, and so doesn't bother to actually
> read the data.

Really? Getting smart on us?

Shame on it. Who asked it to be smart?

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

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: Jeff Janes

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] [Yosemite]