5 Matching Annotations
  1. Jun 2023
    1. Dr Lisa van Aardenne, the chief scientist of the University of Cape Town’s climate system analysis group, discussed the use and utility of thermal stress indices. She pointed out that, by the definitions of the universal thermal climate index, much of Africa is under heat stress most days of the year.  Van Aardenne noted that these indices have been developed from a European perspective and do not align with the reality on the ground in Africa. She added: “I’m very concerned that these indices are not fit for purpose here.”

      So for Africa, the figures are so bad that they always look like they're in an emergency? I'm guessing the impact would be that people are more likely to ignore them

  2. Jan 2023
    1. CREATE INDEX Statement

      ABOUT INDEXES *indexes can make queries faster, much like looking for a term in the index of a textbook instead of skimming through all the pages in the book to find all the references to the term. However, indexes take storage space and the DBMS must maintain the index as rows are inserted, updated and deleted in the table.

  3. Jun 2020
  4. Jun 2017
  5. Dec 2016
    1. The real benefit of JSONB: IndexesWe want our application to be fast. Without indexes, the database is forced to go from record to record (a table scan), checking to see if a condition is true. It’s no different with JSON data. In fact, it’s most likely worse since Postgres has to step in to each JSON document as well.

      This solves the problem of the last implementation I handled where json (not jsonb) data was stored in postgres