====== V5 Feature Replica ======

To avoid fiddling with local SQLite databases and synchronization, a single feature/model replica database is used. It is located at cloud01 and is a simple PostgreSQL server:

<code>
postgresql://picalike:picalike@cloud01.picalike.corpex-kunden.de:5401/features
</code>
The following data is located there


  * features: DeiT net features with 384 dim (blob)
  * colors: V3 color features (float array)
  * models: pickled models of category pairs A vs. B
  * missing: a list of image URL that neeeds to be enriched


====== Maintenance ======

By default no indexes are created. The 'id' field is always the primary key.

Keywords: pgsql cloud01 features models replica color kat doc mapping

Useful SQL queries:

<code>
select pg_size_pretty(pg_relation_size('models'));
</code>
To vacuum and or analyze for index statistics:

<code>
[vacuum] analyze missing;
</code>