pg-index-health – статический анализ структуры PostgreSQL баз данных

С 2019 года я занимаюсь разработкой open source инструмента под названием pg-index-health, который позволяет анализировать структуру БД и находить потенциальные проблемы. Все эти годы pg-index-health эволюционировал и развивался. За 2024 год мне при поддержке нескольких контрибьюторов удалось решить большинство остававшихся «детских болячек» и довести проект до состояния, когда он готов к масштабной экспансии. В этой статье я хочу подробно рассказать об идеях, которые стоят за этим инструментом, и как его использовать в ваших проектах.

https://habr.com/ru/articles/871546/

#java #postgresql #postgres #indexes #pgindexhealth #static_analysis #статический_анализ #honeycomb #testing_trophy #test_pyramid

arise, I want tools that help diagnose #queries, understand the (mis)use of #indexes, and tune database parameters based on the situation. It also needs to support remote administration (without requiring SSH access), be natively supported on @Microsoft #Azure or Amazon Web Services (AWS), and come with portable tools I can easily download and use in build pipelines without needing to install frameworks like .NET or Java. Finally, it should provide clear error (cont'd)

Linked is a neat article explaining a lot about b-trees. Especially notable are the excellent visualization and animations which gave me a new way to understand these incredibly important data structures.https://salas.com/2024/09/14/b-trees-and-database-indexes/#database #performance #indexes #btree #databasedesign #datavisualization #datastructure

You'll want to know this about #AI in #Windows 11. (Hat tip to my brother, a longtime IT pro.) "Microsoft has introduced ‘Recall,’ an AI feature in Windows 11 that #records and #indexes all #user #activities." https://tinyurl.com/v5emypye #AmEditing

@aendra
The various components of the social din might be better if the index was external, and more collaborative.

I wonder if the Fediverse could support a series of human-derived #indexes outside the likes of Bluesky, #TwitteX and #FaceThreadAgram ?

We dive deep into indexes supported in pgvector. Learn how they work, and find the best option for helping scale your critical data.

➡️ Read the blog: https://hubs.ly/Q02nwp2J0

...
#Stormatics #PostgreSQL #Indexes #PGVector #Database

pgvector 0.6.0 has been released 🎉

It now supports parallel index builds for HNSW 🗂️

Building an HNSW index is now up to 30x faster for unlogged tables ⚡

For full release notes, please review the pgvector changelog 👇
https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md#060-2024-01-29

#pgvector #vectors #embeddings #postgresql #darabase #release #hnsw #indexes

Comparing methods and indices for biodiversity and status assessment in a hydropower-regulated river

https://link.springer.com/article/10.1007/s10750-023-05448-4

#morphology #metabarcoding #monitoring #indexes #Norway #freshwater

Bye Sequence, Hello UUIDv7
https://buildkite.com/blog/goodbye-integers-hello-uuids
#ycombinator #UUID #UUIDv7 #Database #Indexes #Time_based #Primary_keys #Secondary_keys

#Since #Mastodon #only #indexes #hashtags, #in #order #to #ensure #your #entire #post #is #searchable, #simply #prepend #every #word #in #your #post #with #a #hash.

#ModernProblems #ModernSolutions #DoNotDoThis #ThisIsNotHowYouUseAHashtag #hashtag #toot #TootToot

#Crossref as a bibliographic #discovery tool in the arts and #humanities

Quantitative Science Studies | MIT Press

https://direct.mit.edu/qss/article/doi/10.1162/qss_a_00240/114564/Crossref-as-a-bibliographic-discovery-tool-in-the

#discoverytools #indexes #DOI #metadata

1/

Get ready to dive deep into MySQL indexes! Dave Stokes ( @stoker@twitter.com ) will be speaking at #PHPTek on the topic of "MySQL Indexes -- How They Really Work". Register now: https://tek.phparch.com #MySQL #Indexes

I wrote a blog entry about the need for decent #indexes in #archaeology books. https://abookindexer.com/2023/01/ There'll be a revised version soon, because I have had more thoughts on the subject.

OpenCitations Meta is out now! It stores and delivers bibliographic metadata for all publications involved in the OpenCitations citation #indexes, and presently contains #metadata describing > 87 MILLION bibliographic entities. Learn more about its data and technical features here:  https://opencitations.hypotheses.org/3140

#OpenCitationsMeta #OC2022releases 

What types of #indexes are there, what are the elements of an #index, and how do they interact? How avoid pitfalls of #indexing? These and many other questions for #indexodon get answered (in German) in this new contribution by Jochen Fassbender, freely available here: https://doi.org/10.1515/9783110769043-019

Very interesting #longread on

#Bitmap #indexes, in general
Bitmap Indexes, in #golang

https://habr.com/en/company/badoo/blog/455608/

It’s that #INDEX book again. (This is getting silly now.)
After being in TIME magazine’s and the Washington Post’s top books of the year lists, Dennis Duncan’s ‘INDEX, A History of the’ (for which I did the, er, index) is also one of the ‘100 Notable Books of 2022’ in the New York Times. Go Dennis, go #indexes, go #indexers. 🥳
#indexodon
https://www.nytimes.com/interactive/2022/11/22/books/notable-books.html

Does your book need an #index?
Is the author the best person to do it?
Well, sometimes, but often not, for reasons of experience, skills, software, training and time.
So here’s an article I wrote for the Society of Authors: ‘Why you need and how to work with a book #indexer: a guide for #authors.’
Hope it helps!
#indexes #indexing #indexodon

https://baindex.org/2021/01/29/why-you-need-and-how-to-work-with-a-book-indexer-a-guide-for-authors/

@shawrd773 @varsha_venkat @h_tejas nice description of #indexing there, of #bookindexing, that is, and writing #indexes and #bookindexes. #indexodon thanks 😊

I'm willing to put friendship on the line when it comes to #bookrecs. I can't be friends with someone who doesn't like [insert author].

#JaneBowles is high up on my list of writers that can make or break a friendship. She's a #TrueOriginal

My #PasteUp of Jane & her lover #Cherifa from 2009.

#index entry on Cherifa from Millicent Dillon's biography of Jane Bowles: A Little Original Sin.

p 236: "Cherifa...was handsome and had gold teeth. Like Janie she was unpredictable."

#indexodon #indexes