"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