agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedPostgres size greater than 1TB
4+ messages / 3 participants
[nested] [flat]
* Postgres size greater than 1TB
@ 2018-12-13 16:33 Rossi, Maria <maria.rossi@jackson.com>
0 siblings, 2 replies; 4+ messages in thread
From: Rossi, Maria @ 2018-12-13 16:33 UTC (permalink / raw)
To: 'pgsql-sql@lists.postgresql.org' <pgsql-sql@lists.postgresql.org>; 'pgsql-novice@lists.postgresql.org' <pgsql-novice@lists.postgresql.org>
Hi,
In the past, our postgres cluster data_directory is a file system that is < 1TB
Our postgresconf.cfg has this:
data_directory = '/dba/psg/gp08/pg_data'
Now, we need a new cluster that needs more than 1TB (Unix has a limit of 1TB for file systems)
Any suggestion on how to handle this?
Can I specify more than 1 path in my data_directory?
Can I create a tablespace in a new file system/directory?
Any help would be appreciated.
Thanks
Maria
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres size greater than 1TB
@ 2018-12-13 16:36 Jesper Krogh <jesper@krogh.cc>
parent: Rossi, Maria <maria.rossi@jackson.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jesper Krogh @ 2018-12-13 16:36 UTC (permalink / raw)
To: Rossi, Maria <maria.rossi@jackson.com>; +Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>; pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
> On 13 Dec 2018, at 17.33, Rossi, Maria <maria.rossi@jackson.com> wrote:
>
> Hi,
>
> In the past, our postgres cluster data_directory is a file system that is < 1TB
>
> Our postgresconf.cfg has this:
>
> data_directory = '/dba/psg/gp08/pg_data'
>
> Now, we need a new cluster that needs more than 1TB (Unix has a limit of 1TB for file systems)
> Any suggestion on how to handle this?
we have filesystems above 100TB. where do you see this limit?
Jesper =
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres size greater than 1TB
@ 2018-12-13 16:38 Steve Midgley <science@misuse.org>
parent: Rossi, Maria <maria.rossi@jackson.com>
1 sibling, 1 reply; 4+ messages in thread
From: Steve Midgley @ 2018-12-13 16:38 UTC (permalink / raw)
To: maria.rossi@jackson.com; +Cc: pgsql-sql@lists.postgresql.org; pgsql-novice@lists.postgresql.org
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria.rossi@jackson.com>
wrote:
> Hi,
>
>
>
> In the past, our postgres cluster data_directory is a file system that is
> < 1TB
>
>
>
> Our postgresconf.cfg has this:
>
>
>
> data_directory = '/dba/psg/gp08/pg_data'
>
>
>
> Now, we need a new cluster that needs more than 1TB (Unix has a limit of
> 1TB for file systems)
>
> Any suggestion on how to handle this?
>
> Can I specify more than 1 path in my data_directory?
>
> Can I create a tablespace in a new file system/directory?
>
1TB seems incredibly small these days as a file system limit - as Jesper
says. If you're on a disk partition system with 1TB file limits (let alone
for the whole file system!), you should consider upgrading your disk array
and file system to a modern partition scheme, of which there are many
choices on Linux/Unix type systems.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Postgres size greater than 1TB
@ 2018-12-13 16:51 Rossi, Maria <maria.rossi@jackson.com>
parent: Steve Midgley <science@misuse.org>
0 siblings, 0 replies; 4+ messages in thread
From: Rossi, Maria @ 2018-12-13 16:51 UTC (permalink / raw)
To: Steve Midgley <science@misuse.org>; +Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>; pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Sorry, my mistake. Should have asked our Unix support first, before I posted.
Was told 1TB limit is old, we don’t have that issue now.
Sorry.
Maria
From: Steve Midgley <science@misuse.org>
Sent: Thursday, December 13, 2018 11:38 AM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: pgsql-sql@lists.postgresql.org; pgsql-novice@lists.postgresql.org
Subject: Re: Postgres size greater than 1TB
EXTERNAL EMAIL
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.com>> wrote:
Hi,
In the past, our postgres cluster data_directory is a file system that is < 1TB
Our postgresconf.cfg has this:
data_directory = '/dba/psg/gp08/pg_data'
Now, we need a new cluster that needs more than 1TB (Unix has a limit of 1TB for file systems)
Any suggestion on how to handle this?
Can I specify more than 1 path in my data_directory?
Can I create a tablespace in a new file system/directory?
1TB seems incredibly small these days as a file system limit - as Jesper says. If you're on a disk partition system with 1TB file limits (let alone for the whole file system!), you should consider upgrading your disk array and file system to a modern partition scheme, of which there are many choices on Linux/Unix type systems.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-12-13 16:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-12-13 16:33 Postgres size greater than 1TB Rossi, Maria <maria.rossi@jackson.com>
2018-12-13 16:36 ` Jesper Krogh <jesper@krogh.cc>
2018-12-13 16:38 ` Steve Midgley <science@misuse.org>
2018-12-13 16:51 ` Rossi, Maria <maria.rossi@jackson.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox