| From: | "Derrick Betts" <Derrick(at)grifflink(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Transaction speed |
| Date: | 2004-04-24 19:48:20 |
| Message-ID: | 066e01c42a35$188e0390$0200a8c0@main |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
I have the following situation:
Test database inside our network, accessed with pgAdminIII version 1.0.2.
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 version 1.0.2.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2004-04-24 22:56:14 | Re: Transaction speed |
| Previous Message | Peter Eisentraut | 2004-04-23 14:11:03 | SQL worksheet |