id	summary	reporter	owner	description	type	status	priority	milestone	component	severity	resolution	keywords	cc
140	fix loading dock performance issues in PostgreSQL.	jesus	jesus	When loading info into postgres, we have performance issues as the numeric and text loading docks get "big" (one is just under a billion rows and showing stress).\r\n\r\nWe should be able to take a very comprehensive approach to this.  First, we will partition the data by month, however as each check is monotonically increasing in time, we can rotate out checks into the partition tables as the 5 minute segment is closed out.  This means we can keep an "live" loading dock table that basically only had about 5 minutes worth of data for each check in the system.	enhancement	closed	minor	Wangle	database	serious	fixed