From: PFC <lists@boutiquenumerique.com>
To: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: SELECT very slow
Date: Wed, 15 Jun 2005 22:04:08 +0200
Message-ID: <op.ssfgo6xath1vuj@localhost> (raw)
In-Reply-To: <d8pqbi$a5q$1@sea.gmane.org>
References: <d87ood$8vq$1@sea.gmane.org>
<d8pqbi$a5q$1@sea.gmane.org>
<op.ssc0t7wrth1vuj@localhost>
> It's not the program or Java. The same program takes about 20 seconds
> with Firebird and the exactly same data.
Hm, that's still very slow (it should do it in a couple seconds like my
PC does... maybe the problem is common to postgres and firebird ?)
Try eliminating disk IO by writing a set returning function which returns
1000000 rows, something simple like just a sequence number and a text
value... if this is slow too... i don't know... do you have an antivirus
or zonealarm or something ?
Have you tried connecting from another machine ?
>
> Thomas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
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: lists@boutiquenumerique.com, spam_eater@gmx.net
Subject: Re: SELECT very slow
In-Reply-To: <op.ssfgo6xath1vuj@localhost>
* 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