Logic of lowering seq_page_cost for SSD? - Mailing list pgsql-performance

From Josh Berkus
Subject Logic of lowering seq_page_cost for SSD?
Date
Msg-id 5266CA4E.5050501@agliodbs.com
Whole thread Raw
List pgsql-performance
All,

I've often seen people lower seq_page_cost for SSD access.  This has the
effect of raising CPU costs relative to the costs of disk access.
However, CPUs have also gotten lots faster, so I'm not sure that results
in a better cost balance.

Has anyone done extensive testing on this?  What did you find?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Hot Standby performance issue
Next
From: sparikh
Date:
Subject: Re: Hot Standby performance issue