From fd3c349c460ea23bff2f27ce30917df591b9c498 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 25 Jul 2007 15:11:10 +0200 Subject: [PATCH] Cluster exif_info on the tag field; it seems to help quite a lot for the equipment query. --- sql/pr0n.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index 11af9ca..5eacc40 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -80,6 +80,7 @@ CREATE TABLE exif_info ( ); CREATE INDEX exif_info_tag ON exif_info ( tag ); +CLUSTER exif_info_tag ON exif_info; GRANT INSERT ON TABLE deleted_images TO pr0n; GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE events TO pr0n; -- 2.39.2