Re: update problem? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: update problem?
Date
Msg-id 20020709094640.W39520-100000@megazone23.bigpanda.com
Whole thread Raw
In response to update problem?  ("Juergen G. Mischke" <jgmischke@j-g-m.de>)
Responses Re: update problem?  (Jürgen Mischke <jgmischke@j-g-m.de>)
List pgsql-general
On Tue, 9 Jul 2002, Juergen G. Mischke 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?

Does the table have any foreign key constraints or other
tables that reference it in foreign key constraints?  What's
the schema of the table?



pgsql-general by date:

Previous
From: Robert L Mathews
Date:
Subject: Re: Query Casting Help
Next
From: "Marc G. Fournier"
Date:
Subject: Re: I am being interviewed by OReilly