Postgres Pro
Downloads
Home   >   mailing lists

Partitioning with FDW and table size limits - Mailing list pgsql-general

From Godfrin, Philippe E
Subject Partitioning with FDW and table size limits
Date
Msg-id SA0PR15MB393313CE4396B701BB74803382CF0@SA0PR15MB3933.namprd15.prod.outlook.com
Whole thread Raw
List pgsql-general
Tree view

Greetings,

In the case where you have a ‘local’ server, from which you are working with foreign tables. And the foreign tables are partitioned. As each of the partitioned tables is a table in its own right, is it correct to assume the table (relation) size limit of 32 TB applies? For example, provided I had the disk space, with 10 partitioned tables, I could have 320TB of data on 1 or more remote servers.

Am I correct?

Thanks,

phil

 

Phil Godfrin | Database Administrator

NOV

NOV US | Engineering Data

9720 Beechnut St | Houston, Texas 77036

M  281.825.2311

E   Philippe.Godfrin@nov.com

 

pgsql-general by date:

Previous
From: electrotype
Date:
Subject: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?
Next
From: 孙冰
Date:
Subject: Re: The hidden cost of limit-offset