Le 15/11/2010 20:42, Chris Ruprecht a Ãcrit : > 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? No. A tablespace is a directory on PostgreSQL. And you can't allocate space for a directory. > If not, is this planned for any time in the future? AFAICT, nope. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
