Postgres Pro
Downloads
Home   >   mailing lists

Re: psql is slow and it does not take much resources - Mailing list pgsql-general

From Larry Rosenman
Subject Re: psql is slow and it does not take much resources
Date
Msg-id F6616E0E81AC0841B1F9DD252F7C4B55041A56@ausmaildd.aus.pervasive.com
Whole thread Raw
In response to psql is slow and it does not take much resources  ("Javier de la Torre" <jatorre@gmail.com>)
Responses Re: psql is slow and it does not take much resources  ("Leif B. Kristensen" <leif@solumslekt.org>)
List pgsql-general
Tree view 
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.Rosenman@pervasive.com
Web: www.pervasive.com

pgsql-general by date:

Previous
From: "Javier de la Torre"
Date:
Subject: Re: psql is slow and it does not take much resources
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: psql is slow and it does not take much resources