PostgreSQL settings for running on an SSD drive

From: CS DBA <cs_dba(at)consistentstate(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL settings for running on an SSD drive
Date: 2013-06-20 19:56:28
Message-ID: 51C35E6C.1090705@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2013-06-20 20:13:10 Re: PostgreSQL settings for running on an SSD drive
Previous Message Sameer Thakur 2013-06-20 04:04:13 Re: pg_stat_statements behavior in crash recovery