Re: Transaction speed - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Transaction speed
Date
Msg-id 200404231244.46679.josh@agliodbs.com
Whole thread Raw
In response to Transaction speed  ("Derrick Betts" <Derrick@grifflink.com>)
List pgsql-novice
Derrick,

> Production database that is hosted remotely, accessed with pgAdminIII.
>     When I INSERT records into a table (only 500 or so) it never completes
> (I've waited for 30 minutes before).  It will take a transaction of up to
> 200 statements, but it takes 3-5 minutes.

This has got to be something about how pgAdmin handles batch inserts.   I
suggest trying the pgAdmin mailing list.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: "Derrick Betts"
Date:
Subject: Transaction speed
Next
From: ahermosi@lonquensur.cl
Date:
Subject: Problem with pgsql with fedora core 1