pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Christopher Petrilli <petrilli@gmail.com>
Cc: jd@commandprompt.com, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Marc G. Fournier <scrappy@postgresql.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sustained inserts per sec ... ?
Date: Mon, 04 Apr 2005 23:44:00 +0100
Message-ID: <1112654640.16721.859.camel@localhost.localdomain> (raw)
In-Reply-To: <59d991c4050404140333bff1ed@mail.gmail.com>
References: <20050401140421.P18194@ganymede.hub.org>
	<59d991c4050401124638c4ab5d@mail.gmail.com>
	<1112388818.3487.34.camel@jd2.commandprompt.com>
	<59d991c4050401125956d6069d@mail.gmail.com>
	<59d991c40504040648457808e9@mail.gmail.com>
	<1112644015.16721.790.camel@localhost.localdomain>
	<59d991c4050404125611ad5af8@mail.gmail.com>
	<1112645479.16721.806.camel@localhost.localdomain>
	<59d991c405040413184699cfe1@mail.gmail.com>
	<1112648303.16721.816.camel@localhost.localdomain>
	<59d991c4050404140333bff1ed@mail.gmail.com>

On Mon, 2005-04-04 at 17:03 -0400, Christopher Petrilli wrote:
> On Apr 4, 2005 4:58 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> > Can you do:
> > select relname from pg_class where relfilenode = 26488271
> > and confirm that the name is the table you've been loading...
> 
> It is.
>  
> > Couldn't see all your indexes... are they still there?
> 
> Nope, I'm running a second run without the auxilary indices.  I only
> have the primary key index.  So far, a quick scan with the eye says
> that it's behaving "better", but beginning to have issues again.  I'll
> post results as soon as they are done.

Hmmm....

Before I start to tunnel-vision on a particular coincidence...

How much memory have you got on the system?
How much of that have you allocated to various tasks?
What else is happening on your system?
Tell us more about disk set-up and other hardware related things.
Disk cache...disk speed...seek times....etc

Best Regards, Simon Riggs








view thread (44+ messages)  latest in thread

Message-ID: <1112654640.16721.859.camel@localhost.localdomain>
Permalink:  ../1112654640.16721.859.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1112654640.16721.859.camel@localhost.localdomain

 · 

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: simon@2ndquadrant.com, petrilli@gmail.com, tgl@sss.pgh.pa.us, scrappy@postgresql.org
  Subject: Re: Sustained inserts per sec ... ?
  In-Reply-To: <1112654640.16721.859.camel@localhost.localdomain>

* 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