Index behavior question

From: Dmitri Touretsky <dmitri(at)listsoft(dot)ru>
To: pgsql-novice(at)postgresql(dot)org
Subject: Index behavior question
Date: 2003-03-30 12:11:13
Message-ID: 83330367853.20030330161113@listsoft.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Good time of the day!

It might be that this question is for hackers group, but 'cause I'm
novice I've decided to ask here first :))

In the docs it's written that index changes every time update is done
to the table. But if I update the field which is not indexed - will
postgres spend much time on changing indexes?

The idea is that I have a large table with many indexes defined. The
table has much more selects, than updates or inserts. But in this
table there are few fields which do not require indexing, but needs to
be updates relatively often. Yet I want to keep selects as fast as
possible. And now I'm thinking if it worth to create a separate table
with foreign key defined for those fields...

--
Best regards,
Dmitri Touretsky ( dmitri(at)listsoft(dot)ru )

New SOFT daily (RUS): http://www.listsoft.ru/
(ENG): http://www.listsoft.com/
---
One man's error is another man's data.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Don Patou 2003-03-30 15:42:50 database2uml software
Previous Message Jens Eliasson 2003-03-29 08:32:05 Re: Postmaster.pid & Unix domain socket errors, OS X