Should I keep INDEX on the table?
От | Rajan Bhide |
---|---|
Тема | Should I keep INDEX on the table? |
Дата | |
Msg-id | FF851C7EEB75954F9BCFB5CA117AB1ECFC321C@delta.nulinkinc.com обсуждение исходный текст |
Ответы |
Re: Should I keep INDEX on the table?
|
Список | pgsql-novice |
Hello Forum, I am having a table with UNIQUE constraints defined on three columns. Also I have UNIQUE user defined INDEX with the same columns on the table. The postgres documentation mentions that the user defined INDEX is just the duplication if the table has PRIMARY Key or UNIQUE key constraints with same columns. http://www.postgresql.org/docs/7.4/static/indexes-unique.html I require suggestion whether to keep the (duplicate?) used defined INDEX on the table or remove it. The problem on removing the index is that my table has almost 2M transtions in approx ~4 Hours and I need to perform external reindexing (DROP and CREATE INDEX) every 2 Hours to reclaim the dead space left behind by the deleted rows. If I remove the INDEX from the table will my client work without performing external reindexing? System Info: SunOS firerunner 5.9 Generic_112233-01 sun4u sparc SUNW,UltraAX-i2 Memory size: 1024 Megabytes Postgres Version : 7.4.1 Thanks, Rajan Bhide
В списке pgsql-novice по дате отправления: