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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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