Questions tagged [Partitioning and database shuffling] (17)

0
answer

How to make a dump protezirovanie in PostgreSql?

Hi all. What we have: Database with lots of tables (part protezirovanija) What we do: Try to do a dump using pg_dump with the following command (table protezirovanija) pg_dump -t table_name --encoding=utf8-v > dump.sql Problem: In the dump do not get the partition and the data from them, and it is necessary to fell Qu...
Creola95 asked April 8th 20 at 02:02
1
answer

Database Is Postgresql. Whether a workable scheme of sharding?

The B2B project. Accordingly, all perfectly Karditsa for client_id. Sharding configured in the application immediately in any case - may not be necessary, but better to let it be. Database is postgresql. The shard is a separate database with 200-250 firms (for 5-100 users in each), then if that can be added. To go into the ...
Kenyon_Cruickshan asked April 4th 20 at 00:43
3
answers

Will effectively partitioning in PostgreSQL in the case that the principle of splitting the table into sections and the selection criteria are not the same?

Hello! When working with a table of medium size (tens of thousand records) it turned out that some requests are long enough. To expedite the selection decided to include partitioning in this table. But there was a following problem. The fact that the selection criteria of records from the table is that it does not coincide ...
rosalyn_Feeney82 asked April 2nd 20 at 15:13
1
answer

Is it possible to set the "avtomatizirovannye" in PostgreSql?

Hello! Question, is it possible to set up automatic creation of partitions in PostgreSql (version 10)? For example, to table a beat machine on the partition of 1 million records (the partition was created when you insert data, if necessary)?
Geo_Sta asked March 31st 20 at 21:51
2
answers

What sacrifice when sortirovanie?

mysql table listings. +------------+------------+-----+-------------+ | real_id | date | ... | locality_id | +------------+------------+-----+-------------+ | 1 | 12.12.2012 | ... | 2 | | 2 | 12.12.2013 | ... | 2 | | ... | ... | ... | ... | | 23.000.000 | 12.12.2018 | ... | 5 | +------------+------------+-----+-------------...
Amelie_Keeling asked March 16th 20 at 13:03
6
answers

Personal message system (sharding)?

Hi all! Tell me, please, how the system of personal messages between users in large projects (Vkontakte, Odnoklassniki, Topface, etc.) taking into account scaling? Interested in is storing user data/chats/messages, and access to this data. Suppose we have 100,000,000 users and you want to do horizontal scaling (sharding) of...
natalia.Schamberger asked March 12th 20 at 10:54
1
answer

Sharding MongoDB under load?

How does sharding MongoDB under load? Especially the effect on the system load their Map/Reduce?
Miguel.Cummera asked October 10th 19 at 03:35
3
answers

Protezirovanie tables in MySQL?

Good day. There is a table orders more than 10 million records. Want to split the partition by date of creation quarterly. PK id INT AUTO_INCREMENT. When you alter the table are obtained: A PRIMARY KEY must include all columns in the table''s partitioning function. To make a composite PK I can't because I the uniqueness of...
mireille96 asked October 7th 19 at 23:45
2
answers

Update protezirovanija tables in PostgreSQL?

The task was to smash a large plate in PostgreSQL to partition by date. Labels, indexes and constraints created with INSERT'om clear — hang the trigger and select the partition and depending on the date. And what about c trigger to UPDATE records? In a network somehow silent about it, maybe it's something I do not want to....
vance96 asked October 3rd 19 at 11:34
1
answer

How to particioate Postgresql days?

Postgresql 9.3. How to particioate? Saw manual... But they imply that Postgres no protezirovanija? Just trigger rozhdayutsya new table? And how then to work with them? It may help to find good material for a teapot?
libbie_Dav asked September 20th 19 at 18:30