Skip site navigation (1) Skip section navigation (2)

Re: File Groups with postgresql

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: "Segree, Gareth" <Gareth(dot)Segree(at)gleanerjm(dot)com>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: File Groups with postgresql
Date: 2005-01-06 09:44:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Segree, Gareth wrote:

> I'm not sure if this is the right forum for this question, but here goes.
> I am trying to create a database with a preallocated amount of storage 
> (eg. Filegroups in SQL Server).
> Is this possible with postgresql or is there an equivalent.
> Gareth Segree
> _mailto:Gareth(dot)Segree(at)gleanerjm(dot)com_
> Technical Support Analyst
> The Gleaner Company Ltd.
> 7 North Street
> Kingston
> Tel: 922-3400

No, PostgreSQL is not pre-allocating space.
This is definitely not a bug.
If you want that you should use a separate filesystem partition which 
can grow on demand.

    Best regards,

       Hans-Juergen Schoenig

In response to

pgsql-bugs by date

Next:From: Tom HebbronDate: 2005-01-06 21:29:02
Subject: tsearch2 headline function fails to parse integer arguments
Previous:From: Hansjörg HerrboldDate: 2005-01-06 08:23:24
Subject: ODBC / startup and existing pidfile

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group