| From: | boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: very slow when writing query to file |
| Date: | 2011-10-29 20:44:25 |
| Message-ID: | 4EAC65A9.4070208@wsl.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Does anyone have any proposition how I could further test where the
problem is. This is really a strange behaviour, that I noticed with
different versions of pgAdmin.
Could a firewall produce a difference when querying data visually or for
a write to file? (should not ...)
Thank you,
Boris
Guillaume Lelarge wrote:
> On Wed, 2011-10-26 at 14:57 +0200, boris pezzatti wrote:
>> 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?
>>
> Never heard of such a behaviour before. I'm not sure what happens on
> your computer.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Leovey | 2011-10-29 21:01:43 | Re: very slow when writing query to file |
| Previous Message | Manish Jain | 2011-10-28 22:53:25 | Re: SQL Query tool in PGAdmin causing exception |