Re: inheritance. more.
| От | Jeremy Harris |
|---|---|
| Тема | Re: inheritance. more. |
| Дата | |
| Msg-id | 4819BF74.6000001@wizmail.org обсуждение исходный текст |
| Ответ на | Re: inheritance. more. ("Gurjeet Singh" <singh.gurjeet@gmail.com>) |
| Ответы |
Re: inheritance. more.
|
| Список | pgsql-general |
Gurjeet Singh wrote:
> One of the advantages
> of breaking up your data into partitions, as professed by Simon (I think)
> (and I agree), is that you have smaller indexes, which improve performance.
> And maybe having one huge index managing the uniqueness across partitioned
> data just defeats the idea of data partitioning!
Isn't "large indexes are a performance problem" just saying
"we don't implement indexes very well"? And why are they
a problem - surely a tree-structured index is giving you
range-partitioned subsets as you traverse it? Why is this
different from manual partitioning into (inherited) tables?
Thanks,
Jeremy
В списке pgsql-general по дате отправления: