public inbox for [email protected]  

help / color / mirror / Atom feed

DB Files
2+ messages / 2 participants
[nested] [flat]

* DB Files
@ 2024-11-15 14:27 Andy Hartman <[email protected]>
  2024-11-15 15:49 ` Re: DB Files Torsten Förtsch <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Andy Hartman @ 2024-11-15 14:27 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: DB Files
  2024-11-15 14:27 DB Files Andy Hartman <[email protected]>
@ 2024-11-15 15:49 ` Torsten Förtsch <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Torsten Förtsch @ 2024-11-15 15:49 UTC (permalink / raw)
  To: Andy Hartman <[email protected]>; +Cc: [email protected] <[email protected]>

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.
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-11-15 15:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-15 14:27 DB Files Andy Hartman <[email protected]>
2024-11-15 15:49 ` Torsten Förtsch <[email protected]>

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