AW: Big 7.1 open items
От | Zeugswetter Andreas SB |
---|---|
Тема | AW: Big 7.1 open items |
Дата | |
Msg-id | 219F68D65015D011A8E000006F8590C605BA5976@sdexcsrv1.f000.d0188.sd.spardat.at обсуждение исходный текст |
Список | pgsql-hackers |
> OK, to get back to the point here: so in Oracle, tables can't cross > tablespace boundaries, This is only true if you don't insert more coins and buy the Partitioning Option, or you use those coins to switch to Informix. > but a tablespace itself could span multiple > disks? Yes > > Not sure if I like that better or worse than equating a tablespace > with a directory (so, presumably, all the files within it live on > one filesystem) and then trying to make tables able to span > tablespaces. We will need to do one or the other though, if we want > to have any significant improvement over the current state of affairs > for large tables. You can currently use a union all view and write appropriate rules for insert, update and delete in Postgresql. This has the only disadvantage, that Partitions (fragments, table parts) cannot be optimized away, but we could fix that if we fixed the optimizer to take check constraints into account (like check (year = 2000) and select * where year=1999). Andreas
В списке pgsql-hackers по дате отправления: