789493 - prototype postgres-based symbol store

Status: RESOLVED WONTFIX

(Socorro :: General, task)

Description

[(not currently active) Ted Mielczarek]

jberkus and I discussed the potential for a PostgreSQL-based symbol store on IRC yesterday. It turns out that postgres 9.2 has "range types":
http://wiki.postgresql.org/wiki/RangeTypes
http://www.depesz.com/2011/11/07/waiting-for-9-2-range-data-types/

These would make storing Breakpad's symbol data in Postgres fairly straightforward, since most of the lookups are "find the thing that contains this address" where each thing has a "start-end" address range.

We should find some time and prototype what a postgres DB for storing our Breakpad symbols would look like, and figure out if it'd be a feasible thing to do.

Comment 1

[(not currently active) Ted Mielczarek]

Prototype work that Selena did last week is in this github repo.

Comment 2

[Selena Deckelmann :selenamarie :selena]

Space required to store symbols in database is too large at this time.