all AI news
Over-indexing
Oct. 20, 2023, 1 p.m. | Nikolay Samokhvalov and Michael Christofides
Postgres FM postgres.fm
Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come across and benchmarked recently.
Here are some links to things they mentioned:
- Nikolay’s tweet on over-indexing https://twitter.com/samokhvalov/status/1713101666629927112
- Heap-Only Tuples (HOT) optimization https://www.postgresql.org/docs/current/storage-hot.html
- Our episode on index maintenance https://postgres.fm/episodes/index-maintenance
- PgBouncer now supports prepared statements https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_21_0
- Our episode on connection poolers https://postgres.fm/episodes/connection-poolers
- Configurable FP_LOCK_SLOTS_PER_BACKEND (Hackers mailing list discussion) https://www.postgresql.org/message-id/flat/CAM527d-uDn5osa6QPKxHAC6srOfBH3M8iXUM%3DewqHV6n%3Dw1u8Q%40mail.gmail.com
- LWLock:lock_manager (Amazon RDS docs) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/wait-event.lw-lock-manager.html
~~~ …
More from postgres.fm / Postgres FM
Jobs in AI, ML, Big Data
Data Engineer
@ Michelin | Pune
Senior Research Analyst, Global Analytics & Measurement
@ NBCUniversal | London, United Kingdom
Research Scientist
@ Meta | Menlo Park, CA
NLP Speech Research Intern
@ Tencent | UK-London
Junior Senior Reliability Engineer
@ NielsenIQ | Bogotá, Colombia
[Job - 15712] Vaga Afirmativa para Mulheres - QA (Automation), SR
@ CI&T | Brazil