pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PFC <lists@boutiquenumerique.com>
To: Arshavir Grigorian <ag@m-cam.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres on RAID5
Date: Sat, 12 Mar 2005 03:20:18 +0100
Message-ID: <opsnh534mcth1vuj@localhost> (raw)
In-Reply-To: <42323660.6090002@m-cam.com>
References: <423209E1.6090200@m-cam.com>
	<42323660.6090002@m-cam.com>


	Look for the possibility that a foreign key check might not be using an  
index. This would yield a seq scan for each insertion, which might be your  
problem.


On Fri, 11 Mar 2005 19:22:56 -0500, Arshavir Grigorian <ag@m-cam.com>  
wrote:

> Many thanks for all the response.
>
> I guess there are a lot of things to change and tweak and I wonder what  
> would be a good benchmarking sample dataset (size, contents).
>
> My tables are very large (the smallest is 7+ mil records) and take  
> several days to load (if not weeks). It would be nice to have a sample  
> dataset that would be large enough to mimic my large datasets, but small  
> enough to load in a short priod of time. Any suggestions?
>
>
> Arshavir
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>





view thread (26+ messages)  latest in thread

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

 · 

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: lists@boutiquenumerique.com, ag@m-cam.com
  Subject: Re: Postgres on RAID5
  In-Reply-To: <opsnh534mcth1vuj@localhost>

* 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