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

From Atri Sharma
Subject Re: create index does change pages?
Date
Msg-id A3DC1C2F-A8EB-4F9C-BF94-00B96A2AB6C1@gmail.com
Whole thread Raw
In response to create index does change pages?  (mohsen soodkhah mohammadi <mohsensoodkhah@gmail.com>)
List pgsql-hackers

Sent from my iPad

On 20-Jul-2013, at 15:26, mohsen soodkhah mohammadi <mohsensoodkhah@gmail.com> wrote:

> hello.
> dose one create index on the large table changes the place of some tuples in some pages?


No, making an index involves keeping some metadata about your tables in an auxiliary data structure. It will require
someextra memory for the auxiliary data structure, but there is no moving of the actual tuples. 

Regards,

Atri


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: create index does change pages?
Next
From: Kohei KaiGai
Date:
Subject: Re: [v9.4] row level security