Thread: Transaction speed

Transaction speed

From
"Derrick Betts"
Date:
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

Re: Transaction speed

From
Andreas Pflug
Date:
Derrick Betts wrote:

> 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)
>  

Missing index or so?
Apparently this is no pgadmin3 related problem, you'd probably get 
better help on pgsql-performance or so.

Regards,
Andreas