Обсуждение: File Groups with postgresql

Поиск
Список
Период
Сортировка

File Groups with postgresql

От
"Segree, Gareth"
Дата:
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.Segree@gleanerjm.com <mailto:Gareth.Segree@gleanerjm.com>
Technical Support Analyst
The Gleaner Company Ltd.
7 North Street
Kingston
Tel: 922-3400

Re: File Groups with postgresql

От
Hans-Jürgen Schönig
Дата:
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.Segree@gleanerjm.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