"Medora Schauer" <mschauer@fairfield.com> 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.
Are there any foreign key linkages to or from this table? Maybe the
other end of the foreign key is float8?
regards, tom lane