pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Smith <gsmith@gregsmith.com>
To: Lionel <lionel@art-informatique.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Which hardware ?
Date: Tue, 17 Jun 2008 17:15:14 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0806171710340.9151@westnet.com> (raw)
In-Reply-To: <g38u2m$2ua9$1@news.hub.org>
References: <g38epm$2pl4$1@news.hub.org>
	<20080617142501.GG68434@commandprompt.com>
	<Pine.GSO.4.64.0806171108060.7150@westnet.com>
	<dcc563d10806170842g6d039d7bsec81fb562ba9facd@mail.gmail.com>
	<Pine.GSO.4.64.0806171232390.10502@westnet.com>
	<dcc563d10806171007o719a2171o34e492f463a6c2f2@mail.gmail.com>
	<g38u2m$2ua9$1@news.hub.org>

On Tue, 17 Jun 2008, Lionel wrote:

> I did some test with a 20 millions lines database on a single disk dual core
> 2GB win XP system (default postgresql config), most of the time is spent in
> I/O: 50-100 secs for statements that scan 6 millions of lines, which will
> happen. Almost no CPU activity.

I hope you're aware that the default config is awful, and there are all 
sorts of possible causes for heavy I/O churn that might improve if you 
setup the postgresql.conf file to use the server's resources more 
aggressively (the default is setup for machines with a very small amount 
of RAM).  There are lots of links to articles that cover the various areas 
you might improve at 
http://wiki.postgresql.org/wiki/Performance_Optimization

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

view thread (18+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0806171710340.9151@westnet.com>
Permalink:  ../Pine.GSO.4.64.0806171710340.9151@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0806171710340.9151@westnet.com

copy link · copy postgr.es

reply

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: gsmith@gregsmith.com, lionel@art-informatique.com
  Subject: Re: Which hardware ?
  In-Reply-To: <Pine.GSO.4.64.0806171710340.9151@westnet.com>

* 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