The first section (A) on ZTF is all truth, from 21 months of running Lasair-ZTF. For each different kind of database table, the number of rows in each table, the number of attributes in each record, and their accumulation as gigabytes per year. Notice that the noncandidates use as much space as the candidates (==detections), even though the noncandidate schema is so small.
...
millions/year | attributes per record | Gbytes per year | |
|---|---|---|---|
(A) ZTF | |||
ZTF candidates | 49 | 113 | 66 |
ZTF noncandidates | 394 | 4 | 60 |
ZTF objects | 10 | 37 | 4 |
ZTF objects ncand>=3 | 2 | 37 | 1 |
(B ) LSST | Extrapolation by factor 50 from ZTF | ||
LSST DIASources | 2450 | 111 | 3300 |
LSST DIAForcedSources | 19700 | 8 | 6000 |
LSST DIAObjects | 500 | 396 | 2000 |
LSST DIAObjects ncand>=3 | 100 | 396 | 500 |