From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: SELECT very slow
Date: Wed, 15 Jun 2005 20:05:28 +0200
Message-ID: <d8pqbi$a5q$1@sea.gmane.org> (raw)
In-Reply-To: <op.ssc0t7wrth1vuj@localhost>
References: <d87ood$8vq$1@sea.gmane.org>
<op.ssc0t7wrth1vuj@localhost>
PFC wrote on 14.06.2005 14:26:
[...]
> Now I fire up python, do a SELECT * from the table and retrieve all
> the data as native objects... Hm, it takes about 1.3 seconds... on my
> Pentium-M 1600 laptop...
>
> Don't you have a problem somewhere ? Are you sure it's not swapping
> ? did you check memory ? Are you transferring all this data over the
> network ? Might an obscure cabling problem have reverted your
> connection to 10 Mbps ?
I'm sure. Everything is running on the same machine, about 350 MB free memory.
> Ouch. I saw you're on Windows so I tried it on the windows machine
> there which has a postgres installed, over a 100Mbps network, querying
> from my linux laptop. The windows machine is a piece of crap,
> Pentium-II 300 and 256 MB Ram, it takes 7 seconds to retrieve the whole
> table in a python native object.
>
It's not the program or Java. The same program takes about 20 seconds with
Firebird and the exactly same data.
Thomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: SELECT very slow
In-Reply-To: <d8pqbi$a5q$1@sea.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox