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

very slow when writing query to file

From: boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
To: pgadmin-support(at)postgresql(dot)org
Subject: very slow when writing query to file
Date: 2011-10-26 12:57:15
Message-ID: 4EA803AB.4090709@wsl.ch (view raw or flat)
Thread:
Lists: pgadmin-support
I have a postgresql database 8.3 on a server. When querying the data 
with the pgAdmin sql editor, I can get an answer in about 10 s, for 
100'000 rows. When I'm pressing the button to execute the query to a 
file it takes more than 1 hour to get the query results saved (writes 
about 10 MB in 45 minutes).

Am I doing something wrong?
Are there some parameters to set?

This happens with the version 1.14 of pgAdmin, but used also to be very 
slow with the previous versions (2-3 years ago).

OS : Archlinux (but had the same problem 1-2 years ago with ubuntu)

Thank you ,
Boris


Responses

pgadmin-support by date

Next:From: Josh BerkusDate: 2011-10-27 01:02:31
Subject: Re: Re: Bug - Rows in Query Output pane fail to grow in height when font size preference size is larger
Previous:From: Henry DrexlerDate: 2011-10-25 20:06:11
Subject: Re: Minor bug, keyboard navigation

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