| From: | Matthew Peter <survivedsushi(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | inherits index |
| Date: | 2006-01-02 08:06:15 |
| Message-ID: | 20060102080615.47677.qmail@web35207.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a parent table that is inherited by a couple others... Would it be best to set up an index on the children tables column that is inherited by the parent, or should I index the parent column that is inherited by the children? The children tables are the ones called frequently, not the parent. I just want to help the planner to use the most effective way by setting it up properly for parsing, especially if these tables get really big.
Thanks, Matt
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dobóczy Ákos | 2006-01-02 09:18:50 | Postgre sql win32 silent install |
| Previous Message | Rajendra Talekar | 2006-01-02 06:21:27 | Need Licensing Information for bundling POSTGRESQL With Softwares |