On 11/04/2014 16:45, Jack.O'sulli...@tessella.com wrote:
> With point two, does this mean that any table with a bytea datatype is
> limited to 4 billion rows (which would seem in conflict with the
> "unlimited rows" shown by http://www.postgresql.org/about)? If we had
> rows where the bytea was a
Jack.O'Sullivan wrote:
> I am working for a client who is interested in migrating from Oracle to
> Postgres. Their database is
> currently ~20TB in size, and is growing. The biggest table in this database
> is effectively a BLOB
> store and currently has around 1 billion rows.
>
> From reading a
hich is in
the BLOB type column. The particular client I'm doing this for uses the
compressed version, so all of their data in this table is binary.
Thanks
Jack
From: Andy Colson
To: Jack.O'sulli...@tessella.com, pgsql-general@postgresql.org,
Date: 11/04/2014 16:24
Subjec
On 4/11/2014 9:45 AM, Jack.O'sulli...@tessella.com wrote:
I am working for a client who is interested in migrating from Oracle to
Postgres. Their database is currently ~20TB in size, and is growing. The
biggest table in this database is effectively a BLOB store and currently
has around 1 billion
I am working for a client who is interested in migrating from Oracle to
Postgres. Their database is currently ~20TB in size, and is growing. The
biggest table in this database is effectively a BLOB store and currently
has around 1 billion rows.
>From reading around Postgres, there are a couple
