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

Re: Query planning configuration and solid state drives

From: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
To: "Merlin Moncure" <mmoncure(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 18:55:41
Message-ID: a595de7a0805301155h1b182b6n84c1d464fd486192@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
2008/5/30 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Fri, May 30, 2008 at 11: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.
>
> random_page_cost can probably be reduced...
>
> is this flash ssd?

Yes, flash ssd.

Regards, Clodoaldo

>
> merlin
>

In response to

Responses

pgsql-general by date

Next:From: Merlin MoncureDate: 2008-05-30 19:02:23
Subject: Re: Query planning configuration and solid state drives
Previous:From: ChristopheDate: 2008-05-30 17:57:43
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade

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