diff options
| author | Erik Johnston <erik@matrix.org> | 2019-10-01 13:28:41 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2019-10-01 13:43:48 +0100 |
| commit | 5e8387af9e771ae42c7c8c4dc186000d862d3787 (patch) | |
| tree | caa462f568eb43e70bedd4e4ae9226c01e910726 /test_postgresql.sh | |
| parent | Add received_ts column to redactions. (diff) | |
| download | synapse-5e8387af9e771ae42c7c8c4dc186000d862d3787.tar.xz | |
Use `received_ts` to find uncensored redacted events
Joining against `events` and ordering by `stream_ordering` is inefficient as it forced scanning the entirety of the redactions table. This isn't the case if we use `redactions.received_ts` column as we can then use an index.
Diffstat (limited to 'test_postgresql.sh')
0 files changed, 0 insertions, 0 deletions