pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff <threshar@torgo.978.org>
To: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: INSERT extremely slow with large data sets (fwd)
Date: Fri, 14 Nov 2003 08:37:55 -0500
Message-ID: <20031114083755.67841110.threshar@torgo.978.org> (raw)
In-Reply-To: <Pine.GSO.4.10.10311142037080.13532-100000@bruce.csse.monash.edu.au>
References: <Pine.GSO.4.10.10311142037080.13532-100000@bruce.csse.monash.edu.au>

On Fri, 14 Nov 2003 20:38:33 +1100 (EST)
Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au> wrote:

> Any help would be greatly appreciated even pointing me in the right
> direction where to ask this question. By the way I designed the
> database this way as my application that uses PGSQL a lot during the
> execution so there was a huge need for fast SELECTs. Our experiments
> are getting larger and larger every day so fast inserts would be good
> as well.
> 

First, you need to upgrade to 7.3.4, 7.4 is prefable if a dump/reload is
not too bad.

Standard set of questions:

1. Any foreign keys
2. are these inserts batched into transactions
3. CPU usage?
4. OS?
5. PG config? [shared_buffers, effective_cache_size, etc]
6. IO saturation?

Also, try searching the archives. lots of juicy info there too.

-- 
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



view thread (6+ messages)  latest in thread

Message-ID: <20031114083755.67841110.threshar@torgo.978.org>
Permalink:  ../20031114083755.67841110.threshar@torgo.978.org/
Also on:    postgresql.org/message-id/20031114083755.67841110.threshar@torgo.978.org

 · 

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: threshar@torgo.978.org, Slavisa.Garic@infotech.monash.edu.au
  Subject: Re: INSERT extremely slow with large data sets (fwd)
  In-Reply-To: <20031114083755.67841110.threshar@torgo.978.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