Dave Page wrote:

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Pflug
Sent: 21 April 2005 14:06
To: Joel Fradkin
Cc: 'John A Meinel'; josh@agliodbs.com; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon

From the data, I can see that you're probably using pgAdmin3.
The time to execute your query including transfer of all data to the client is 17s in this example, while displaying it (i.e. pure GUI and memory alloc stuff) takes 72s. Execute to a file to avoid this.

Perhaps we should add a guruhint there for longer runtimes?

Yup, easily done as replacement for the "max rows exceeded" message box. Added to TODO.txt.

Regards, Andreas

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to