Re: slow update of index during insert/copy

From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow update of index during insert/copy
Date: 2008-09-05 08:09:21
Message-ID: 48C0E931.4080703@ifi.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith wrote:
> In practice, the "ordered"
> mode (the default for ext3) seems sufficient to prevent database
> corruption. There is a substantial performance hit to running in full
> journal mode like you're doing;

where do you see which mode I am running in? I havent specified any
modes in any config or commands, so I am assuming its using ext3
defaults, which I am assuming is "ordered".

regards

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2008-09-05 11:49:47 Re: too many clog files
Previous Message David Wilson 2008-09-05 03:25:43 Re: inaccurate stats on large tables