From: Thomas Finneid <tfinneid@student.matnat.uio.no>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Thomas Finneid <tfinneid@student.matnat.uio.no>
Cc: pgsql-performance@postgresql.org
Subject: Re: slow update of index during insert/copy
Date: Tue, 02 Sep 2008 08:39:24 +0200
Message-ID: <48BCDF9C.5020906@ifi.uio.no> (raw)
In-Reply-To: <Pine.GSO.4.64.0809011558080.10428@westnet.com>
References: <48BA9D65.2020001@ifi.uio.no>
<48BB4A2D.9080404@postnewspapers.com.au>
<48BBD22E.4090308@ifi.uio.no>
<Pine.GSO.4.64.0809011558080.10428@westnet.com>
Greg Smith wrote:
> On Mon, 1 Sep 2008, Thomas Finneid wrote:
Thanks for all the info on the disk controller, I will have to look
through all that now :)
> I note that nobody has talked about your postgresql.conf yet. I assume
> you've turned autovacuum off because you're not ever deleting things
> from these tables.
That is correct.
> You'll still need to run VACUUM ANALYZE periodically
> to keep good statistics for your tables, but I don't think that's
will look at it.
> You should try setting this to open_sync , that can be considerably
> faster for some write-heavy situations. Make sure to test that
> throughly though, there are occasional reports of issues with that
> setting under Linux; seems to vary based on kernel version. I haven't
> had a chance to test the Ubuntu Hardy heavily in this area yet myself.
The production machine is Solaris 10 running on a Sun v980. Do you know
of it has any issues like these?
Additionally, would I need to do any config changes when going from
linux to solaris?
The v980 has got lots of memory and a FC disk system, but I don't know
much more about controllers and disk etc. But I suspects its got at
least the same features as the disks and controller thats in the devel
machine.
regards
thomas
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: tfinneid@student.matnat.uio.no, gsmith@gregsmith.com
Subject: Re: slow update of index during insert/copy
In-Reply-To: <48BCDF9C.5020906@ifi.uio.no>
* 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