Postgres Pro
Downloads
Home   >   mailing lists

Re: create index does change pages? - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: create index does change pages?
Date
Msg-id 51EA8117.9010804@vmware.com
Whole thread Raw
In response to create index does change pages?  (mohsen soodkhah mohammadi <mohsensoodkhah@gmail.com>)
List pgsql-hackers
Tree view 
On 20.07.2013 12:56, mohsen soodkhah mohammadi wrote:
> hello.
> dose one create index on the large table changes the place of some tuples
> in some pages?

No, creating an index doesn't move any tuples in the heap.

- Heikki

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: confusing typedefs in jsonfuncs.c
Next
From: Atri Sharma
Date:
Subject: Re: create index does change pages?