Re: psql is slow and it does not take much resources

From: "Larry Rosenman" <lrosenman(at)pervasive(dot)com>
To: "Javier de la Torre" <jatorre(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql is slow and it does not take much resources
Date: 2006-05-03 14:12:46
Message-ID: F6616E0E81AC0841B1F9DD252F7C4B55041A56@ausmaildd.aus.pervasive.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Javier de la Torre wrote:
> It is inserts.
>
> I create the inserts myself with a Python programmed I hace created to
> migrate MySQL databases to PostgreSQL (by th way if someone wants
> it...)
Ok, that makes *EACH* insert a transaction, with all the overhead.

You need to batch the inserts between BEGIN;/COMMIT; pairs, or, better
yet
set it up as a COPY.

--
Larry Rosenman
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531

Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry(dot)Rosenman(at)pervasive(dot)com
Web: www.pervasive.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2006-05-03 14:28:10 Re: psql is slow and it does not take much resources
Previous Message Javier de la Torre 2006-05-03 14:11:36 Re: psql is slow and it does not take much resources