Tag: row

Feed: Planet PostgreSQL. Write-Ahead Logs is a critical part of PostgreSQL, that ensures data durability. While there are multiple configuration parameters , there was no easy to monitor WAL activity, or what is generating it. New infrastructure to track WAL activity commit df3b181499b40523bd6244a4e5eb554acb9020ce Author: Amit Kapila Date: Sat Apr 4 10:02:08 2020 +0530 Add infrastructure to track WAL usage. This allows gathering the WAL generation statistics for each statement execution. The three statistics that we collect are the number of WAL records, the number of full page writes and the amount of WAL bytes generated. This helps the users who ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here.  13. Configure MySQL Server ProperlyComplexity:MediumPotential Impact: High A poorly configured MySQL Server can cause severe issues, especially under high load during a traffic spike, yet getting the basics right is not that hard. While MySQL Server has more than 400 variables you can tune, you rarely need to change more than 10-20 of them to get 95% of the possible performance for ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. If you needed an on-premises data warehouse today, would you choose a version of Postgres released in 2005 (Postgres 8.0.2)? How about a version of MySQL released in 2005 (MySQL 5.0.15)? Perhaps you’d ask Oracle if you could use Oracle Database 10g Release 2 even though it was released in 2005 and reached end-of-life a decade ago?I didn’t think so. You know better, and so do I. Amazon? Not so much. They built Redshift on ParAccel Analytic Database (PADB) in 2013, itself built on Postgres 8.0.2. ParAccel would go on to be acquired by ... Read More

Feed: SAS Blogs. Author: Celeste Cooper-Peel, MA, MCHES, E-RYT, CWHC, CYT. Being in nature helps my body, mind and spirit.  How about you?  I also have felt the difference in my stress levels as I sink my feet into the sand at the beach and just smell the salt air.  Is it vacation that does this or is it Earthing? Earthing (also called Grounding) refers to simply connecting the body to the electrical energy of Mother Earth.  Over the last decades, humans are benefiting from the Industrial Revolution but also experiencing things such as exposure to electromagnetic fields (EMFs).  While ... Read More

Feed: R-bloggers. Author: Mirai Solutions. [This article was first published on Mirai Solutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. XLConnect 1.0.1 now available from We are pleased to announce the release of XLConnect 1.0.1. This release is mainly a maintenance release and comes with the following changes: Upgrade to Apache POI 4.1 Adapt Java implementation to make use of Java 8 and remove some dependencies Remove dependency on XLConnectJars, download required ... Read More

Feed: R-bloggers. Author: HighlandR. [This article was first published on HighlandR, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. fast, flexible census tables – Counting patients is hard Blimey. It’s over 3 years since I collaborated with Neil Pettinger on some plots to demonstrate patient flow, using R. What started out as a supposed quick blog post morphed into several weeks of work, a blog post, workshops in Perth and Birmingham, and a ... Read More

Feed: R-bloggers. Author: An Accounting and Data Science Nerd's Corner. Downloading and data cleaning Downloading the data form the Oxford homepage is straightforward. Automatic column detection by read_xlsx() fails so I provide columns manually. suppressPackageStartupMessages({ library(kableExtra) library(dplyr) library(tidyr) library(lubridate) library(tidycovid19) library(ggplot2) library(stringr) library(readxl) library(gghighlight) library(RCurl) }) dta_url The file is organized by country-date and sorted by date. As in essence interventions data is event driven for each country (meaning that interventions happen infrequently at certain dates), I sort the data by country-date to get a better view on its structure. Also, I adjust some names and concentrate on the policy ... Read More

Feed: Planet PostgreSQL. I really love what Debian did to make Postgres administration tasks easier. However, when I was writting the article “What’s wrong with Postgres?", I found something unexpected in my Ubuntu server.I was trying to find Postgres logfile, so I tried postgres=# select pg_current_logfile(); pg_current_logfile -------------------- (1 row) But, I know that, by default, I’ll find my logs under /var/log/postgresql, and sure enough: [root@elinor] ll /var/log/postgresql/ drwxrwxr-t 2 root postgres 4096 Apr 4 13:08 ./ drwxrwxr-x 10 root syslog 4096 Apr 4 12:45 ../ -rw-r----- 1 postgres adm 563 Apr 4 13:08 postgresql-12-elinor.log So, how did my wrapper ... Read More

Feed: Planet PostgreSQL. Depending on your workload, the planning time can represent a significant part of the overal query procesing time. This is especially import in OLTP workload, but OLAP queries with numerous tables being joined and an aggressive configuration on the JOIN order search can also lead to hight planning time. Planning counters in pg_stat_statements Previously, pg_stat_statements was only keeping track of the execution part of a query processing: the number of execution, cumulated time, but also minimum, maximum, mean and also the standard deviation. With PostgreSQL 13, you’ll also have those metrics for the planification part! commit 17e03282241c6ac58a714eb0c3b6a8018cf6167a ... Read More

Feed: R-bloggers. Author: Unknown. [This article was first published on Deeply Trivial, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. For the letter D, I’m going to talk about the dummy_cols functions, which isn’t actually part of the tidyverse, but hey: my posts, my rules. This function is incredibly useful for creating dummy variables, which are used in a variety of ways, including multiple regression with categorical variables. When conducting linear regression, the ... Read More