From: Jim C. Nasby <decibel@decibel.org>
To: pgsql-performance@postgresql.org
Subject: Interesting numbers on a CREATE INDEX
Date: Fri, 22 Apr 2005 22:09:20 -0500
Message-ID: <20050423030920.GZ58835@decibel.org> (raw)
Building a single-column index on a dual opteron with 4G of memory, data
on a 4 SATA RAID10; OS, logs and tempsace on a SATA mirror, with
sort_mem set to 2.5G, create index is actually CPU bound for large
portions of time. The postgresql process and system time are accounting
for an entire CPU, and systat (this is a FreeBSD5.2 box) is generally
showing 80% utilization on the RAID10 and 40% on the mirror.
Not a performance problem, but I thought some people might be
interested. The RAID10 is doing about 28-32MB/s, I would think this
wouldn't be enough to swamp the CPU but I guess I would be thinking
wrong.
BTW, the column I'm indexing is a bigint with a low correlation.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org
Subject: Re: Interesting numbers on a CREATE INDEX
In-Reply-To: <20050423030920.GZ58835@decibel.org>
* 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