Orignally there were but in the process of trying to figure out what is going on I stripped everything out of the database except the table being queried.
> > "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 4: Don't 'kill -9' the postmaster