Transaction speed

From: "Derrick Betts" <Derrick(at)grifflink(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Transaction speed
Date: 2004-04-23 18:39:24
Message-ID: 05b601c42962$50127fe0$0200a8c0@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have the following situation:

Test database inside our network, accessed with pgAdminIII.
When I INSERT records into a table (3000-5000 in one transaction) it takes between 2.5 - 5 seconds. No worries there.

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.

Has anyone seen this situation before, and have a reason as to why this may be happening? Is there something that needs to change on the production server? Is it a tcpip latency issue that breaks the connection? (I'm guessing now)

Thanks in advance,
Derrick

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2004-04-23 19:44:46 Re: Transaction speed
Previous Message David Ayers 2004-04-23 11:48:53 libpg date/timestamps format used by PQgetvalue