creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)
От
Vlad
Тема
creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)
Дата
Msg-id
cd70c6810612131457j173aa4cds9a058f040c0c17a3@mail.gmail.com
Список
Дерево обсуждения
creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5) Vlad <marchenko@gmail.com>
Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5) Tom Lane <tgl@sss.pgh.pa.us>
Temp file space (Re: creating an index with tablespace on a dedicated
filesystem) Glen Parker <glenebob@nwlink.com>
Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem) Tom Lane <tgl@sss.pgh.pa.us>
Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem) Vlad <marchenko@gmail.com>
Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem) Tom Lane <tgl@sss.pgh.pa.us>
Re: Temp file space (Re: creating an index with tablespace Glen Parker <glenebob@nwlink.com>
Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5) Vlad <marchenko@gmail.com>
Hello, we use tablespace feature to keep indexes on a dedicated raid array (for performance). What I've noticed is that when the index were created, based on the i/o activity it seemed that postgres was creating the index file somewhere on the array where the default table space is hosted and the data is stored. Then, when the index was completed, it moved index file to array for indexes. If my observation is accurate, and it really works this way, then it's definitely point for improvement imho... -- Vlad
В списке pgsql-general по дате отправления
От: Tom Lane
Дата: