Re: Does standalone postfrsql have autogrowth/ manual growth on table space?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Does standalone postfrsql have autogrowth/ manual growth on table space?
Дата
Msg-id 4829b4ef-430f-59cf-5143-b6754904ee16@gmail.com
обсуждение исходный текст
Ответ на Does standalone postfrsql have autogrowth/ manual growth on table space?  (Vince McMahon <sippingonesandzeros@gmail.com>)
Ответы Re: Does standalone postfrsql have autogrowth/ manual growth on table space?  (Rob Sargent <robjsargent@gmail.com>)
Re: Does standalone postfrsql have autogrowth/ manual growth on table space?  (Christophe Pettus <xof@thebuild.com>)
Список pgsql-general
Дерево обсуждения 
On 10/20/22 12:19, Vince McMahon wrote:
> In other databases, there is a way to preallocate the table space to allow 
> bulk loading of data in a well packed and continuous space.
>
>
> Does psql have that auto/manual growth?

There's no pre-allocation in Postgresql.  When you run CREATE TABLE, an (I 
think) 8KiB file is created; it grows as you add more data. When it hits 
1GiB in size, another table is created.  And then another and another and 
another, etc.

-- 
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: pg_restore 12 "permission denied for schema" errors
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Does standalone postfrsql have autogrowth/ manual growth on table space?