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
