| From: | "Medora Schauer" <mschauer(at)fairfield(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "postgresql" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Odd performance results |
| Date: | 2003-07-31 21:32:16 |
| Message-ID: | 906E2C446A276048A1BE283F17BCB12CB131EA@encounter.fairind.fairfield.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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" <mschauer(at)fairfield(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-07-31 22:24:11 | Views With Unions |
| Previous Message | Manfred Koizar | 2003-07-31 21:32:04 | Re: Help on my database performance |