koji

Clone

#1353 Create db index for listTagged
Merged 4 years ago by mikem. Opened 5 years ago by tkopecek.
tkopecek/koji issue1352  into  master

file modified
+4 
@@ -592,6 +592,10 @@ 
 

  	PRIMARY KEY (create_event, package_id, tag_id),
 

  	UNIQUE (package_id,tag_id,active)
 

  ) WITHOUT OIDS;
 

+ CREATE INDEX tag_packages_active_tag_id ON tag_packages(active, tag_id);
 

+ CREATE INDEX tag_packages_create_event ON tag_packages(create_event);
 

+ CREATE INDEX tag_packages_revoke_event ON tag_packages(revoke_event);
 

+ CREATE INDEX tag_packages_owner ON tag_packages(owner);
 

  

  -- package groups (per tag). used for generating comps for the tag repos
 

  CREATE TABLE groups (

I've added few more indices used in our instance.

Commit c484311 fixes this pull-request

Pull-Request has been merged by mikem
4 years ago
Metadata
None
No Tags
Changes Summary 1
+4 -0
file changed
docs/schema.sql
Powered by Pagure 5.13.3
Documentation • File an Issue • About • SSH Hostkey/Fingerprint
© Red Hat, Inc. and others.