angry__panda
Re:When should you use the IN instead of the OR operator in Postgres q...
on Thursday August 31, 2023 @09:54AM (#37337200)
Based on my experiments, Postgres switches from scanning the list to a hash when the array size > 8.
Re:When should you use the IN instead of the OR operator in Postgres q...
on Thursday August 31, 2023 @09:34AM (#37336914)
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.
Re:When should you use the IN instead of the OR operator in Postgres q...
on Wednesday August 30, 2023 @08:53PM (#37331170)
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)."