PostgreSQL settings for running on an SSD drive - Mailing list pgsql-performance

From CS DBA
Subject PostgreSQL settings for running on an SSD drive
Date
Msg-id 51C35E6C.1090705@consistentstate.com
Whole thread Raw
Responses Re: PostgreSQL settings for running on an SSD drive  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-performance
All;

I'm working with a client running PostgreSQL on a Fusion-IO drive.

They have a PostgreSQL setup guide from Fusion recommending the
following settings:
effective_io_concurrency=0
bgwriter_lru_maxpages=0
random_page_cost=0.1
sequential_page_cost=0.1


These seem odd to me, effectively turning the background writer off,
plus setting both random_page_cost and sequential_page_cost to the same
(very low) value...

Thoughts?


Thanks in advance


pgsql-performance by date:

Previous
From: Sameer Thakur
Date:
Subject: Re: pg_stat_statements behavior in crash recovery
Next
From: Shaun Thomas
Date:
Subject: Re: PostgreSQL settings for running on an SSD drive