Postgres Pro
Downloads
Home   >   mailing lists

Re: Query planning configuration and solid state drives - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Query planning configuration and solid state drives
Date
Msg-id dcc563d10805300957w53704a41n3e6943897fca16cd@mail.gmail.com
Whole thread Raw
In response to Query planning configuration and solid state drives  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
List pgsql-general
Tree view 
On Fri, May 30, 2008 at 9:43 AM, Clodoaldo
<clodoaldo.pinto.neto@gmail.com> wrote:
> What should be changed in the query planning configuration, if at all,
> if a ultrafast solid state drive would be used to host a whole
> database ? Specially if used in Raid 0 configurations.

Well, random page cost should be about 1.0

Not sure other than that.

pgsql-general by date:

Previous
From: Jon Lapham
Date:
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade
Next
From: Jon Lapham
Date:
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade