"Medora Schauer" <[EMAIL PROTECTED]> writes:
> I have a table with a 3 column key. I noticed that when I update a non-key field
> in a record of the table that the update was taking longer than I thought it
> should. After much experimenting I discovered that if I changed the data
> types of two of the key columns to FLOAT8 that I got vastly improved
> performance.
Advertising
Are there any foreign key linkages to or from this table? Maybe the
other end of the foreign key is float8?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
