2009/12/7 Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx>
Ben Brehmer <benbrehmer@xxxxxxxxx> wrote:What OS?
> -7.5 GB memory
> -4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units
> each)
> -64-bit platform
> (PostgreSQL 8.1.3)
Why use such an antiquated, buggy version? Newer versions are
faster.
-Kevin
I'd agree with trying to use the latest version you can.
How are you loading this data? I'd make sure you haven't got any indices, primary keys, triggers or constraints on your tables before you begin the initial load, just add them after. Also use either the COPY command for loading, or prepared transactions. Individual insert commands will just take way too long.
Regards
Thom
