pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stef <svb@ucs.co.za>
To: andrew@pillette.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow loads when indexes added.
Date: Wed, 16 Mar 2005 09:59:39 +0200
Message-ID: <20050316095939.2d58a128@svb.ucs.co.za> (raw)
In-Reply-To: <200503152042.j2FKgOo29331@pillette.com>
References: <200503152042.j2FKgOo29331@pillette.com>

andrew@pillette.com mentioned :
=> Try ANALYZE after loading the referenced tables, but before loading the main table

I attached a new script for creating the load file...
 
Analyze didn't help, it actually took longer to load.
I set autocommit to off, and put a commit after every 100
inserts, chattr'd noatime atrribute off recursively on PGDATA, and
set fsync to off, this improved the time from 3min 51sec to 2min 37 sec
for the slow scenario.

But I was already doing all these things  in the app that 
used to take 40 minutes, but now takes four hours to load.

Any other suggestions?

Kind Regards
Stefan



view thread (2+ messages)

Message-ID: <20050316095939.2d58a128@svb.ucs.co.za>
Permalink:  ../20050316095939.2d58a128@svb.ucs.co.za/
Also on:    postgresql.org/message-id/20050316095939.2d58a128@svb.ucs.co.za

 · 

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: svb@ucs.co.za, andrew@pillette.com
  Subject: Re: Slow loads when indexes added.
  In-Reply-To: <20050316095939.2d58a128@svb.ucs.co.za>

* 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