Pre-Allocate tablespace on disk
От
Chris Ruprecht
Тема
Pre-Allocate tablespace on disk
Дата
Msg-id
9CB65F11-6FA4-48D5-BCC5-B3F694659965@ruprecht.org
Список
Дерево обсуждения
Pre-Allocate tablespace on disk Chris Ruprecht <chris@ruprecht.org>
Re: Pre-Allocate tablespace on disk Guillaume Lelarge <guillaume@lelarge.info>
Re: Pre-Allocate tablespace on disk Craig James <craig_james@emolecules.com>
ignoring data type Octavio <octaviomaiden@yahoo.com>
Re: ignoring data type Samuel Stearns <SStearns@internode.com.au>
Re: ignoring data type Scott Marlowe <scott.marlowe@gmail.com>
Re: ignoring data type Octavio <octaviomaiden@yahoo.com>
Re: Pre-Allocate tablespace on disk Florian Weimer <fweimer@bfk.de>
Re: Pre-Allocate tablespace on disk Steve Francis <sfrancis@logicmonitor.com>
Re: Pre-Allocate tablespace on disk Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Hello, I was wondering if there is a way to pre-allocate tablespace on disk before adding data and indexes. My understanding is: PG writes data into files sequentially. If more space is needed, disk space is requested from the OS and if there is space, the OS will give PG a file system block and PG will write data/indexes until that block is full and so on. Other database that I have worked with before and that I'm still working with, allow you to pre-allocate disk space so you get huge chunks of contiguous space at one, which has major impacts on database performance. Can this be done with PG at all? If not, is this planned for any time in the future? best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre
В списке pgsql-admin по дате отправления
