From: | "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com> |
---|---|
To: | Steve Midgley <science(at)misuse(dot)org> |
Cc: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Postgres size greater than 1TB |
Date: | 2018-12-13 16:51:02 |
Message-ID: | de82d95e313d41919a6320bf4fa73cd2@DC03PXMBP003.jacksonnational.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
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(at)misuse(dot)org>
Sent: Thursday, December 13, 2018 11:38 AM
To: Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org; pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres size greater than 1TB
EXTERNAL EMAIL
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria(dot)rossi(at)jackson(dot)com<mailto:maria(dot)rossi(at)jackson(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Brisson | 2018-12-14 18:50:42 | Changing Pl/Python default interpreter |
Previous Message | Steve Midgley | 2018-12-13 16:38:00 | Re: Postgres size greater than 1TB |
From | Date | Subject | |
---|---|---|---|
Next Message | Shekar Tippur | 2018-12-13 16:51:59 | Changing csv structure and corresponding etl |
Previous Message | Steve Midgley | 2018-12-13 16:38:00 | Re: Postgres size greater than 1TB |