commit 4a4f070c7de19b3266988f74ec9f16431bc717aa Author: Karsten Loesing karsten.loesing@gmx.net Date: Fri Jan 13 09:03:25 2012 +0100
Remove statusentry indices.
Now that we partitioned the statusentry table, we should only have indices on the partitions, not on the parent table. --- db/tordir.sql | 10 ---------- 1 files changed, 0 insertions(+), 10 deletions(-)
diff --git a/db/tordir.sql b/db/tordir.sql index 6d3b617..7ae0afe 100644 --- a/db/tordir.sql +++ b/db/tordir.sql @@ -168,16 +168,6 @@ CREATE TABLE connbidirect ( CONSTRAINT connbidirect_pkey PRIMARY KEY (source, statsend) );
--- Create the various indexes we need for searching relays -CREATE INDEX statusentry_address ON statusentry (address); -CREATE INDEX statusentry_fingerprint ON statusentry (fingerprint); -CREATE INDEX statusentry_nickname ON statusentry (LOWER(nickname)); -CREATE INDEX statusentry_validafter ON statusentry (validafter); - --- And create an index that we use for precalculating statistics -CREATE INDEX statusentry_descriptor ON statusentry (descriptor); -CREATE INDEX statusentry_validafter_date ON statusentry (DATE(validafter)); - -- TABLE network_size CREATE TABLE network_size ( date DATE NOT NULL,