1 Bloomberg: #Stockmarkets are crashing, globally. Look what’s happened so far this month in #Japan (-7.9%), #SouthKorea (-9.7%), #France (-7.6%), #Switzerland (-8.1%) or #Indonesia (-14%) β€” using #benchmark #indexes for all. 🧡

[ΠŸΠ΅Ρ€Π΅Π²ΠΎΠ΄] НСтипичныС ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL, ΠΈΠ»ΠΈ ΠšΡ€Π΅Π°Ρ‚ΠΈΠ²Π½ΠΎΠ΅ ускорСниС запросов

Когда Ρ€Π΅Ρ‡ΡŒ Π·Π°Ρ…ΠΎΠ΄ΠΈΡ‚ ΠΎΠ± ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚Ρ‡ΠΈΠΊΠΈ ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ ΠΏΠ΅Ρ€Π΅Ρ‡ΠΈΡΠ»ΡΡŽΡ‚ ΠΏΡ€ΠΈΠ²Ρ‹Ρ‡Π½Ρ‹ΠΉ Π½Π°Π±ΠΎΡ€ ΠΏΡ€ΠΈΡ‘ΠΌΠΎΠ²: слСгка ΠΏΠ΅Ρ€Π΅ΠΏΠΈΡΠ°Ρ‚ΡŒ запрос, Π½Π°ΠΊΠΈΠ½ΡƒΡ‚ΡŒ индСкс Π½Π° ΠΊΠΎΠ»ΠΎΠ½ΠΊΡƒ, Π΄Π΅Π½ΠΎΡ€ΠΌΠ°Π»ΠΈΠ·ΠΎΠ²Π°Ρ‚ΡŒ, ΡΠ΄Π΅Π»Π°Ρ‚ΡŒ analyze, vacuum, cluster, ΠΈ Ρ‚Π°ΠΊ ΠΏΠΎ ΠΊΡ€ΡƒΠ³Ρƒ. ΠšΠ»Π°ΡΡΠΈΡ‡Π΅ΡΠΊΠΈΠ΅ Ρ‚Π΅Ρ…Π½ΠΈΠΊΠΈ, ΠΊΠΎΠ½Π΅Ρ‡Π½ΠΎ, Ρ€Π°Π±ΠΎΡ‚Π°ΡŽΡ‚, Π½ΠΎ ΠΈΠ½ΠΎΠ³Π΄Π° ΠΊΡ€Π΅Π°Ρ‚ΠΈΠ²Π½Ρ‹ΠΉ ΠΏΠΎΠ΄Ρ…ΠΎΠ΄ Π΄Π°Ρ‘Ρ‚ Π³ΠΎΡ€Π°Π·Π΄ΠΎ большС. Π’ этой ΡΡ‚Π°Ρ‚ΡŒΠ΅ Haki Benita ΠΏΠΎΠΊΠ°Π·Ρ‹Π²Π°Π΅Ρ‚ Π½Π΅Ρ‚ΠΈΠΏΠΈΡ‡Π½Ρ‹Π΅ Ρ‚Π΅Ρ…Π½ΠΈΠΊΠΈ ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL.

https://habr.com/ru/companies/postgrespro/articles/1001194/?utm_source=habrahabr&utm_medium=rss&utm_campaign=1001194

#optimisation #hash #btree #indexes #postgresql #администрированиС #администрированиС_Π±Π΄ #индСкс

НСтипичныС ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL, ΠΈΠ»ΠΈ ΠšΡ€Π΅Π°Ρ‚ΠΈΠ²Π½ΠΎΠ΅ ускорСниС запросов

Когда Ρ€Π΅Ρ‡ΡŒ Π·Π°Ρ…ΠΎΠ΄ΠΈΡ‚ ΠΎΠ± ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚Ρ‡ΠΈΠΊΠΈ ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ ΠΏΠ΅Ρ€Π΅Ρ‡ΠΈΡΠ»ΡΡŽΡ‚ ΠΏΡ€ΠΈΠ²Ρ‹Ρ‡Π½Ρ‹ΠΉ Π½Π°Π±ΠΎΡ€ ΠΏΡ€ΠΈΡ‘ΠΌΠΎΠ²: слСгка ΠΏΠ΅Ρ€Π΅ΠΏΠΈΡΠ°Ρ‚ΡŒ запрос, Π½Π°ΠΊΠΈΠ½ΡƒΡ‚ΡŒ индСкс Π½Π° ΠΊΠΎΠ»ΠΎΠ½ΠΊΡƒ, Π΄Π΅Π½ΠΎΡ€ΠΌΠ°Π»ΠΈΠ·ΠΎΠ²Π°Ρ‚ΡŒ, ΡΠ΄Π΅Π»Π°Ρ‚ΡŒ analyze, vacuum,...

Π₯Π°Π±Ρ€

[ΠŸΠ΅Ρ€Π΅Π²ΠΎΠ΄] НСтипичныС ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL, ΠΈΠ»ΠΈ ΠšΡ€Π΅Π°Ρ‚ΠΈΠ²Π½ΠΎΠ΅ ускорСниС запросов

Когда Ρ€Π΅Ρ‡ΡŒ Π·Π°Ρ…ΠΎΠ΄ΠΈΡ‚ ΠΎΠ± ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚Ρ‡ΠΈΠΊΠΈ ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ ΠΏΠ΅Ρ€Π΅Ρ‡ΠΈΡΠ»ΡΡŽΡ‚ ΠΏΡ€ΠΈΠ²Ρ‹Ρ‡Π½Ρ‹ΠΉ Π½Π°Π±ΠΎΡ€ ΠΏΡ€ΠΈΡ‘ΠΌΠΎΠ²: слСгка ΠΏΠ΅Ρ€Π΅ΠΏΠΈΡΠ°Ρ‚ΡŒ запрос, Π½Π°ΠΊΠΈΠ½ΡƒΡ‚ΡŒ индСкс Π½Π° ΠΊΠΎΠ»ΠΎΠ½ΠΊΡƒ, Π΄Π΅Π½ΠΎΡ€ΠΌΠ°Π»ΠΈΠ·ΠΎΠ²Π°Ρ‚ΡŒ, ΡΠ΄Π΅Π»Π°Ρ‚ΡŒ analyze, vacuum, cluster, ΠΈ Ρ‚Π°ΠΊ ΠΏΠΎ ΠΊΡ€ΡƒΠ³Ρƒ. ΠšΠ»Π°ΡΡΠΈΡ‡Π΅ΡΠΊΠΈΠ΅ Ρ‚Π΅Ρ…Π½ΠΈΠΊΠΈ, ΠΊΠΎΠ½Π΅Ρ‡Π½ΠΎ, Ρ€Π°Π±ΠΎΡ‚Π°ΡŽΡ‚, Π½ΠΎ ΠΈΠ½ΠΎΠ³Π΄Π° ΠΊΡ€Π΅Π°Ρ‚ΠΈΠ²Π½Ρ‹ΠΉ ΠΏΠΎΠ΄Ρ…ΠΎΠ΄ Π΄Π°Ρ‘Ρ‚ Π³ΠΎΡ€Π°Π·Π΄ΠΎ большС. Π’ этой ΡΡ‚Π°Ρ‚ΡŒΠ΅ Haki Benita ΠΏΠΎΠΊΠ°Π·Ρ‹Π²Π°Π΅Ρ‚ Π½Π΅Ρ‚ΠΈΠΏΠΈΡ‡Π½Ρ‹Π΅ Ρ‚Π΅Ρ…Π½ΠΈΠΊΠΈ ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL.

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

#optimisation #hash #btree #indexes #postgresql #администрированиС #администрированиС_Π±Π΄ #индСкс

НСтипичныС ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π² PostgreSQL, ΠΈΠ»ΠΈ ΠšΡ€Π΅Π°Ρ‚ΠΈΠ²Π½ΠΎΠ΅ ускорСниС запросов

Когда Ρ€Π΅Ρ‡ΡŒ Π·Π°Ρ…ΠΎΠ΄ΠΈΡ‚ ΠΎΠ± ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ†ΠΈΠΈ Π±Π°Π·Ρ‹ Π΄Π°Π½Π½Ρ‹Ρ…, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚Ρ‡ΠΈΠΊΠΈ ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ ΠΏΠ΅Ρ€Π΅Ρ‡ΠΈΡΠ»ΡΡŽΡ‚ ΠΏΡ€ΠΈΠ²Ρ‹Ρ‡Π½Ρ‹ΠΉ Π½Π°Π±ΠΎΡ€ ΠΏΡ€ΠΈΡ‘ΠΌΠΎΠ²: слСгка ΠΏΠ΅Ρ€Π΅ΠΏΠΈΡΠ°Ρ‚ΡŒ запрос, Π½Π°ΠΊΠΈΠ½ΡƒΡ‚ΡŒ индСкс Π½Π° ΠΊΠΎΠ»ΠΎΠ½ΠΊΡƒ, Π΄Π΅Π½ΠΎΡ€ΠΌΠ°Π»ΠΈΠ·ΠΎΠ²Π°Ρ‚ΡŒ, ΡΠ΄Π΅Π»Π°Ρ‚ΡŒ analyze, vacuum,...

Π₯Π°Π±Ρ€
Bloomberg: A #rally that drove the #S&P500 to within a whisker of an all-time high is stalling as #traders gear up for a slate of #US #economic readings, starting with #retailsales today. #Asian #indexes set fresh records overnight. #markets

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

All Right, Then - Futility Closet

Index entries in Hilaire Belloc’s The Aftermath: Or, Gleanings From a Busy Life, 1903: Abingdon, History of, by Lord Charles Gamber, see Pulping, p. 187. Advertisement, Folly and Waste of, see Pulping, p. 187. All Souls, College of, see Pulping, p. 187. Cabs, Necessity of, to Modern Publisher, see Pulping, p. 187. Cabs to Authors, Unwarrantable Luxury, see Pulping, p. 187. Call, Divine, to a Literary Career, see Pulping, p. 187. Dogs, Reputation Going to the, see Pulping, p. 187. England, Source and Wealth of, see Pulping, p. 187. Fame, see Pulping, p. 187. Genius, Indestructibility of, see Pulping, p....

Futility Closet

In 1951 G.V. Carey published a 15-page booklet called β€œMaking an Index,” intended to guide new authors in preparing indexes for their books. When it was published, a friendly (.) suggested jokingly that the booklet might have benefited from an index of its own, in which Carey could have given β€œa full-dress demonstration of his principles.”

So, charmingly, Carey made one."
https://www.futilitycloset.com/2015/11/17/as-you-wish/
#indexes

As You Wish - Futility Closet

In 1951 G.V. Carey published a 15-page booklet called β€œMaking an Index,” intended to guide new authors in preparing indexes for their books. When it was published, a friendly reviewer in the Times Literary Supplement suggested jokingly that the booklet might have benefited from an index of its own, in which Carey could have given β€œa full-dress demonstration of his principles.” So, charmingly, Carey made one: In the second edition he added a 3-page index to his 15-page book, writing, β€œThe reviewer, though he may have had his tongue in his cheek, has put the author on his mettle and...

Futility Closet
This leads me to the discovery of the scholarly journal The Indexer, still going strong since the 1950s and asking pointed questions.
https://www.liverpooluniversitypress.co.uk/doi/10.3828/index.2025.33
https://www.liverpooluniversitypress.co.uk/doi/10.3828/index.2025.35 #indexes
"An index is customarily regarded as an arrangement of signposts pointing the way to alphabetically analysed textual content, but may effectively serve more imaginative purposes: to relieve the text of overburdening detail, to replace footnotes, to sharpen the perspective of the text, to supplement as well as elucidate textual content. Above all, it may be made so readable that one may begin with the index, deriving from it such pleasure as will stimulate eagerness to turn back to the text, perhaps piecemeal rather than as a continuous whole. (...)
In summing up my ideas with regard to the unconventional Index, I would say that I can imagine that a mechanized, computerized Index may have its function, and that is to satisfy the mechanized, computerized human minds and their particular, totally legitimate intellectual needs. The type of Index I have in mind should be more than the carefully tended cemetery of the ideas expressed in the to-be-indexed text. (...) Ideally, then, a good Index should be more than merely a taciturn sign-post erected after all the rest has been done and is immutably crystallized. Otherwise we get the ordinary Feld-Wald- und Wiesen-Index which tells the reader how many kilometres he has to proceed in which direction, and at which locality he will receive further information, with the usual infras and supras, the ridiculous op.cits, the obscure qua voces, and the tantalizing see alsos. I prefer the Index which has a life of its own, which may pride itself on being the child of imagination, and which should enable us to spend a peaceful evening in bed, reading such an Index, as if we were reading a good novel."
William S. Heckscher, The unconventional index and its merits, The Indexer: The International Journal of Indexing
Volume 13, Number 1
https://doi.org/10.3828/indexer.1982.13.1.3
https://www.liverpooluniversitypress.co.uk/doi/10.3828/indexer.1982.13.1.3 #indexes
Excerpts - Futility Closet

Ogden Nash’s 1975 poetry collection I Wouldn’t Have Missed It contains an intriguing index of last lines: A weirdo of fifty, 347 Alone, in the dusk, with the cleaning fluid, 239 And bring me half a dozen smelts, 193 And jam the bloody airwaves on the Seventeenth of March, 199 And join that lama, 217 And leave casements to Keats and me, 332 And the hell with the first fourteen, 346 And Zeus said, Yes, I’m an atheist, 351 But Custard keeps crying for a nice safe cage, 100 But the sensible fish swims down, 28 But you need an...

Futility Closet