Re: View index question - Mailing list pgsql-general

From u15074
Subject Re: View index question
Date
Msg-id 1059474258.3f264b52357f5@webmail.hs-harz.de
Whole thread Raw
In response to Re: View index question  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Zitat von Peter Eisentraut <peter_e@gmx.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/


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: View index question
Next
From: Andreas Jung
Date:
Subject: concurrent writes