what is the table 'slots' good for

[Klaus Dahlke]

Dear all,
I use gnucash since many years with the postgresql backend. No inconsistencies or similar so far. The only problem I have that I experience some performance issues, especially one retrieveing data via HBCI or reconciling accounts.

To investigate a bit further I increased the log level of postgresql and found that during retrieval and reconciling that the 'slots' table is involved, e.g. some delete and insert statements with fairly old data ...

Actually, I don't reconcile all my accounts, typically only reconcile the bank and credit/debit cards accounts.

The slots table has now 18250 lines:
gnucash=# select count(slot_type) from slots;
 count 
-------
 18250
(1 row)


gnucash=# select slot_type, count(slot_type) from slots group by slot_type;
 slot_type | count 
-----------+-------
         6 |     8
         4 |  3292
         5 |  3144
         9 |  4827
         1 |  5876
        10 |  1103
(6 rows)

Could give some information what's the purpose of the slots table and whether the 'old' entries can be deleted?

Thanks and best regards,
Klaus