| From: | u15074 <u15074(at)hs-harz(dot)de> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: View index question |
| Date: | 2003-07-29 10:24:18 |
| Message-ID: | 1059474258.3f264b52357f5@webmail.hs-harz.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Zitat von Peter Eisentraut <peter_e(at)gmx(dot)net>:
> u15074 writes:
>
> > Each of the tables in each scheme will store a lot rows. That is also why
> I
> > decided to split the tables over the schemes.
>
> This is absolutely pointless. Splitting a table over several schemas will
> have no effect on performance or storage (except possibly making
> everything slower because the planner gets confused).
>
Yes, you are right. But I also splitted the tables for logical reasons.
Maybe I will change this. Than I also won't need the views.
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Jung | 2003-07-29 10:33:06 | concurrent writes |
| Previous Message | Peter Eisentraut | 2003-07-29 10:15:03 | Re: View index question |