Re: DB Files

On 11/15/24 06:27, Andy Hartman wrote:
> I created a  new table (V16) and then used SimplySql to take data from 
> mssql to the new Postgres table. The table is 212gig in size. Myquestion 
> comes from the files created on the OS(Windows2022 server) I can see 
> lots of files with the last being:
> 
> 2474695.143
> 
> They are all 1,048,576kb
> 
> Is this normal behaviour and could I have done something to use fewer 
> files and larger ones?

Read:

https://www.postgresql.org/docs/current/storage-file-layout.html

[...]

"When a table or index exceeds 1 GB, it is divided into gigabyte-sized 
segments. The first segment's file name is the same as the filenode; 
subsequent segments are named filenode.1, filenode.2, etc. This 
arrangement avoids problems on platforms that have file size 
limitations. (Actually, 1 GB is just the default segment size. The 
segment size can be adjusted using the configuration option 
--with-segsize when building PostgreSQL.) In principle, free space map 
and visibility map forks could require multiple segments as well, though 
this is unlikely to happen in practice."

[...]

> 
> 
> This table is created in a separate tablespace on a dedicated drive on 
> the windows file system.
> 
>   I'm just getting involved in this PostgreSql instance
> 
> THanks.

-- 
Adrian Klaver
adrian.klaver@aklaver.com