Skip site navigation (1) Skip section navigation (2)

Re: Load experimentation

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Ben Brehmer <benbrehmer(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Load experimentation
Date: 2009-12-07 18:39:29
Message-ID: bddc86150912071039o12ce133fwf12e2c2d71a61785@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2009/12/7 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>

> Ben Brehmer <benbrehmer(at)gmail(dot)com> wrote:
>
> > -7.5 GB memory
> > -4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units
> >    each)
> > -64-bit platform
>
> What OS?
>
> > (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

In response to

Responses

pgsql-performance by date

Next:From: Ben BrehmerDate: 2009-12-07 18:45:16
Subject: Re: Load experimentation
Previous:From: Scott MeadDate: 2009-12-07 18:33:44
Subject: Re: Load experimentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group