Postgres Pro
Downloads
Home   >   mailing lists

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

From Merlin Moncure
Subject Re: Query planning configuration and solid state drives
Date
Msg-id b42b73150805300959o56e0d6a5v4255ff13798d1945@mail.gmail.com
Whole thread Raw
In response to Query planning configuration and solid state drives  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Query planning configuration and solid state drives  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
List pgsql-general
Tree view 
On Fri, May 30, 2008 at 11: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.

random_page_cost can probably be reduced...

is this flash ssd?

merlin

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: The optimizer is too smart for me - How can I trick it?
Next
From: Jon Lapham
Date:
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade