Skip site navigation (1) Skip section navigation (2)

Re: Parallel Vacuum

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Parallel Vacuum
Date: 2007-03-22 18:46:15
Message-ID: 20070322184613.GJ11402@mathom.us (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Mar 22, 2007 at 07:24:38PM +0100, Dimitri wrote:
>you're right until you're using a single disk :) 
>Now, imagine you have more disks

I do have more disks. I maximize the I/O performance by dedicating 
different sets of disks to different tables. YMMV. I do suggest watching 
your I/O rates and wallclock time if you try this to see if your 
aggregate is actually substantially faster than the single case. (I 
assume that you haven't yet gotten far enough to actually do performance 
testing.) You may also want to look into tuning your sequential I/O 
performance.

Mike Stone

In response to

Responses

pgsql-performance by date

Next:From: Craig A. JamesDate: 2007-03-22 19:18:24
Subject: Re: Performance of count(*)
Previous:From: Tom LaneDate: 2007-03-22 18:37:26
Subject: Re: Performance of count(*)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group