MIME-Version: 1.0
References: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>
In-Reply-To: <CAEZv3coR69Kjtnd1oDpp-AhwQOrWcW7_4CMH0JQLFcndoP-Q0g@mail.gmail.com>
From: =?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.com>
Date: Fri, 15 Nov 2024 16:49:38 +0100
Message-ID: <CAKkG4_m9YA0kqaLMedzhfAG+hrYJa76pWzKB0_r9708ZiVXKRw@mail.gmail.com>
Subject: Re: DB Files
To: Andy Hartman <hartman60home@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005dd9380626f58477"
Archived-At: <https://www.postgresql.org/message-id/CAKkG4_m9YA0kqaLMedzhfAG%2BhrYJa76pWzKB0_r9708ZiVXKRw%40mail.gmail.com>
Precedence: bulk

--0000000000005dd9380626f58477
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=3D'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=E2=80=AFPM Andy Hartman <hartman60home@gmail.c=
om>
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 th=
e
> windows file system.
>
>  I'm just getting involved in this PostgreSql instance
>
> THanks.
>

--0000000000005dd9380626f58477
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">PG normally splits table data into 1GB chunks. The number =
before the dot is called the filenode. You can translate it into a table na=
me by<div><br></div><div>select oid::regclass::text from pg_class where rel=
filenode=3D&#39;2474695&#39;;</div><div><br></div><div>I believe there is a=
n option to change that chunk size but you&#39;d have to recompile Postgres=
. The setting you need to change is called segment_size.</div><div><br></di=
v><div>See=C2=A0<a href=3D"https://www.postgresql.org/docs/current/runtime-=
config-preset.html">https://www.postgresql.org/docs/current/runtime-config-=
preset.html</a></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Fri, Nov 15, 2024 at 3:27=E2=80=AFPM Andy Hartman &=
lt;<a href=3D"mailto:hartman60home@gmail.com">hartman60home@gmail.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr"><div dir=3D"ltr">I created a=C2=A0 new table (V16) and then used=
 SimplySql to take data from mssql=C2=A0to the new Postgres table. The tabl=
e is 212gig in size. Myquestion comes from the files created on the OS(Wind=
ows2022 server) I can see lots of files with the last being:<br><br>2474695=
.143</div><div dir=3D"ltr"><br></div><div>They are all 1,048,576kb=C2=A0<br=
><br>Is this normal behaviour and could I have done something to use fewer =
files and larger ones?<br><br><br>This table is created in a separate=C2=A0=
tablespace on a dedicated=C2=A0drive on the windows file system.<br><br>=C2=
=A0I&#39;m just getting involved in this PostgreSql instance=C2=A0<br><br>T=
Hanks.</div></div>
</blockquote></div>

--0000000000005dd9380626f58477--