Re: slow update of index during insert/copy - Mailing list pgsql-performance

From Thomas Finneid
Subject Re: slow update of index during insert/copy
Date
Msg-id 48C0E931.4080703@ifi.uio.no
Whole thread Raw
In response to Re: slow update of index during insert/copy  (Greg Smith <gsmith@gregsmith.com>)
List 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



pgsql-performance by date:

Previous
From: "David Wilson"
Date:
Subject: Re: inaccurate stats on large tables
Next
From: Matthew Wakeling
Date:
Subject: Re: too many clog files