pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWaiting for Update
2+ messages / 2 participants
[nested] [flat]
* Waiting for Update
@ 2002-07-09 07:04 JGM <jgmischke@j-g-m.de>
0 siblings, 1 reply; 2+ messages in thread
From: JGM @ 2002-07-09 07:04 UTC (permalink / raw)
To: pgsql-sql
Could it be true??
I've a table with < 46000 rows. And a little Update like
UPDATE foo set xxx = 'X';
needs about 15 seconds???
What's wrong?
Greetings
Juergen
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Waiting for Update
@ 2002-07-10 15:27 Jan Wieck <JanWieck@Yahoo.com>
parent: JGM <jgmischke@j-g-m.de>
0 siblings, 0 replies; 2+ messages in thread
From: Jan Wieck @ 2002-07-10 15:27 UTC (permalink / raw)
To: JGM <jgmischke@j-g-m.de>; +Cc: pgsql-sql
JGM wrote:
>
> Could it be true??
>
> I've a table with < 46000 rows. And a little Update like
>
> UPDATE foo set xxx = 'X';
>
> needs about 15 seconds???
>
> What's wrong?
How long since you vacuumed that table? How big are the rows? Are there
triggers, constraints, anything fancy? How many indexes does foo have?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-10 15:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-09 07:04 Waiting for Update JGM <jgmischke@j-g-m.de>
2002-07-10 15:27 ` Jan Wieck <JanWieck@Yahoo.com>
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