Re: create index does change pages?

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: mohsen soodkhah mohammadi <mohsensoodkhah(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create index does change pages?
Date: 2013-07-20 12:28:41
Message-ID: A3DC1C2F-A8EB-4F9C-BF94-00B96A2AB6C1@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sent from my iPad

On 20-Jul-2013, at 15:26, mohsen soodkhah mohammadi <mohsensoodkhah(at)gmail(dot)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 some extra memory for the auxiliary data structure, but there is no moving of the actual tuples.

Regards,

Atri

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kohei KaiGai 2013-07-20 13:47:11 Re: [v9.4] row level security
Previous Message Heikki Linnakangas 2013-07-20 12:22:47 Re: create index does change pages?