"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.

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

Reply via email to