loads

Workloads, acceleration, and making Postgres better

#353 — April 29, 2020

Read on the Web

Postgres Weekly

7 Things That Could Be Improved in Postgres — As 1990s dance pop group D:Ream sang in 1994, Things Can Only Get Better.. including Postgres ???? Luckily these are all ‘nice to have’s but I dare say we’ll see some of them (such as automatic tuning and auto-vacuuming improvements) appear over time.

Kaarel Moppel

How The Citus Distributed Query Executor Adapts to a Postgres Workload — Citus is the popular extension for horizontally scaling Postgres and its query executor has seen some huge updates lately.

Citus Data (Microsoft)

eBook: The Most Important Events to Monitor in Your Postgres Logs — In this pganalyze eBook, we are looking at the Top 6 Postgres log events for monitoring query performance and preventing downtime.

pganalyze sponsor

Swarm64 DA 4.0: A Database Acceleration Extension for Postgres — Swarm64 started life as a FPGA-driven way to accelerate Postgres performance, but can now work without FPGAs too. This is not a free product but if you want to give it a run, there’s a trial or it can be spun up from the AWS Marketplace.

Yana Krasteva

Postgres Performance Goalposts — An interesting heuristic from Bruce here on what to do if you expect your connections, queries, or write queries to be above/below certain levels.

Bruce Momjian

A Tale of Password Authentication Methods in Postgres“Let’s say you want to implement a password authentication method in a client/server protocol..” Here’s the story of how Postgres came up with its approaches.

Peter Eisentraut

How to Set application_name When Using psql — As Craig says: “Setting your application name in Postgres is SO USEFUL. It will help a lot for debugging when you’ve got multiple different apps/services connecting to the same database.”

Denish Patel

How to Upgrade Postgres from v11 to v12 on Ubuntu 20.04 — Now that Ubuntu 20.04 is out, this might be on your mind!

Paolo Melchiorre

Working with Amazon Aurora PostgreSQL: What Happened to the Stats? — Apparently there’s a bug with numerous versions of Aurora PostgreSQL that causes certain stats to be lost on restart.

Michael Vitale

Postgres Vision 2020 - Free Online Conference (June 23-24) — Learn how today’s IT leaders are using Postgres. Join from anywhere in the world and listen from 30+ Postgres experts.

EnterpriseDB sponsor

A Deep Dive into PostGIS Nearest Neighbor Search — Take a deep dive into the Postgres and PostGIS internals to find out how K-nearest neighbor accelerates local search.

Martin Davis

My Favorite Postgres Extensions: Part One — A basic high level look at pg_partman and postgres_fdw.

Nawaz Ahmed

Kanel: Generate TypeScript Types from Postgres

Kristian Dupont

Postgres.app: The Easiest Way to Get Started with Postgres on the Mac — I’ve used this for years, it’s super popular, but if there’s just a handful of developers out there who’d benefit from it and don’t know about it, this reminder will be worth it :-) It continues to get very frequent updates.

Jakob Egger, Chris Pastl, and Mattt Thompson

???? Upcoming Events

All in-person events we had listed are cancelled or postponed due to the COVID outbreak, so we're now linking to webinars, livestreams, and similar online events.

If you have any, just hit reply and if it's Postgres related (and either free or not too expensive) we'll include it in a future issue. Just one this week:

  • ???? Postgres Vision 2020 on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks.

???? – requires e-mail address or registration
???? – costs money to participate




loads

Baidu's 'Facemoji Keyboard' hits over 30mn downloads


Baidu Facemoji Keyboard. Pic courtesy/YouTube

Chinese tech company Baidu, populary known as China's Google, on Monday said that its third party app "Facemoji Keyboard," has reached over 30 million downloads since its launch.

The keyboard, that is slowly gaining popularity in India, comes with emojis, GIFs, stickers and emoticons, and supports over 100 languages, out of which 22 are Indian dialects, Baidu said in a statement.

The "customisable" keyboard features voice-recognition for easy speech-to-text functionalities and themes designed for special occasions.

With "Facemoji Keyboard," Baidu expects to achieve a three times growth by the end of this year.

"Facemoji Keyboard" was first launched in Japan under the name "Simeji" in 2008.

Catch up on all the latest Mumbai news, crime news, current affairs, and also a complete guide on Mumbai from food to things to do and events across the city here. Also download the new mid-day Android and iOS apps to get latest updates

This story has been sourced from a third party syndicated feed, agencies. Mid-day accepts no responsibility or liability for its dependability, trustworthiness, reliability and data of the text. Mid-day management/mid-day.com reserves the sole right to alter, delete or remove (without notice) the content in its absolute discretion for any reason whatsoever





loads

TikTok tops 2 billion downloads

TikTok, the widely popular video sharing app developed by one of the world’s most valued startups (ByteDance), continues to grow rapidly despite suspicion from the U.S. as more people look for ways to keep themselves entertained amid the coronavirus pandemic. The global app and its Chinese version, called Douyin, have amassed over 2 billion downloads […]




loads

Run:AI brings virtualization to GPUs running Kubernetes workloads

In the early 2000s, VMware introduced the world to virtual servers that allowed IT to make more efficient use of idle server capacity. Today, Run:AI is introducing that same concept to GPUs running containerized machine learning projects on Kubernetes. This should enable data science teams to have access to more resources than they would normally […]




loads

TikTok tops 2 billion downloads

TikTok, the widely popular video sharing app developed by one of the world’s most valued startups (ByteDance), continues to grow rapidly despite suspicion from the U.S. as more people look for ways to keep themselves entertained amid the coronavirus pandemic. The global app and its Chinese version, called Douyin, have amassed over 2 billion downloads […]




loads

TikTok tops 2 billion downloads

TikTok, the widely popular video sharing app developed by one of the world’s most valued startups (ByteDance), continues to grow rapidly despite suspicion from the U.S. as more people look for ways to keep themselves entertained amid the coronavirus pandemic. The global app and its Chinese version, called Douyin, have amassed over 2 billion downloads […]




loads

Uber leads $170M Lime investment, offloads Jump to Lime

Lime has announced that it has raised a $170 million funding round. Uber is the leading investor with existing investors Alphabet, Bain Capital Ventures, GV and others also participating. The Information first reported on the new funding round before the official announcement. As part of the deal, Lime is also acquiring Uber’s micromobility subsidiary Jump. […]




loads

Jacqueline Jossa struggles to carry her bags as casually clad star loads up on groceries

Jacqueline Jossa was fulfilling some domestic duties as she headed to the shops for essentials on Wednesday.




loads

Hillary Clinton unloads on Trump and trolls his inauguration

Clinton launched a salvo at Donald Trump at an event in Washington D.C. where she accused him of bigotry, highlighting the Charlottesville violence, and mocked his notorious inauguration crowd.




loads

Natalya Wright sets jaws dropping as she uploads a raunchy series of topless photos

Natalya Wright, 19, showcased her svelte physique as she uploaded a raunchy shot on her Instagram on Tuesday as she posed topless.




loads

Jennifer Lawrence unloads her fabulous New York City bachelorette pad at a loss for $14 million

The actress tied the knot with Cooke Maroney in Newport, Rhode Island last month, and now is unloading her lavish Upper East Side penthouse for $14,250,000, according to the New York Post




loads

Australia edges closer to lifting coronavirus restrictions as app downloads surpass 4million

Australia is edging closer to lifting coronavirus restrictions as four million people download the tracing app.




loads

Malcolm Turnbull unloads on Scott Morrison in interview about bushfires and climate change

Malcolm Turnbull said the Prime Minister had misled Australians by downplaying the influence of global warming and climate change in a fiery interview with the BBC.




loads

George W. Bush unloads on Ted Cruz at private fundraiser for Jeb

Clearly, former President George W. Bush's presidential pick is his brother Jeb Bush, but his least favorite GOP candidate  – well, that would be Ted Cruz. 'I just don't like the guy,' he said.




loads

He's earning shed-loads! Ex-PM David Cameron's company made more than £800,000 profit last year

Mr Cameron earned £150,000 before quitting over his failure to see off Brexit, but that was small fry compared to his current income. And Mrs May has made almost £400,000 since leaving No10 in July.




loads

Donald Trump unloads on fired national security adviser John Bolton after getting rid of him

The president fired Bolton following clashes over U.S. policy in Iran, Russia and Afghanistan. But it was his advocacy in April of a 'Libya model' for dealing with North Korea was the final straw.




loads

Blac Chyna's fake pregnancy post: Star uploads then deletes ultrasound photo from ANOTHER WOMAN

The 31-year-old cosmetics mogul - real name Angela White - took to her Instagram on Tuesday to share the image which was captioned simply:  'Blessed 2020.'




loads

TOWIE's Samantha Faiers uploads hilarious impersonation of Tiger King's Carole Baskin

Sam Faiers, 29, who first came to screens on The Only Way is Essex, uploaded a video of herself lip-syncing to Baskin's famous greeting to her internet followers.




loads

Flush your toilet with rain - and save bucketloads!

Making home improvements to save money is still possible with a little bit of imagination - and online ordering. Toby Walne looks at all your options.




loads

Wave mechanics and wave loads on marine structures / Paolo Boccotti

Online Resource




loads

Design aids of offshore structures under special environmental loads including fire resistance / Srinivasan Chandrasekaran, Gaurav Srivastava

Online Resource




loads

Chloride-induced steel corrosion in concrete under service loads / Hailong Ye, Chuanqing Fu, Ye Tian, Nanguo Jin

Online Resource




loads

1,100 truckloads stabilise potato market in state

A truck can carry up to 10 tonnes of potato.




loads

Cytotoxic payloads for antibody--drug conjugates / edited by David E. Thurston and Paul J.M. Jackson

Online Resource




loads

Rain Loads: Guide to the rain load provisions of ASCE 7-16 / by Michael O'Rourke, et al

Online Resource




loads

Seismic loads: guide to the seismic provisions of ASCE 7-16 / Finley A. Charney, Ph.D., P.E., Thomas F. Heausler, P.E., S.E., Justin D. Marshall, Ph.D., P.E

Online Resource




loads

TikTok hits 2 bn downloads; becomes most installed app amid Covid-19 crisis

In India, the short video making app leads the chart with more than 600 million downloads or about 30.3 per cent of all unique installs




loads

An exploration of the lumbar loads and affective responses to lumbar pain on lower limb amputees who use a prosthesis




loads

The effect of hummingbird feeders on the pollen loads and diversity in nectarivorous bats (Glossophaginae) in a tropical cloud forest




loads

A comparison of hemoparasite loads between bats (F : Phyllostomidae) of different feeding guilds in San Luis, Costa Rica




loads

Power system loads and power system stability Yue Zhu

Online Resource




loads

Western Railway loads 6.14 million tonnes of essential goods amid COVID-19 lockdown

As the nation observes the COVID-19 lockdown to stop the spread of COVID19, it is the frontline warriors who ensure the supply of essential goods and services. Western Railway (WR) has made a significant contribution to serve the nation amid lockdown. So far, 3258 rakes have been loaded amounting to 6.14 million tons of essential goods to different states including the North East region.




loads

India tops the charts for Zoom downloads in April: Report

India was the biggest market for Zoom in April in terms of downloads according to Sensor Tower.According to a report by GadgetsNow, the video-conferen




loads

Wind loads: guide to the wind load provisions of ASCE 7-16 / William L. Coulbourne, P.E., T. Eric Stafford, P.E

Online Resource




loads

Here’s why you should have loads of cucumber raita this summer