Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance PG 8.0 on dual opteron / 4GB / 3ware - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Date
Msg-id 2503.1131308773@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance PG 8.0 on dual opteron / 4GB / 3ware  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Performance PG 8.0 on dual opteron / 4GB / 3ware  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-performance
Tree view 
Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> writes:
> Explain analyse (with PgAdmin):
> ...
> Total runtime: 5049.467 ms
> Actual execution time: 82163 MS (without getting the data)

I'm confused --- where's the 82sec figure coming from, exactly?

We've heard reports of performance issues in PgAdmin with large
result sets ... if you do the same query in psql, what happens?

            regards, tom lane

pgsql-performance by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Next
From: "Luke Lonergan"
Date:
Subject: Re: 8.1 iss