public inbox for [email protected]  

help / color / mirror / Atom feed

From: Torsten Förtsch <[email protected]>
To: Andy Hartman <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: DB Files
Date: Fri, 15 Nov 2024 16:49:38 +0100
Message-ID: <CAKkG4_m9YA0kqaLMedzhfAG+hrYJa76pWzKB0_r9708ZiVXKRw@mail.gmail.com> (raw)
In-Reply-To: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>
References: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>

PG normally splits table data into 1GB chunks. The number before the dot is
called the filenode. You can translate it into a table name by

select oid::regclass::text from pg_class where relfilenode='2474695';

I believe there is an option to change that chunk size but you'd have to
recompile Postgres. The setting you need to change is called segment_size.

See https://www.postgresql.org/docs/current/runtime-config-preset.html

On Fri, Nov 15, 2024 at 3:27 PM Andy Hartman <[email protected]>
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?
>
>
> 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.
>

view thread (2+ messages)

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: <CAKkG4_m9YA0kqaLMedzhfAG+hrYJa76pWzKB0_r9708ZiVXKRw@mail.gmail.com>

* 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