| From: | Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | (Re)-indexing on updates |
| Date: | 2005-08-21 18:32:31 |
| Message-ID: | ba89fec2b148abbc137d9a9b8e2832c7@implements.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
Say I have a table with column A, B, C, D
A has a unique index on it (primary key)
B and C have a normal index on it
D has no index
If I perform a query like update tbl set D = 'whatever' ;
that should make no difference on the indexes on the other columns,
right ?
Or is there some kind of mechanism that does create a sort of new
record, thus makes the indexes go wild.
Met vriendelijke groeten,
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
| Attachment | Content-Type | Size |
|---|---|---|
| Pasted Graphic 2.tiff | image/tiff | 5.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey W. Baker | 2005-08-21 19:06:05 | Re: (Re)-indexing on updates |
| Previous Message | John A Meinel | 2005-08-21 15:51:52 | Re: extremly low memory usage |