froOzzy / pg_stage

Anonymization of data in pg_dump
MIT License
9 stars 1 forks source link

Fix missing for uri #43

Closed froOzzy closed 6 months ago

froOzzy commented 6 months ago
Faker mutation_email: 14.584882974624634
Mimesis mutation_email: 2.3204784393310547
Faker mutation_full_name: 8.459977626800537
Mimesis mutation_full_name: 2.1107990741729736
Faker mutation_first_name: 1.6621239185333252
Mimesis mutation_first_name: 1.3101449012756348
Faker mutation_middle_name: 1.640044927597046
Mimesis mutation_middle_name: 1.308844804763794
Faker mutation_last_name: 1.6736407279968262
Mimesis mutation_last_name: 1.3784582614898682
Faker mutation_phone_number: 6.455230712890625
Mimesis mutation_phone_number: 2.253509521484375
Faker mutation_address: 26.772003412246704
Mimesis mutation_address: 1.4933202266693115
Faker mutation_past_date: 20.464454889297485
Mimesis mutation_past_date: 2.570242166519165
Faker mutation_future_date: 19.251901388168335
Mimesis mutation_future_date: 2.513676166534424
Faker mutation_uri: 17.32708477973938
Mimesis mutation_uri: 1.96108078956604
Faker mutation_ipv4_public: 10.79116702079773
Mimesis mutation_ipv4_public: 1.273794174194336
Faker mutation_ipv4_private: 5.513517141342163
Mimesis mutation_ipv4_private: 1.2782046794891357
Faker mutation_ipv6: 4.510409116744995
Mimesis mutation_ipv6: 3.3422837257385254
Faker mutation_numeric_smallint: 1.5114707946777344
Mimesis mutation_numeric_smallint: 0.5586979389190674
Faker mutation_numeric_integer: 1.6185522079467773
Mimesis mutation_numeric_integer: 0.679701566696167
Faker mutation_numeric_bigint: 1.6495940685272217
Mimesis mutation_numeric_bigint: 0.6967422962188721
Faker mutation_numeric_decimal: 10.69069218635559
Mimesis mutation_numeric_decimal: 1.1695737838745117
Faker mutation_numeric_real: 8.985904932022095
Mimesis mutation_numeric_real: 0.9551517963409424
Faker mutation_numeric_double_precision: 12.320000171661377
Mimesis mutation_numeric_double_precision: 1.3769323825836182
Faker mutation_numeric_smallserial: 1.6037657260894775
Mimesis mutation_numeric_smallserial: 0.6321637630462646
Faker mutation_numeric_serial: 1.627183198928833
Mimesis mutation_numeric_serial: 0.6491472721099854
Faker mutation_numeric_bigserial: 1.614861249923706
Mimesis mutation_numeric_bigserial: 0.647289514541626

Теситровалось на 1 млн объектов для каждой мутации. В среднем в два раза быстрее, поэтому в будущих версиях ожидается полный переход на данную библиотеку.