On Fri, May 30, 2008 at 2:55 PM, Clodoaldo <[EMAIL PROTECTED]> wrote: > 2008/5/30 Merlin Moncure <[EMAIL PROTECTED]>: >> On Fri, May 30, 2008 at 11:43 AM, Clodoaldo >> <[EMAIL PROTECTED]> 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.
Then you are probably aware that sequential speeds are similar to spinning disk, random access is much, much. (much) better, and random write is worse. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
