On Mon, 5 Aug 2019, 18:57 Kenneth Marshall, wrote:
> > >Hi,
> > >
> > >On RHEL/Centos you can use VDO filesystem compression to make an archive
> > >tablespace to use for older data. That will compress everything.
> >
> > Doesn't this imply that either his table is partitioned or he
> > regularly
> >Hi,
> >
> >On RHEL/Centos you can use VDO filesystem compression to make an archive
> >tablespace to use for older data. That will compress everything.
>
> Doesn't this imply that either his table is partitioned or he
> regularly moves records from the main table to the archive table?
>
Hi,
On 8/5/19 7:31 AM, Kenneth Marshall wrote:
On Mon, Aug 05, 2019 at 12:00:14PM +0530, Shital A wrote:
Hello,
Need inputs on below:
We are working on a setting up a new highly transactional (tps 100k) OLTP
system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
Postgres versio
On Mon, Aug 05, 2019 at 12:00:14PM +0530, Shital A wrote:
> Hello,
>
> Need inputs on below:
>
> We are working on a setting up a new highly transactional (tps 100k) OLTP
> system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
> Postgres version is 9.6 and not latest because
> because of specs of blockchain component.
Based on this schema (
https://grisha.org/blog/2017/12/15/blockchain-and-postgres/ AND
https://github.com/blkchain/pg_blkchain )
and
IF (your) blockchain component is using BYTEA everywhere ( binary data
type : https://www.postgresql.org/docs/9.6/dat
On Mon, 5 Aug 2019, 12:42 Ron, wrote:
> On 8/5/19 1:30 AM, Shital A wrote:
> > Hello,
> >
> > Need inputs on below:
> >
> > We are working on a setting up a new highly transactional (tps 100k)
> OLTP
> > system for payments using blockchain and postgresql 9.6 as DB on Rhel
> 7.6.
> > Postgres ver
On 8/5/19 1:30 AM, Shital A wrote:
Hello,
Need inputs on below:
We are working on a setting up a new highly transactional (tps 100k) OLTP
system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
Postgres version is 9.6 and not latest because of specs of blockchain
component
Hello,
Need inputs on below:
We are working on a setting up a new highly transactional (tps 100k) OLTP
system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
Postgres version is 9.6 and not latest because of specs of blockchain
component.
There is a requirement for data compr
