How much data can the user fields store?


(Evgeny) #1

On sites, administrators use plugins, for example: discourse-voting

And I was wondering. How much data can be stored this way. No impact on performance. After all, each participant can have thousands of records.

 user.custom_fields.votes

(Rafael dos Santos Silva) #2

The table user_custom_fields.value column has PostgreSQL type text. So it can store a LOT, and you can read more about that in PostgreSQL docs (search for TOAST).

We are discussing moving some heavy data plugins to their own tables, and how to deal with plugin removal and table ownership here: Adding jsonb columns for custom fields