Re: [PGSQL 8.3.5] Use of a partial indexes

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Scott Ribe" <scott_ribe(at)killerbytes(dot)com>
Cc: "Reg Me Please" <regmeplease(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [PGSQL 8.3.5] Use of a partial indexes
Date: 2008-12-29 17:07:43
Message-ID: dcc563d10812290907v31abc1c3k1d4b001878648945@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 29, 2008 at 9:28 AM, Scott Ribe <scott_ribe(at)killerbytes(dot)com> wrote:
>> voila! cache dumped.
>
> What about read caches in the disk devices themselves?

Given that most drives have caches that are in the 16 to 32Meg range,
I doubt it makes a big difference. But you can always just dd a file
both ways that are 100Meg or so and dump it out.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bayless Kirtley 2008-12-29 17:20:47 Re: open transaction?
Previous Message Scott Ribe 2008-12-29 16:28:34 Re: [PGSQL 8.3.5] Use of a partial indexes