public inbox for [email protected]
help / color / mirror / Atom feedslowness with holdable cursor
2+ messages / 2 participants
[nested] [flat]
* slowness with holdable cursor
@ 2006-04-12 09:33 Andrea Grassi <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Andrea Grassi @ 2006-04-12 09:33 UTC (permalink / raw)
To: pgsql-www
Hi.
I have a problem of fastness with "declare xxx cursor WITH HOLD". My
postgres version is 7.4.6
I have a table with 20000 rows named "base_a_artico"
If I use "declare a cursor with hold for select cdart,descr from
base_a_artico" outside a transaction I wait 2 seconds.
If I use the same statement (or the similar without "WITH HOLD") inside a
trasaction, I wait only 4 msec (milliseconds) !!!
I don't understand why this happens ....
I have to set some parameters in the postgresql.conf ?
thanks
Andrea Grassi
Le informazioni contenute in questo messaggio di posta elettronica sono di
natura confidenziale; qualsiasi pubblicazione, utilizzo o diffusione anche
parziale dello stesso non può essere effettuata senza autorizzazione e
potrebbe costituire un illecito penale ai sensi del Decreto Legs.vo N°
196/2003 sulla Protezione dei Dati Personali e del Codice Penale, Art.
617-621-635 bis oltre che della legge 547/93. Qualora non siate tra i
legittimi destinatari di questa e-mail Vi preghiamo cortesemente di
cancellarla dal Vostro sistema dopo aver notificato al mittente, rispondendo
alla comunicazione, l'errore da questi commesso.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: slowness with holdable cursor
@ 2006-04-12 10:15 Devrim GUNDUZ <[email protected]>
parent: Andrea Grassi <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Devrim GUNDUZ @ 2006-04-12 10:15 UTC (permalink / raw)
To: Andrea Grassi <[email protected]>; +Cc: pgsql-www
Hi,
On Wed, 2006-04-12 at 11:33 +0200, Andrea Grassi wrote:
> I have a problem of fastness with "declare xxx cursor WITH HOLD".
This list is intended for PostgreSQL.org website issues. Please ask your
question to another list.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-04-12 10:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-12 09:33 slowness with holdable cursor Andrea Grassi <[email protected]>
2006-04-12 10:15 ` Devrim GUNDUZ <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox