Skip site navigation (1) Skip section navigation (2)

Re: Transaction speed

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Derrick Betts <Derrick(at)grifflink(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Transaction speed
Date: 2004-04-24 22:56:14
Message-ID: 408AF08E.2090302@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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



In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-04-25 18:10:25
Subject: Re: Incorrect permissions shown for view.
Previous:From: Derrick BettsDate: 2004-04-24 19:48:20
Subject: Transaction speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group