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: 41DD0862.5000305@cybertec.at (view raw or flat)
Thread:
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-2014 The PostgreSQL Global Development Group