#indexes — Public Fediverse posts

2 BMO: After major #market #indexes closed at new highs, #S&P500 #futures are pointing to a slight further advance at the open. 10-year #Treasury #yields are down another two basis points to 4.33%, with #WTI #oil prices sliding nearly 2% to around $93 a barrel. #markets

2 BMO: After major #market #indexes closed at new highs, #S&P500 #futures are pointing to a slight further advance at the open. 10-year #Treasury #yields are down another two basis points to 4.33%, with #WTI #oil prices sliding nearly 2% to around $93 a barrel. #markets

2 BMO: After major #market #indexes closed at new highs, #S&P500 #futures are pointing to a slight further advance at the open. 10-year #Treasury #yields are down another two basis points to 4.33%, with #WTI #oil prices sliding nearly 2% to around $93 a barrel. #markets

[Перевод] Нетипичные оптимизации в PostgreSQL, или Креативное ускорение запросов

Когда речь заходит об оптимизации базы данных, разработчики обычно перечисляют привычный набор приёмов: слегка переписать запрос, накинуть индекс на колонку, денормализовать, сделать analyze, vacuum, cluster, и так по кругу. Классические техники, конечно, работают, но иногда креативный подход даёт гораздо больше. В этой статье Haki Benita показывает нетипичные техники оптимизации в PostgreSQL.

https://habr.com/ru/companies/postgrespro/articles/1001194/

#optimisation #hash #btree #indexes #postgresql #администрирование #администрирование_бд #индекс

[Перевод] Нетипичные оптимизации в PostgreSQL, или Креативное ускорение запросов

Когда речь заходит об оптимизации базы данных, разработчики обычно перечисляют привычный набор приёмов: слегка переписать запрос, накинуть индекс на колонку, денормализовать, сделать analyze, vacuum, cluster, и так по кругу. Классические техники, конечно, работают, но иногда креативный подход даёт гораздо больше. В этой статье Haki Benita показывает нетипичные техники оптимизации в PostgreSQL.

https://habr.com/ru/companies/postgrespro/articles/1001194/

#optimisation #hash #btree #indexes #postgresql #администрирование #администрирование_бд #индекс

[Перевод] Нетипичные оптимизации в PostgreSQL, или Креативное ускорение запросов

Когда речь заходит об оптимизации базы данных, разработчики обычно перечисляют привычный набор приёмов: слегка переписать запрос, накинуть индекс на колонку, денормализовать, сделать analyze, vacuum, cluster, и так по кругу. Классические техники, конечно, работают, но иногда креативный подход даёт гораздо больше. В этой статье Haki Benita показывает нетипичные техники оптимизации в PostgreSQL.

https://habr.com/ru/companies/postgrespro/articles/1001194/

#optimisation #hash #btree #indexes #postgresql #администрирование #администрирование_бд #индекс

[Перевод] Нетипичные оптимизации в PostgreSQL, или Креативное ускорение запросов

Когда речь заходит об оптимизации базы данных, разработчики обычно перечисляют привычный набор приёмов: слегка переписать запрос, накинуть индекс на колонку, денормализовать, сделать analyze, vacuum, cluster, и так по кругу. Классические техники, конечно, работают, но иногда креативный подход даёт гораздо больше. В этой статье Haki Benita показывает нетипичные техники оптимизации в PostgreSQL.

https://habr.com/ru/companies/postgrespro/articles/1001194/

#optimisation #hash #btree #indexes #postgresql #администрирование #администрирование_бд #индекс

How do B-tree indexes really work—and how should you tune them today (and tomorrow)?

Jakub Kužela dives into index access paths, skip scans, automated indexing, and the future of self-tuning databases. https://lnkd.in/dczDjfA8

#PostgreSQL #Indexes #Performance #P2D2

Vacuum Is a Lie: About Your Indexes

https://boringsql.com/posts/vacuum-is-lie/

#HackerNews #VacuumIsALie #Indexes #Database #BoringSQL #HackerNews #SQL

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of Zimbabwe-related articles
* none

https://en.wikipedia.org/wiki/Index_of_Zimbabwe-related_articles

#Zimbabwerelated #Indexes

Egg prices vs. Consumer Price Index since 1980
https://fred.stlouisfed.org/graph/?g=1Nm5b
#ycombinator #eggs #retail #price #bls #monthly #nation #public_domain_citation_requested #usa #nsa #headline_figure #average #all_items #urban #consumer #cpi #inflation #price_index #indexes #Economic_Data #FRED #St_Louis_Fed #Federal_Reserve

Egg prices vs. Consumer Price Index since 1980
https://fred.stlouisfed.org/graph/?g=1Nm5b
#ycombinator #eggs #retail #price #bls #monthly #nation #public_domain_citation_requested #usa #nsa #headline_figure #average #all_items #urban #consumer #cpi #inflation #price_index #indexes #Economic_Data #FRED #St_Louis_Fed #Federal_Reserve

Egg prices vs. Consumer Price Index since 1980
https://fred.stlouisfed.org/graph/?g=1Nm5b
#ycombinator #eggs #retail #price #bls #monthly #nation #public_domain_citation_requested #usa #nsa #headline_figure #average #all_items #urban #consumer #cpi #inflation #price_index #indexes #Economic_Data #FRED #St_Louis_Fed #Federal_Reserve

Egg prices vs. Consumer Price Index since 1980
https://fred.stlouisfed.org/graph/?g=1Nm5b
#ycombinator #eggs #retail #price #bls #monthly #nation #public_domain_citation_requested #usa #nsa #headline_figure #average #all_items #urban #consumer #cpi #inflation #price_index #indexes #Economic_Data #FRED #St_Louis_Fed #Federal_Reserve

Subtleties of SQLite Indexes

https://emschwartz.me/subtleties-of-sqlite-indexes/

#HackerNews #SQLite #Indexes #Subtleties #Database #Optimization #Tech #Insights

Hey, #editors and #proofreaders, hurry & sign up for the Editorial Freelancers Association's August 14 live #webinar "Indexes Explained for Non-indexers," led by @closereadingie. Your work will be faster & easier when you understand how #indexes really work! https://community.the-efa.org/events/EventDetails.aspx?id=1963774&group=

Embedding User-Defined Indexes in Apache Parquet

https://datafusion.apache.org/blog/2025/07/14/user-defined-parquet-indexes/

#HackerNews #Embedding #User-Defined #Indexes #in #Apache #Parquet #ApacheParquet #UserDefinedIndexes #DataFusion #BigData #Analytics

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of Equatorial Guinea–related articles
* none

https://en.wikipedia.org/wiki/Index_of_Equatorial_Guinea%E2%80%93related_articles

#Equatorial #Indexes

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of Burundi-related articles
* none

https://en.wikipedia.org/wiki/Index_of_Burundi-related_articles

#Indexes #Burundirelated

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of Senegal-related articles
* none

https://en.wikipedia.org/wiki/Index_of_Senegal-related_articles

#Senegalrelated #Indexes

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of philosophy articles (R–Z)
* none

https://en.wikipedia.org/wiki/Index_of_philosophy_articles_%28R%E2%80%93Z%29

#Indexes

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of philosophy articles (A–C)
* none

https://en.wikipedia.org/wiki/Index_of_philosophy_articles_%28A%E2%80%93C%29

#Indexes

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of philosophy articles (I–Q)
* none

https://en.wikipedia.org/wiki/Index_of_philosophy_articles_%28I%E2%80%93Q%29

#Indexes

#LGBTQ English #Wikipedia deletion alert

Could you save this LGBTQ related #English Wikipedia article from deletion?

Index of philosophy articles (D–H)
* none

https://en.wikipedia.org/wiki/Index_of_philosophy_articles_%28D%E2%80%93H%29

#Indexes

OrioleDB's #Bridged Indexes: because who doesn't love yet another revolutionary #database feature that promises to fix problems nobody knew existed? 🤔🎉 Let's all pretend this complex #tech jargon will change our lives while we secretly Google "Btree" like it's a trendy new diet. 🍽️📚
https://www.orioledb.com/blog/orioledb-bridged-indexes #OrioleDB #Indexes #innovation #Btree #databasefeatures #HackerNews #ngated

OrioleDB's #Bridged Indexes: because who doesn't love yet another revolutionary #database feature that promises to fix problems nobody knew existed? 🤔🎉 Let's all pretend this complex #tech jargon will change our lives while we secretly Google "Btree" like it's a trendy new diet. 🍽️📚
https://www.orioledb.com/blog/orioledb-bridged-indexes #OrioleDB #Indexes #innovation #Btree #databasefeatures #HackerNews #ngated

OrioleDB's #Bridged Indexes: because who doesn't love yet another revolutionary #database feature that promises to fix problems nobody knew existed? 🤔🎉 Let's all pretend this complex #tech jargon will change our lives while we secretly Google "Btree" like it's a trendy new diet. 🍽️📚
https://www.orioledb.com/blog/orioledb-bridged-indexes #OrioleDB #Indexes #innovation #Btree #databasefeatures #HackerNews #ngated

OrioleDB's #Bridged Indexes: because who doesn't love yet another revolutionary #database feature that promises to fix problems nobody knew existed? 🤔🎉 Let's all pretend this complex #tech jargon will change our lives while we secretly Google "Btree" like it's a trendy new diet. 🍽️📚
https://www.orioledb.com/blog/orioledb-bridged-indexes #OrioleDB #Indexes #innovation #Btree #databasefeatures #HackerNews #ngated

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

Metaplanet Gains First Index Listing With Inclusion on CoinShares' BLOCK Index - The company's stock is the best-performing Japanese equity this year, having gained nearl... - https://www.coindesk.com/markets/2024/11/05/metaplanet-gains-first-index-listing-with-inclusion-on-coinshares-block-index/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #coinshares #metaplex #markets #indexes #news

The Rise of Index Investing in Crypto - Despite undeniable growth, crypto remains volatile, posing challenges for even seasoned i... - https://www.coindesk.com/markets/2024/10/02/the-rise-of-index-investing-in-crypto/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #institutionalinvestment #institutionalinvestor #institutionaladoption #cryptolong&short #indexfunds #markets #opinion #indexes #etfs

GSR and Wealth Manager St. Gotthard Execute Options Trade Tied to CoinDesk 20 Index - Trade using the CD20 index marks a milestone in digital asset options, enhancing institut... - https://www.coindesk.com/markets/2024/07/10/gsr-and-wealth-manager-st-gotthard-execute-options-trade-tied-to-coindesk-20-index/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #coindesk20 #markets #indices #indexes #index #news #gsr

GSR and Wealth Manager St. Gotthard Execute Options Trade Tied to CoinDesk 20 Index - Trade using the CD20 index marks a milestone in digital asset options, enhancing institut... - https://www.coindesk.com/markets/2024/07/10/gsr-and-wealth-manager-st-gotthard-execute-options-trade-tied-to-coindesk-20-index/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #coindesk20 #markets #indices #indexes #index #news #gsr

GSR and Wealth Manager St. Gotthard Execute Options Trade Tied to CoinDesk 20 Index - Trade using the CD20 index marks a milestone in digital asset options, enhancing institut... - https://www.coindesk.com/markets/2024/07/10/gsr-and-wealth-manager-st-gotthard-execute-options-trade-tied-to-coindesk-20-index/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #coindesk20 #markets #indices #indexes #index #news #gsr

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

Why Good Indexes Are Vital to Crypto’s Future - Indexing is vital for the advancement of new asset classes like crypto, but the U.S. regu... - https://www.coindesk.com/coindesk-indices/2023/08/30/why-good-indexes-are-vital-to-cryptos-future/?utm_medium=referral&utm_source=rss&utm_campaign=headlines #institutionalinvestment #institutionaladoption #cryptolong&short #coindeskindices #indexfunds #opinion #indexes #indices

#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/

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 

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 

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 

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 

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 

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

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

Chainlink and CF Benchmarks to Bolster Onchain Transparency via CF Bitcoin Interest Rate Curve Product

https://news.bitcoin.com/chainlink-and-cf-benchmarks-to-bolster-onchain-transparency-via-cf-bitcoin-interest-rate-curve-product/

#CFBitcoinInterestRateCurve #Web3marketparticipants #BlockchainOracles #BoredApeYachtClub #ChainlinkOracles #SmartContracts #SergeyNazarov #CFBenchmarks #cryptopunks #Blockchain #benchmark #Chainlink #SuiChung #indexes #Indices #Oracles #CFBIRC #CFWeb3 #Scale

Peter Kraus dishes on the market - During my recent conversation with Peter Kraus, which was supposed to be focused on Aperture and its... more: http://feedproxy.google.com/~r/Techcrunch/~3/WNiIZf5z_To/ #exchangetradedfunds #greggschoenberg #federalreserve #privateequity #unitedstates #enterprise #government #peterkraus #realestate #personnel #blackrock #inflation #aperture #banking #finance #analyst #indexes #policy #talent #amazon #europe #thefed #trader #alpha #films #index #japan #etf