Revision 2ebcdf323a20f4496ccc33503491dc8679a2b665 authored by Antoine R. Dumont (@ardumont) on 24 January 2020, 10:57:46 UTC, committed by Antoine R. Dumont (@ardumont) on 24 January 2020, 11:14:00 UTC
Due to our pattern of adding objects [1], vacuum is triggered regularly on pg_catalog.*, having an heavy impact on performance. This commit tries to avoid the dropping the temporary tables part, emptying them instead (they still are dropped at the end of the session but less often). This should decrease the bloat on pg_catalog.* tables. [1] - create temporary table - insert data from temporary table to production table with filtering - drop temporary table
1 parent cc25810
| File | Mode | Size |
|---|---|---|
| bin | ||
| docs | ||
| sql | ||
| swh | ||
| .gitignore | -rw-r--r-- | 136 bytes |
| .pre-commit-config.yaml | -rw-r--r-- | 1.1 KB |
| AUTHORS | -rw-r--r-- | 112 bytes |
| CODE_OF_CONDUCT.md | -rw-r--r-- | 3.3 KB |
| CONTRIBUTORS | -rw-r--r-- | 29 bytes |
| LICENSE | -rw-r--r-- | 34.3 KB |
| MANIFEST.in | -rw-r--r-- | 242 bytes |
| Makefile | -rw-r--r-- | 163 bytes |
| Makefile.local | -rw-r--r-- | 69 bytes |
| README.md | -rw-r--r-- | 4.2 KB |
| mypy.ini | -rw-r--r-- | 839 bytes |
| pytest.ini | -rw-r--r-- | 319 bytes |
| requirements-swh-journal.txt | -rw-r--r-- | 22 bytes |
| requirements-swh.txt | -rw-r--r-- | 73 bytes |
| requirements-test.txt | -rw-r--r-- | 305 bytes |
| requirements.txt | -rw-r--r-- | 66 bytes |
| setup.py | -rwxr-xr-x | 2.4 KB |
| tox.ini | -rw-r--r-- | 507 bytes |
Computing file changes ...
