random_page_cost = 1?

From: Alex Stapleton <alexs(at)advfn(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: random_page_cost = 1?
Date: 2005-06-09 16:37:25
Message-ID: E272DAB0-E99F-45E2-9461-99E0FD40F2AC@advfn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is this advisable? The disks are rather fast (15k iirc) but somehow I
don't think they are covered in whatever magic fairy dust it would
require for a sequential read to be as fast as a random one. However
I could be wrong, are there any circumstances when this is actually
going to help performance?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rory Campbell-Lange 2005-06-09 16:44:20 Re: Help specifying new web server/database machine
Previous Message Jona 2005-06-09 16:15:04 Re: Query plan changes after pg_dump / pg_restore