public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Andy Hartman <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: DB Files
Date: Fri, 15 Nov 2024 07:47:41 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>
References: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>

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
[email protected]

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: DB Files
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox