Re: PostgreSQL Tweaking

On Fri, Apr 9, 2010 at 12:54 PM, renier <renier(at)vvconsult(dot)co(dot)za> wrote:
.......
> Explain Analyse results:
> "Seq Scan on assetregistericon  (cost=0.00..41106.50 rows=738050 width=428) (actual time=0.036..667.962 rows=738050 loops=1)"
> "Total runtime: 1209.181 ms"
>
............
> -- Executing query:
> select * from assetregistericon
> Total query runtime: 16345 ms.
> 738050 rows retrieved.
>
>
My first thought looking at the difference between the number given by
the analyse and the number given by (I presume) the client application
is that the transfer of the data between the server and the client
application is what's taking the time. Which would explain the near
constant total time for remote clients on different servers.

I presume there is some sort of id column on the table. What are the
execution times on the different servers for SELECT SUM(id) FROM
assetregistericon; ?