256 place 0 fresh

405 [Translation] Global indexes for partitions in Postgres Pro: uniqueness without hacks

Habr
melanny20 (Postgres Professional) @ Habr 2 place · today 12:05 EDT

[Translation] Global indexes for partitions in Postgres Pro: uniqueness without hacks

When there’s no filter on the partitioning key, local indexes turn into a marathon across partitions. The new gbtree keeps a single catalog of keys and jumps straight to the row by primary key. In this article, we’ll show the algorithm, real numbers and limitations (primary key is mandatory, ON CONFLICT does not work) — and where this eases the pain in CRM/billing. Read more

To see detailed statistics for the news please log in »

Read the original

Add your comment
You must be logged in with Facebook to read and write comments.

A newsletter a day!

You may get 10 most important news around midday in daily newsletter. Press the button and we will send you the most important news only, no spam attached.

or register

LIKE us on Facebook so you won't miss the most important news of the day!

News from the same source
Habr Habr
Business Insider
Bryan Metzger @ Business Insider 1 place · today 12:28 EDT

Zohran Mamdani pulls out of ABC town hall over Jimmy Kimmel suspension

The fallout over Jimmy Kimmel's suspension has made its way to New York City's closely followed mayoral race. Read more

3,747 fresh

🔮
22.09.2025 ♈︎ Dear Aries, today promises to be a busy and somewhat challenging day for you. In... Read more ›
Business Insider
Sinéad Baker @ Business Insider 2 place · today 12:12 EDT

Ukraine claims first-ever kills of Russian Be-12 seaplanes. These aircraft are said to hunt naval drones.

Ukraine said it destroyed two Russian Be-12 aircraft, calling it the first time in history that the aircraft type had been destroyed in combat. Read more

1,686 fresh

Business Insider
Ashley Stewart @ Business Insider 3 place · today 13:39 EDT

Oracle's succession plan comes into clear view as its stock skyrockets

Business Insider reported in June that Oracle had promoted the executives to the title of "president" as part of a succession plan. Read more

1,253 fresh

Wired
Zoë Schiffer, Manisha Krishnan @ Wired 1 place · today 13:14 EDT

WIRED Roundup: The Right Embraces Cancel Culture

On this episode of Uncanny Valley, we discuss OpenAI's new teen safety features, the right's retaliation against critics of the late Charlie Kirk, and more of the week’s biggest stories. Read more

952 fresh

Gizmodo
Sabina Graves @ Gizmodo 1 place · today 13:40 EDT

Netflix Is Rushing Out ‘KPop Demon Hunters’ Costumes in Time for Halloween

Kids and grown-ups rejoice; Netflix and Spirit Halloween are making Huntr/x costumes for the fans. Read more

908 fresh

MacRumors
Joe Rossignol @ MacRumors 1 place · today 11:44 EDT

Some iPhone 17, iPhone 17 Pro, and iPhone Air Users Experiencing Intermittent Wi-Fi Issue

Apple's latest iPhone models launched on Friday, and some early adopters of the devices are experiencing intermittent Wi-Fi issues. Affected customers say Wi-Fi connectivity periodically cuts out on the iPhone 17, iPhone 17 Pro, iPhone 17 Pro Max, and iPhone Air, with hundreds of comments about the issue posted across the MacRumors Forums, Reddit, and the Apple Support Community over the past four days. It is unclear how widespread the... Read more

800 fresh

MacRumors
Mitchel Broussard @ MacRumors 2 place · today 13:41 EDT

AirPods Max Get $100 Discount on Woot

Woot today has Apple's AirPods Max with USB-C for $449.00 in four colors, down from $549.00. These are in new condition on Woot, and they come with a one-year Apple limited warranty. Note: MacRumors is an affiliate partner with Woot. When you click a link and make a purchase, we may receive a small payment, which helps us keep the site running. Colors available include Purple, Orange, Blue, and Starlight.... Read more

781 fresh

Financial Times
Financial Times 1 place · today 12:40 EDT

Nvidia to invest up to $100bn in OpenAI

Partnership will support massive build-out of data centres for artificial intelligence Read more

728 fresh

Business Insider
Alice Tecotzky @ Business Insider · today 14:01 EDT

I went to a demonstration by Google employees about H-1B visas. They want the company to speak out.

Members of the Alphabet Workers Union told me that they want Google to make a public statement and "side with their own workers." Read more

706 fresh

Business Insider
Steven Tweedie @ Business Insider · today 12:28 EDT

Nvidia is investing up to $100 billion in OpenAI as part of an AI data center deal

The two tech titans announced a deal on Monday that will see OpenAI build out "at least 10 gigawatts" of AI data centers running Nvidia systems. Read more

697 fresh

Business Insider
Theron Mohamed @ Business Insider · today 12:15 EDT

Indian tech stocks slump after Trump imposes $100,000 application fee for H-1B visas

Several Indian tech stocks fell by over 4% on Monday after the White House rolled out a $100,000 fee to apply for a new H-1B visa for skilled workers. Read more

683 fresh

Tom's Hardware
Tom's Hardware 1 place · today 12:24 EDT

FSR 4 modded to run on RDNA 2 GPUs improves image quality by "leaps and bounds," but carries 10-20% worse performance —AMD's leaked source code turns into modding frenzy

FSR 4 is supposed to only work on RX 9000 series GPUs, but modders were quick to figure out how to run it on older RDNA graphics cards when AMD accidentally published the entire source code on GitHub. Several users have since tested their GPUs with tweaked DLLs, with all results pointing toward improved visuals at the cost of worse FPS. Read more

682 fresh

MacRumors
Juli Clover @ MacRumors 3 place · today 13:05 EDT

Apple Seeds First Betas of iOS 26.1, iPadOS 26.1, and macOS Tahoe 26.1

Apple today provided developers with the first betas of upcoming iOS 26.1, iPadOS 26.1, macOS Tahoe 26.1, tvOS 26.1, watchOS 26.1, and visionOS 26.1 updates for testing purposes. The new betas are the first updates to the iOS, iPadOS, macOS 26, watchOS, tvOS, and visionOS releases that came out last week. The new betas can be downloaded from the Settings app on a compatible device by going to General >... Read more

667 fresh

Business Insider
Aditi Bharade @ Business Insider · today 03:25 EDT

John Oliver says Jimmy Kimmel's suspension is a canary in a coal mine for free speech

John Oliver said Kimmel's show getting suspended was the "latest canary in the coal mine" about free speech in the US. Read more

646

MacRumors
Juli Clover @ MacRumors · today 14:15 EDT

iOS 26.1 Adds New Apple Intelligence Languages and Expands AirPods Live Translation

With iOS 26.1, Apple Intelligence is gaining support for additional languages, including Danish, Dutch, Norwegian, Portuguese (Portugal), Swedish, Turkish, Chinese (Traditional), and Vietnamese. Apple announced plans to expand the languages that can be used with ‌Apple Intelligence‌ last year, and now the added language support is here. ‌Apple Intelligence‌ is now available in the following languages: English (U.S.) English (Australia) English (Canada) English (New Zealand) English (U. Read more

580 fresh

Gizmodo
Ellyn Lapointe @ Gizmodo 2 place · today 12:00 EDT

SpaceX’s Starship Lunar Lander Could Be ‘Years Late,’ NASA Safety Panel Warns

Members of the Aerospace Safety Advisory Panel believe the Human Landing System version of Starship won’t be ready for Artemis 3’s launch in 2027. Read more

569 fresh

The Verge
Sheena Vasani @ The Verge 1 place · today 13:37 EDT

Here are the best Kindle deals right now

When it comes to finding a device to read ebooks, you have a few options to choose from. You can always buy a tablet or use your phone, but those devices are multipurpose and can be used for a ton of things, like surfing the web or doomscrolling on X or Bluesky. If you are […] Read more

544 fresh

Business Insider
Natalie Grigson @ Business Insider · today 13:12 EDT

Whenever I travel with a partner, we stay in separate bedrooms

I've found that staying in two-bedroom accommodations and sleeping in separate bedrooms on vacation with a partner has benefits for sleep and peace. Read more

488 fresh

Wired
Steven Levy @ Wired 2 place · today 06:00 EDT

I Thought I Knew Silicon Valley. I Was Wrong

Tech got what it wanted by electing Trump. A year later, it looks more like a suicide pact. Read more

485

The most popular news from the same source for the last week
Habr Habr
Habr
AKlimenkov @ Habr 1 place · 09/20/2025 11:26 EDT

Everyone always has the right to be like themselves. Autism spectrum disorders and a career in IT: personal experience

"I'm stunned by the illogicality of others, and they are stunned by the fact that I'm a robot." This phrase perfectly describes the peculiarities of my interaction with the world around me. I'm the same robot. Or an alien. I can only guess how I seem to others. But now I know for sure that others consider me at least strange. This is completely mutual. Many actions of people around... Read more

6

Habr
Kaspersky_Lab («Лаборатория Касперского») @ Habr 2 place · 09/16/2025 05:02 EDT

Security Week 2538: Apple усиливает защиту от таргетированных атак

В представленных на прошлой неделе новых смартфонах Apple улучшена защита от кибератак с использованием стратегий повреждения данных в оперативной памяти. Уязвимости, приводящие к переполнению буфера или повторному использованию участка оперативной памяти после освобождения, станет гораздо сложнее эксплуатировать благодаря технологии Memory Integrity Enforcement. Об этом компания Apple сообщает в подробной технической статье. Там утверждается, что устройства нового поколения будут гораздо лучше защищены про Read more

0

Habr
smalkevich (VK) @ Habr 3 place · 09/16/2025 10:14 EDT

Рекомендации историй ВКонтакте: от простой эвристики до ML-системы

Привет, Хабр! Я Степан Малькевич, руковожу командой рекомендации ленты ВКонтакте, AI VK. Сегодня расскажу, как мы за последний год прокачали алгоритмы рекомендаций для историй. Это был путь от MVP с простыми эвристиками до ML‑системы с моделированием авторов, поведенческими фичами и прицелом на онлайновые реакции. Read more Read more

0

Habr
yamano (Positive Technologies) @ Habr 3 place · 09/17/2025 05:18 EDT

Новая атака с использованием бэкдора PhantomRShell

В августе, благодаря нашей песочнице, была предотвращена атака на российские организации с применением нового вредоносного кода. Изначально мы предположили, что это массовый фишинг с серверов злоумышленников, который каждый день можно встретить на почте любой организации. Но оказалось, что отправитель письма вполне легитимный: он был скомпрометирован злоумышленниками, нацеленными на российские оборонные и промышленные организации.Хакеры использовали сложную схему сокрытия вредоносной нагрузки в архивах-поли Read more

0

Habr
ylismir (Cloud.ru) @ Habr 2 place · 09/17/2025 08:43 EDT

Автомасштабируем узлы кластера Kubernetes. Часть 2

Всем привет! Это вновь Илья Смирнов, архитектор решений из Cloud.ru. В прошлой статье мы рассмотрели традиционные подходы к масштабированию подов и узлов кластера Kubernetes. Но остался нерешенным вопрос — как масштабировать приложение по событиям из внешней системы? Ведь мы хотим, чтобы каждое новое сообщение в очереди RabbitMQ масштабировало нагрузку вверх, реализовать event-driven подход и масштабировать приложение не по метрикам утилизации ресурсов, а по факту появления новых событий от внешних систем.. Read more

0

Habr
Kamil_GR @ Habr 1 place · 09/17/2025 11:30 EDT

Why LLMs Drift into Convincing Nonsense (And a Practical Solution)

Imagine you have an idea powerful enough to change the world. Your tool of choice is a state-of-the-art LLM, ready to help you formalize the problem, generate hypotheses, and synthesize a solution. What you receive is a construct that is internally logical, elegant, and coherent... yet completely wrong. It's a mix of established facts, model-generated hallucinations, and your own subtle biases. With no way to test it in practice or... Read more

0

Habr
python_leader @ Habr 1 place · 09/19/2025 03:30 EDT

[Translation] Django Templates: всё, что вам нужно знать

Команда Python for Devs подготовила перевод большого туторила по Django Templates. В статье подробно разбирается, как устроен язык шаблонов Django, чем он отличается от Jinja, как правильно наследовать шаблоны и организовать структуру проекта. Если вы хотите сделать свои Django-приложения более чистыми, поддерживаемыми и быстрыми — этот материал для вас. Read more Read more

0

Habr
PatientZero @ Habr 2 place · 09/20/2025 09:21 EDT

[Translation] BlackBerry Curve: когда миром правили клавиатуры

Спустя два года после дебюта iPhone самым продаваемым телефоном в США было не чудо Apple с сенсорным экраном. Это был BlackBerry Curve. Вы спросите, как такое возможно? Разве iPhone не убил телефоны с клавиатурами? На самом деле, история чуть сложнее.Да, действительно, BlackBerry как бренд не пережил переход на телефоны с сенсорными экранами, но iPhone были не единственной причиной такого перехода. Чтобы понять, в чём заключалась привлекательность BlackBerry, важно вспомнить, как... Read more

0

Most popular sources

  • You see 609 news out of 609.
  • Sources 61 out of 61.
Business Insider 42% 2
Wired 9% 9
MacRumors 6% 2
Mashable 6% 2
Gizmodo 5% 0
View sources »

LIKE us on Facebook so you won't miss the most important news of the day!

22.09.2025 15:32
Last update: 15:25 EDT.
News rating updated: 22:20.

What is Times42?

Times42 brings you the most popular news from tech news portals in real-time chart.
Read about us in FAQ section.


Times42 © 2025