Re: primary/secondary index, difference
От | Thalis A. Kalfigopoulos |
---|---|
Тема | Re: primary/secondary index, difference |
Дата | |
Msg-id | Pine.LNX.4.21.0106181107000.19889-100000@aluminum.cs.pitt.edu обсуждение исходный текст |
Ответ на | Re: primary/secondary index, difference (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: primary/secondary index, difference
|
Список | pgsql-general |
I was under the impression that primary index is the same as clustered index i.e. the order in the index matches the physicalorder the records are stored on disk thus making it better when doing sequential accesses. I assume that this is exactly the use of the CLUSTER command, to actually make a primary index. T/F? TIA, thalis On Sun, 17 Jun 2001, Peter Eisentraut wrote: > zilch@home.se writes: > > > What is the difference between a primary and a secondary index? > > None, neither exists. All indexes are just indexes. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: