Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2013-04-13 | Add additional pg_trgm indexes for quicker searches | Dan McGee | 1 | -0/+3 | |
This allows our normal keyword-based search to be index-optimized rather than always doing full table scans. It requires the pg_trgm extension which is shipped out of the box with any sane install of PostgreSQL. Signed-off-by: Dan McGee <dan@archlinux.org> | |||||
2012-07-09 | Add triggers for adding package update rows | Dan McGee | 2 | -0/+75 | |
This will be done instead of doing this logic at the application level, which has some subtle race conditions. When two simultaneous threads attempt to delete the same package, two update rows for the delete action are inserted. When done at the database level, we can ensure a one-to-one mapping between row operations and entries in this table. Signed-off-by: Dan McGee <dan@archlinux.org> |