Re: Optimize update query - Mailing list pgsql-performance

From Willem Leenen
Subject Re: Optimize update query
Date
Msg-id DUB104-W4140CECF592B7AC5F411768F430@phx.gbl
Whole thread Raw
In response to Re: Optimize update query  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Responses Re: Optimize update query  (Vitalii Tymchyshyn <tivv00@gmail.com>)
List pgsql-performance

 Actually, what's the point in putting logs to ssd? SSDs are good for random access and logs are accessed sequentially. I'd put table spaces on ssd and leave logs on hdd
30 лист. 2012 04:33, "Niels Kristian Schjødt" <nielskristian@autouncle.com> напис.
Because SSD's are considered faster. Then you have to put the most phyisical IO intensive operations on SSD. For the majority of databases, these are the logfiles. But you should investigate where the optimum is for your situation.
 

pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Optimize update query
Next
From: Vitalii Tymchyshyn
Date:
Subject: Re: Optimize update query