We have a database which has ~1,6GB (~3 million records).
Only 2 tables has ~ 2,8mln records and has defined index.
Everything works !!perfectly!! but we have a issue with correct run of /dev/build
I can`t define new columns in model because when I run /dev/build, after several minutes system return 5xx status.
I change in development environment max_execution_time up to 3600 secounds but sill nothing.
My question is: if I defined new fields in datamodel, must run /dev/bulid? Can I add this field manually in console rdbms and manually reindex table?
What really happends when we run /dev/build , outside create new fields - if they defined?
Project was build on SilverStripe 2.4.xx
RDBMS is PostgreSQL 9.1