1. 17
  1.  

  2. 3

    As long as you don’t have hundreds of millions of jobs, yes. If you have that many jobs, things become interesting. It is very nice ot be able create jobs inside transactions.

    Using a varchar() type instead of text in PostgreSQL in 2019, hmmm.

    1. 3

      Using a varchar() type instead of text in PostgreSQL in 2019, hmmm.

      Hah, it’s funny to see this comment, I was just today wondering which one of these I should be choosing for a column that contains a URL fragment - eg oregon in /usa/oregon/portland. Being a newbie to Postgres (my SQL background is in MySQL) I have been choosing text essentially because of the name. Would you please expand on why text is the better choice than varchar in 2019?

      1. 3

        why text is the better choice than varchar in 2019

        It isn’t, they’re equivalent. TEXT is considered idiomatic in Postgres community, and that’s it.

    2. 1

      Didn’t know about “skip locked” yet. Interesting.