angry__panda

5 ms·

1. 1.▲
   Lemur-70B: Open SOTA LMs for Language Agents, matching ChatGPT on 15 agent tasks(xlang.ai)

   3 points by angry__panda 3y ago|0 comments
2. 2.▲
   by angry__panda 3y ago

   Based on my experiments, Postgres switches from scanning the list to a hash when the array size > 8.
3. 3.▲
   by angry__panda 3y ago

   This is true for Postgres. But might not be true for other databases. For example, for MySQL, in some cases OR is faster than IN operator based on our experiments.
4. 4.▲
   by angry__panda 3y ago

   The article mentioned that it's tested on Postgres 14: "We used a PostgreSQL v14 database on a db.t3.medium Amazon RDS instance equipped with 2 CPUs and 4GB RAM. The storage capacity is 200GB (gp2 storage)."
5. 5.▲
   When should you use the IN instead of the OR operator in Postgres?(ottertune.com)

   100 points by angry__panda 3y ago|49 comments
6. 6.▲
   MVCC causes many problems in Postgres, and here are the ways to address them(ottertune.com)

   4 points by angry__panda 3y ago|0 comments
7. 7.▲
   10,000x Speedup for Postgres Queries: How to Make a Smart Optimizer More Stupid(ottertune.com)

   71 points by angry__panda 3y ago|10 comments