Question : My current storage engine is WiredTiger and its compression level is as default, snappy. I’ve come across MongoDB […]
Tag: compression
What is the different between compression on the PK vs. on the Table?
Question : Data compression can be set on the table: CREATE TABLE dbo.SomeTable( SomeId [bigint] NOT NULL, OtherId [bigint] NOT […]
Cancelling the rebuilding of a partition with compression
Question : Trying to enable compression on a large table in production but we are now out of time (been […]
change journalCompressor to none – not default snappy
Question : Quote from ObjectRocket Support Hi, Fyodor! The journalCompressor setting is specifically related to the journal files. Journals are […]
How to decrypt zipped data in MSSQL table
Question : This question was migrated to Database Administrators Meta Stack Exchange, our site for discussion, support, and feature requests […]
Compress PostgreSQL Database
Question : I have a large PostgreSQL database over 500GB in size which is too large. Is there anyway to […]
Question on compression for very large tables in sql server
Question : I have a confusion on how this compression feature works in SQL server: For quite some large tables […]
ALTER innoDB table from row to page compression
Question : My tables have been created with InnoDB row compression (ENGINE=InnoDB ROW_FORMAT=COMPRESSED). Now I am changing them to page […]
Find Uncompressed/Compressed Sizes of TimescaleDB Database/Table
Question : For a database/table in TimescaleDB and PostgreSQL 11 running on ZFS with both ZFS compression and native TimescaleDB […]
What is the most effective way to compress and store a SQL Server backup? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]