bouvyd’s avatarbouvyd’s Twitter Archive—№ 999

    1. …in reply to @rvalyi
      @rvalyi Only allows referencing other columns of the same table if I read correctly, this limits what could be done with that greatly... Perf pbs for stored computed fields often comes from the fact that we have to read lots of other tables (currency rates, count() in other tables, etc.)
  1. …in reply to @bouvyd
    @rvalyi Also, in most cases you want the computation to be done in cache (onchange, new records) to see the results of what you're doing live. I honestly cannot find an example where doing the computation in Postgres would not lead to loss of functionality...