pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Willem Leenen <willem_leenen@hotmail.com>
To: tivv00@gmail.com
To: nielskristian@autouncle.com
Cc: kgrittn@mail.com
Cc: sthomas@optionshouse.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimize update query
Date: Fri, 30 Nov 2012 10:14:15 +0000
Message-ID: <DUB104-W4140CECF592B7AC5F411768F430@phx.gbl> (raw)
In-Reply-To: <CABWW-d0OAT7L0beYR160jieG4=-PMHhmiMVMh=v3pNYspd9XCA@mail.gmail.com>
References: <20121130012426.69300@gmx.com>
	<C5E296A1-F820-4B04-9DBD-E78380BD3300@autouncle.com>
	<855F8817-6C9A-4EFB-BB80-752BF7B73B56@autouncle.com>
	<CABWW-d0OAT7L0beYR160jieG4=-PMHhmiMVMh=v3pNYspd9XCA@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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. 
  		 	   		  

view thread (34+ messages)  latest in thread

Message-ID: <DUB104-W4140CECF592B7AC5F411768F430@phx.gbl>
Permalink:  ../DUB104-W4140CECF592B7AC5F411768F430@phx.gbl/
Also on:    postgresql.org/message-id/DUB104-W4140CECF592B7AC5F411768F430@phx.gbl

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: willem_leenen@hotmail.com, tivv00@gmail.com, nielskristian@autouncle.com, kgrittn@mail.com, sthomas@optionshouse.com
  Subject: Re: Optimize update query
  In-Reply-To: <DUB104-W4140CECF592B7AC5F411768F430@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox