[HACKERS] create index does change pages?

2013-07-20 Thread mohsen soodkhah mohammadi 
hello.
dose one create index on the large table changes the place of some tuples
in some pages?

Re: [HACKERS] create index does change pages?

2013-07-20 Thread Heikki Linnakangas 

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


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] create index does change pages?

2013-07-20 Thread Atri Sharma 


Sent from my iPad

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

Regards,

Atri

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers