Skip site navigation (1) Skip section navigation (2)

Re: Query planning configuration and solid state drives

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: "PostgreSQL - General ML" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query planning configuration and solid state drives
Date: 2008-05-30 16:57:19
Message-ID: dcc563d10805300957w53704a41n3e6943897fca16cd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, May 30, 2008 at 9:43 AM, Clodoaldo
<clodoaldo(dot)pinto(dot)neto(at)gmail(dot)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.

In response to

pgsql-general by date

Next:From: Merlin MoncureDate: 2008-05-30 16:59:19
Subject: Re: Query planning configuration and solid state drives
Previous:From: Martijn van OosterhoutDate: 2008-05-30 16:30:21
Subject: Re: The optimizer is too smart for me - How can I trick it?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group