pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: PFC <lists@boutiquenumerique.com>
To: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: SELECT very slow
Date: Thu, 16 Jun 2005 17:29:32 +0200
Message-ID: <op.ssgyniecth1vuj@localhost> (raw)
In-Reply-To: <d8s30h$r12$1@sea.gmane.org>
References: <d87ood$8vq$1@sea.gmane.org>
	<d8s30h$r12$1@sea.gmane.org>
	<1118930439.3382.91.camel@state.g2switchworks.com>
	<d8q8iq$pfg$1@sea.gmane.org>
	<op.ssfgo6xath1vuj@localhost>
	<op.ssc0t7wrth1vuj@localhost>
	<d8pqbi$a5q$1@sea.gmane.org>



> If autocommit is on (or fetch size is zero) then the driver will build  
> the whole
> result set before returning to the caller.

	Sure, but that is not your problem : even building the whole result set  
should not take longer than a few seconds (I gave you test timings in a  
previous message).
	So... what ?
	What does the taskman say ? CPU at 100% ? how much kernel time ?

>
> http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
>
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

view thread (19+ messages)  latest in thread

Message-ID: <op.ssgyniecth1vuj@localhost>
Permalink:  ../op.ssgyniecth1vuj@localhost/
Also on:    postgresql.org/message-id/op.ssgyniecth1vuj@localhost

copy link · copy postgr.es

reply

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.ssgyniecth1vuj@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