#indexes

2025-01-04

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

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

habr.com/ru/articles/871546/

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

Dennis Doomenddoomen
2024-10-15

arise, I want tools that help diagnose , understand the (mis)use of , and tune database parameters based on the situation. It also needs to support remote administration (without requiring SSH access), be natively supported on @Microsoft 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)

2024-09-15

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.salas.com/2024/09/14/b-trees-a #performance #indexes #btree #databasedesign #datavisualization #datastructure

Katharine O'Moore-Klopf, ELSKOKEdit
2024-05-30

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

2024-03-21

@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 ?

StormaticsStormaticsTech
2024-03-08

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: hubs.ly/Q02nwp2J0

...

Paolo Melchiorrepaulox@fosstodon.org
2024-01-30

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 👇
github.com/pgvector/pgvector/b

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

Teresita Porter 🙋🏻‍♀️DNAdataPhile@ecoevo.social
2024-01-13

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

link.springer.com/article/10.1

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

François Renaville 🇺🇦🇪🇺fr@mastodon.top
2023-02-20
php[tek] 2024 :tek2024:tek@phparch.social
2023-01-21

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: tek.phparch.com #MySQL #Indexes

2023-01-06

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

2022-12-20

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:  opencitations.hypotheses.org/3

#OpenCitationsMeta #OC2022releases

OpenCitations Meta is out now #OC2022releases
2022-12-12

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: doi.org/10.1515/9783110769043-

2022-12-03

Very interesting #longread on

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

habr.com/en/company/badoo/blog

Paula Clarke Bainpc_bain@toot.wales
2022-11-23

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
nytimes.com/interactive/2022/1

Paula Clarke Bainpc_bain@toot.wales
2022-11-18

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

baindex.org/2021/01/29/why-you

Title and featured image from the article ‘Why you need and how to work with a book indexer: a guide for authors’ by Paula Clarke Bain. The image is a distorted view of wavy columns of entries from one of my indexes.
2022-11-18

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

2022-11-17

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

Paste-up of Jane Bowles & CherifaIndex from Jane Bowles biography.

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst