Re: tuning Postgres for large data import (using Copy from)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Mamin" <m(dot)mamin(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: tuning Postgres for large data import (using Copy from)
Date: 2005-05-12 14:31:18
Message-ID: 419.1115908278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Marc Mamin" <m(dot)mamin(at)gmx(dot)net> writes:
> 1) use 3 different disks for:

> -1: source data
> -2: index tablespaces
> -3: data tablespaces

It's probably much more important to know where you put the WAL.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-05-12 14:53:31 Re: tuning Postgres for large data import (using Copy from)
Previous Message Tom Lane 2005-05-12 14:15:26 Re: AND OR combination: index not being used