On 10/20/22 11:29, Ron wrote:
On 10/20/22 12:19, Vince McMahon wrote:Another "file" is created, I think you mean
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.