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 |