summary refs log tree commit diff
path: root/synapse/storage/schema/main (follow)
Commit message (Expand)AuthorAgeFilesLines
* Run `ANALYZE` after fiddling with stats (#16849)Erik Johnston2024-01-242-0/+18
* Correctly mention previous copyright (#16820)Erik Johnston2024-01-2327-0/+27
* Preparatory work for tweaking performance of auth chain lookups (#16833)Erik Johnston2024-01-232-0/+34
* Merge remote-tracking branch 'gitlab/clokep/license-license' into new_developErik Johnston2023-12-13306-300/+5724
|\
| * Update license headersPatrick Cloke2023-11-21319-300/+5971
* | Revert postgres logical replication deltaas v1.98.0rc1David Robertson2023-12-05109-121/+0
* | Fix postgres schema after dropping old tables (#16730)David Robertson2023-12-055-5/+0
* | Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one....reivilibre2023-12-04114-0/+126
* | Drop unused tables & unneeded access token ID for events. (#16522)Patrick Cloke2023-12-011-0/+24
* | Remove old full schema dumps. (#16697)Patrick Cloke2023-11-2817-2896/+0
|/
* Speed up purge room by adding index (#16657)Erik Johnston2023-11-171-0/+17
* Revert "Fix test not detecting tables with missing primary keys and missing r...Erik Johnston2023-11-161-80/+0
* Revert "Add a Postgres `REPLICA IDENTITY` to tables that do not have an impli...Erik Johnston2023-11-161-88/+0
* Fix test not detecting tables with missing primary keys and missing replica i...reivilibre2023-11-161-0/+80
* Add an Admin API to temporarily grant the ability to update an existing cross...David Robertson2023-11-151-0/+15
* Use full GitHub links instead of bare issue numbers. (#16637)Patrick Cloke2023-11-153-3/+5
* Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one....reivilibre2023-11-131-0/+88
* Allow multiple workers to write to receipts stream. (#16432)Erik Johnston2023-10-251-0/+17
* Mark sync as limited if there is a gap in the timeline (#16485)Erik Johnston2023-10-191-0/+25
* Revert "Drop unused tables & unneeded access token ID for events. (#16268)" (...Patrick Cloke2023-10-121-24/+0
* Add DB indices to speed up purging rooms (#16457)David Robertson2023-10-101-0/+20
* Drop unused tables & unneeded access token ID for events. (#16268)Patrick Cloke2023-10-061-0/+24
* Some minor performance fixes for task schedular (#16313)Erik Johnston2023-09-141-0/+16
* Delete device messages asynchronously and in staged batches (#16240)Mathieu Velten2023-09-061-2/+2
* Fix rare deadlock when using read/write locks (#16169) github/release-v1.91.0 release-v1.91.0Erik Johnston2023-08-232-37/+71
* Fix rare deadlock when using read/write locks (#16133)Erik Johnston2023-08-231-0/+37
* Reduce DB contention on worker locks (#16160)Erik Johnston2023-08-231-0/+37
* Increase perf of read/write locks (#16149)Erik Johnston2023-08-231-0/+30
* Implements a task scheduler for resumable potentially long running tasks (#15...Mathieu Velten2023-08-211-0/+28
* Implements admin API to lock an user (MSC3939) (#15870)Mathieu Velten2023-08-101-0/+16
* Bump DB version to 79 since synapse v1.88 was already there (#15998)Mathieu Velten2023-07-265-15/+16
* Fix bad merge of #15933 (#15958)Erik Johnston2023-07-192-0/+0
* Fix race in triggers for read/write locks. (#15933)Erik Johnston2023-07-194-98/+134
* Fix background schema updates failing over a large upgrade gap (#15887)Shay2023-07-181-0/+70
* Revert "Stop writing to column `user_id` of tables `profiles` and `user_filte...Shay2023-07-182-104/+0
* Fix downgrading to previous version of Synapse (#15907)Erik Johnston2023-07-101-2/+8
* Stop writing to column `user_id` of tables `profiles` and `user_filters` (#15...Shay2023-07-072-0/+104
* Add basic read/write lock (#15782)Erik Johnston2023-07-052-0/+271
* Add foreign key constraint to `event_forward_extremities`. (#15751)Erik Johnston2023-07-051-0/+51
* Fix sqlite `user_filters` upgrade (#15817)Shay2023-06-273-3/+91
* Merge branch 'master' into developErik Johnston2023-06-071-1/+21
|\
| * Fix schema delta error in 1.85 (#15739)Erik Johnston2023-06-071-2/+14
| * Fix schema delta error in 1.85 (#15738)Erik Johnston2023-06-071-0/+8
* | `N + 3`: Read from column `full_user_id` rather than `user_id` of tables `pro...Shay2023-06-022-0/+187
|/
* Fix a performance issue introduced in Synapse v1.83.0 which meant that purgin...reivilibre2023-05-311-0/+20
* Set thread_id column to non-null for event_push_{actions,actions_staging,summ...Patrick Cloke2023-05-265-0/+213
* Update code to refer to "workers". (#15606)Patrick Cloke2023-05-161-1/+1
* Add not null constraint to column `full_user_id` of tables `profiles` and `us...Shay2023-05-164-0/+64
* Revert "Set thread_id column to non-null for event_push_{actions,actions_stag...Erik Johnston2023-05-123-167/+0
* Set thread_id column to non-null for event_push_{actions,actions_staging,summ...Patrick Cloke2023-05-033-0/+167
* Add config option to forget rooms automatically when users leave them (#15224)Sean Quah2023-05-031-0/+24
* Add an admin API endpoint to support per-user feature flags (#15344)Shay2023-04-281-0/+27
* Add type hints to schema deltas (#15497)Patrick Cloke2023-04-2726-125/+122
* Add column `full_user_id` to tables `profiles` and `user_filters`. (#15458)Shay2023-04-262-0/+40
* Re re introduce membership tables event stream ordering (#15356)Nick Mills-Barrett2023-04-253-0/+131
* Experimental support for MSC3970: per-device transaction IDs (#15318)Quentin Gliech2023-04-251-0/+53
* Delete server-side backup keys when deactivating an account. (#15181)Shay2023-04-041-0/+17
* Speed up membership queries for users with forgotten rooms (#15385)Erik Johnston2023-04-041-0/+19
* Revert "Set thread_id column to non-null for event_push_{actions,actions_stag...Olivier Wilkinson (reivilibre)2023-03-313-150/+0
* Set thread_id column to non-null for event_push_{actions,actions_staging,summ...Patrick Cloke2023-03-303-0/+150
* Revert "Reintroduce membership tables event stream ordering (#15128)" (#15347)Erik Johnston2023-03-292-99/+0
* Make cleaning up pushers depend on the device_id instead of the token_id (#15...Quentin Gliech2023-03-241-0/+19
* Reintroduce membership tables event stream ordering (#15128)Nick Mills-Barrett2023-03-242-0/+99
* Preparatory work to fix the user directory assuming that any remote membershi...reivilibre2023-03-161-0/+39
* Add schema comments about the `destinations` and `destination_rooms` tables. ...reivilibre2023-03-151-0/+52
* Revert "Add `event_stream_ordering` column to membership state tables (#14979)"David Robertson2023-02-071-21/+0
* Add `event_stream_ordering` column to membership state tables (#14979)Nick Mills-Barrett2023-02-071-0/+21
* Drop unused table `presence` (#14825)Dirk Klimpel2023-01-131-0/+17
* Add index to improve performance of the `/timestamp_to_event` endpoint used f...reivilibre2023-01-111-0/+17
* Faster remote room joins: stream the un-partial-stating of events over replic...reivilibre2022-12-142-0/+54
* Delete event_push_summary_unique_index again. (#14669)Patrick Cloke2022-12-141-0/+33
* Rebuild the user directory and stats tables. (#14643)Patrick Cloke2022-12-081-0/+29
* Faster remote room joins: stream the un-partial-stating of rooms over replica...reivilibre2022-12-052-0/+52
* Add another index to `device_lists_changes_in_room` (#14534)Erik Johnston2022-11-231-0/+20
* Track unconverted device list outbound pokes using a position instead (#14516)Sean Quah2022-11-221-0/+53
* Fix PostgreSQL sometimes using table scans for `event_search` (#14409)Sean Quah2022-11-101-0/+33
* Save login tokens in database (#13844)Quentin Gliech2022-10-261-0/+35
* Unified search query syntax using the full-text search capabilities of the un...James Salter2022-10-251-0/+62
* Update the thread_id right before use (in case the bg update hasn't finished)...Patrick Cloke2022-10-183-134/+8
* When restarting a partial join resync, prioritise the server which actioned a...David Robertson2022-10-181-0/+18
* Add an API for listing threads in a room. (#13394)Patrick Cloke2022-10-131-0/+30
* Mark events as read using threaded read receipts from MSC3771. (#13877)Patrick Cloke2022-10-042-0/+99
* Track notification counts per thread (implement MSC3773). (#13776)Patrick Cloke2022-10-043-0/+149
* Clear out old rows from `event_push_actions_staging` (#14020)Erik Johnston2022-10-032-0/+46
* Allow admins to require a manual approval process before new accounts can be ...Brendan Abolivier2022-09-291-0/+20
* Handle remote device list updates during partial join (#13913)Erik Johnston2022-09-281-0/+28
* Add new columns tracking when we partial-joined (#13892)David Robertson2022-09-271-0/+23
* Snapshot schema 72 (#13873)David Robertson2022-09-262-0/+1990
* Track device IDs for pushers (#13831)Brendan Abolivier2022-09-211-0/+20
* Support enabling/disabling pushers (from MSC3881) (#13799)Brendan Abolivier2022-09-211-0/+16
* Add support to purge rows from MSC2716 and other tables when purging a room (...Eric Eastwood2022-09-161-0/+22
* Keep track when we try and fail to process a pulled event (#13589)Eric Eastwood2022-09-141-0/+29
* Update event push action and receipt tables to support threads. (#13753)Patrick Cloke2022-09-144-0/+150
* Use partial indices on SQLIte. (#13802)Patrick Cloke2022-09-141-0/+56
* Make sequence `cache_invalidation_stream_seq` begin at `2` (#13766)Mathieu Velten2022-09-131-0/+23
* Add receipts event stream ordering (#13703)Nick Mills-Barrett2022-09-131-0/+19
* Remove check current state membership up to date (#13745)Nick Mills-Barrett2022-09-121-0/+52
* Add timestamp to user's consent (#13741)Dirk Klimpel2022-09-081-0/+16
* Add a schema delta to drop unstable private read receipts. (#13692)Patrick Cloke2022-09-011-0/+19
* Drop unused column `application_services_state.last_txn` (#13627)Shay2022-08-302-0/+57
* Bg update to populate new `events` table columns (#13215)Richard van der Hoff2022-07-151-0/+47
* Drop unused tables from groups/communities. (#12967)Patrick Cloke2022-07-131-0/+31
* Drop unused table `event_reference_hashes` (#13218)Richard van der Hoff2022-07-121-0/+17
* Merge remote-tracking branch 'origin/release-v1.62' into developPatrick Cloke2022-06-301-0/+19
|\
| * Add index to help delete old push actions (#13141)Erik Johnston2022-06-301-0/+19
* | Implement MSC3827: Filtering of `/publicRooms` by room type (#13031)Šimon Brandner2022-06-291-0/+19
|/
* Fix serialization errors when rotating notifications (#13118)Erik Johnston2022-06-281-0/+35
* Speed up `get_unread_event_push_actions_by_room` (#13005)Erik Johnston2022-06-152-3/+22
* Clean up schema for `event_edges` (#12893)Richard van der Hoff2022-06-152-0/+90
* Rename delta to apply in the proper schema version. (#13050)Patrick Cloke2022-06-141-0/+0
* Replace noop background updates with DELETE. (#12954)Patrick Cloke2022-06-131-0/+61
* Add a migration step to cleanup potential leftovers of bug 11833 (#12784)Mathieu Velten2022-05-301-0/+19
* Add index to cache invalidations (#12747)Erik Johnston2022-05-171-0/+18
* Track device list updates per room. (#12321)Erik Johnston2022-04-041-0/+38
* Use a sequence to generate AS transaction IDs, drop `last_txn` AS state (#12209)Nick Mills-Barrett2022-04-011-0/+44
* Send device list updates to application services (MSC3202) - part 1 (#11881)Andrew Morgan2022-03-301-0/+23
* Remove unnecessary pass statements. (#12206)Patrick Cloke2022-03-111-1/+0
* Faster joins: persist to database (#12012)Richard van der Hoff2022-03-012-0/+113
* Fix non-strings in the `event_search` table (#12037)Sean Quah2022-02-241-0/+22
* Fix slow performance of `/logout` in some cases where refresh tokens are in u...reivilibre2022-02-221-0/+28
* Add a background database update to purge account data for deactivated users....reivilibre2022-02-021-0/+20
* Send to-device messages to application services (#11215)Andrew Morgan2022-02-011-0/+21
* Add `state_key` and `rejection_reason` to `events` (#11792)Richard van der Hoff2022-01-211-0/+26
* Drop unused table `public_room_list_stream`. (#11795)Richard van der Hoff2022-01-211-0/+18
* Save the OIDC session ID (sid) with the device on login (#11482)Quentin Gliech2021-12-061-0/+27
* Support expiry of refresh tokens and expiry of the overall session when refre...reivilibre2021-11-261-0/+28
* Improve performance of `remove_{hidden,deleted}_devices_from_device_inbox` (#...Brendan Abolivier2021-11-251-0/+18
* Store arbitrary relations from events. (#11391)Patrick Cloke2021-11-221-1/+1
* Merge tag 'v1.47.0rc3' into developDavid Robertson2021-11-161-1/+13
|\
| * Rename `remove_deleted_devices_from_device_inbox` to ensure it is always run ...Andrew Morgan2021-11-161-1/+13
| * Move sql file for `remove_deleted_devices_from_device_inbox` into v65 (#11303)Dirk Klimpel2021-11-151-1/+1
* | Remove unused tables `room_stats_historical` and `user_stats_historical` (#11...Shay2021-11-121-0/+19
* | Move sql file for `remove_deleted_devices_from_device_inbox` into v65 (#11303)Dirk Klimpel2021-11-111-1/+1
|/
* Add index to `local_group_updates.stream_id` (#11231)Erik Johnston2021-11-021-0/+18
* Delete messages for hidden devices from `device_inbox` (#11199)Dirk Klimpel2021-11-021-0/+22
* Fix comments referencing v1.46.0 from PR #10969. (#11212)Dirk Klimpel2021-10-291-1/+1
* Delete messages from `device_inbox` table when deleting device (#10969)Dirk Klimpel2021-10-271-0/+22
* Add a background update for updating MSC3440 relation threads. (#11181)Patrick Cloke2021-10-261-0/+18
* Resolve and share `state_groups` for all historical events in batch (MSC2716)...Eric Eastwood2021-10-131-0/+19
* Use direct references for some configuration variables (part 3) (#10885)Patrick Cloke2021-09-231-1/+1
* Rename MSC2716 things from `chunk` to `batch` to match `/batch_send` endpoint...Eric Eastwood2021-09-212-0/+60
* Use direct references for some configuration variables (#10798)Patrick Cloke2021-09-132-2/+2
* Add a partial index to `presence_stream` to speed up startups (#10748)Sean2021-09-031-0/+18
* Populate `rooms.creator` field for easy lookup (#10697)Eric Eastwood2021-09-011-0/+17
* Move the sessions delta to the latest schema version. (#10725)Patrick Cloke2021-08-311-0/+0
* Remove pushers when deleting 3pid from account (#10581)Azrenbeth2021-08-261-0/+20
* Persist room hierarchy pagination sessions to the database. (#10613)Patrick Cloke2021-08-241-0/+23
* Implement MSC3231: Token authenticated registration (#10142)Callum Brown2021-08-211-0/+23
* Add support for MSC2716 marker events (#10498)Eric Eastwood2021-08-041-0/+24
* Make historical events discoverable from backfill for servers without any scr...Eric Eastwood2021-07-281-0/+49
* Replace `room_depth.min_depth` with a BIGINT (#10289)Richard van der Hoff2021-07-122-0/+88
* Switch `application_services_txns.txn_id` to BIGINT (#10349)Richard van der Hoff2021-07-091-0/+23
* fix ordering of bg update (#10291)Richard van der Hoff2021-07-011-1/+1
* Change more stream_ordering columns to BIGINT (#10286)Richard van der Hoff2021-06-301-0/+30
* Rebuild other indexes using `stream_ordering` (#10282)Richard van der Hoff2021-06-301-3/+8
* Merge branch 'release-v1.37' into developRichard van der Hoff2021-06-292-0/+69
|\
| * Handle inbound events from federation asynchronously (#10272)Erik Johnston2021-06-291-0/+32
| * Add a distributed lock (#10269)Erik Johnston2021-06-291-0/+37
* | Migrate stream_ordering to a bigint (#10264)Richard van der Hoff2021-06-291-0/+40
* | MSC2918 Refresh tokens implementation (#9450)Quentin Gliech2021-06-241-0/+34
|/
* Fix schema delta to not take as long on large servers (#10227)Erik Johnston2021-06-221-2/+5
* Implement knock feature (#6739)Sorunome2021-06-091-0/+17
* Use a database table to hold the users that should have full presence sent to...Andrew Morgan2021-05-181-0/+34
* Reorganise the database schema directories (#9932)Richard van der Hoff2021-05-07263-0/+10006
generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-18 02:24:31 +0000