[tor-bugs] #3889 [Metrics Website]: Analyze metrics database configuration for possible performance bottleneck

[Tor Bug Tracker & Wiki]

#3889: Analyze metrics database configuration for possible performance bottleneck
-----------------------------+----------------------------------------------
 Reporter:  karsten          |          Owner:  karsten
     Type:  defect           |         Status:  new    
 Priority:  normal           |      Milestone:         
Component:  Metrics Website  |        Version:         
 Keywords:                   |         Parent:         
   Points:                   |   Actualpoints:         
-----------------------------+----------------------------------------------
 The metrics database on yatei is much slower than a freshly set up
 database on Sebastian's laptop.  To some extent this is understandable,
 because things deteriorate over time.  But relay-search queries that take
 seconds or less on Sebastian's laptop shouldn't take minutes to complete
 on yatei.  We should take a look if we can tweak yatei's database
 configuration to remove some bottlenecks.

 Possible candidates for tweaks are auto-vacuuming intervals, indexes,
 backups, etc.

 How can we compare database configurations?  Can we put up yatei's
 PostgreSQL configuration anywhere public?  Also, what PostgreSQL
 statistics should we compare?

-- 
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/3889>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online