Re: Vacuum, Freeze and Analyze: the big picture - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Vacuum, Freeze and Analyze: the big picture
Date
Msg-id 1371079876.48038.YahooMailNeo@web162906.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Vacuum, Freeze and Analyze: the big picture  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> wrote:

> Are there other anecdotes about what settings work well in
> practise, assuming people ever find ones that work well?

Putting WAL on its own RAID on its own battery-backed cached can
help a lot more than I would have thought -- even with read-only
transactions.

http://www.postgresql.org/message-id/4B71358E020000250002F0E4@gw.wicourts.gov

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: [9.3] Automatically updatable views vs writable foreign tables
Next
From: Tom Lane
Date:
Subject: Re: [9.3] Automatically updatable views vs writable foreign tables