O
O
Oleg Petrov2018-10-20 13:52:09
PostgreSQL
Oleg Petrov, 2018-10-20 13:52:09

What data types to choose for a new database to save space?

I plan to create a table in the database, in which to record 5000 quotes and their various parameters daily, as well as a table associated with it by a foreign key, which will contain the selected values.
What data types should be chosen so that the table in the database takes up the minimum amount of space?
What are the subtleties so that the database takes up a minimum amount of space?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2018-10-20
@melkij

You are probably confusing the concepts of base and table. Otherwise, it is not clear what you mean by talking about FK between bases.
If the goal is to optimize the occupied space for explicitly timeseries data, then use the base timeseries.
A full-fledged versioner with 23 bytes of overhead for just the header of each line (not yet starting to read the data, plus the alignment of structures) it is highly doubtful that it will turn out to be more compact than the database data oriented to timeseries.

V
Vyacheslav Uspensky, 2018-10-22
@Kwisatz

Of course, I'm sorry, but I still ask: why? volumes are insignificant.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question