Postgres Pro
Downloads
Home   >   mailing lists

Re: tuning Postgres for large data import (using Copy from) - Mailing list pgsql-performance

From Tom Lane
Subject Re: tuning Postgres for large data import (using Copy from)
Date
Msg-id 419.1115908278@sss.pgh.pa.us
Whole thread Raw
In response to tuning Postgres for large data import (using Copy from)  ("Marc Mamin" <m.mamin@gmx.net>)
List pgsql-performance
Tree view 
"Marc Mamin" <m.mamin@gmx.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: AND OR combination: index not being used
Next
From: John A Meinel
Date:
Subject: Re: tuning Postgres for large data import (using Copy from)