@fromdual.bsky.social
What is the quickest way to load data into the #database?
We recently analysed this for #MariaDB / #MySQL and #PostgreSQL and showed that the simplest method is not the fastest.
You can see more details and the results here: www.fromdual.com/blog/load-da...
We recently analysed this for #MariaDB / #MySQL and #PostgreSQL and showed that the simplest method is not the fastest.
You can see more details and the results here: www.fromdual.com/blog/load-da...
February 11, 2026 at 1:40 PM
What is the quickest way to load data into the #database?
We recently analysed this for #MariaDB / #MySQL and #PostgreSQL and showed that the simplest method is not the fastest.
You can see more details and the results here: www.fromdual.com/blog/load-da...
We recently analysed this for #MariaDB / #MySQL and #PostgreSQL and showed that the simplest method is not the fastest.
You can see more details and the results here: www.fromdual.com/blog/load-da...
#MariaDB has completely ruined the concept of the dynamically configurable #InnoDB buffer pool!
And this within a long-term support release series. To prevent this from affecting your production environment, I have described it:
www.fromdual.com/blog/mariadb...
Image Author: Cplakidas, GNU FDL v1.2
And this within a long-term support release series. To prevent this from affecting your production environment, I have described it:
www.fromdual.com/blog/mariadb...
Image Author: Cplakidas, GNU FDL v1.2
February 9, 2026 at 7:18 PM
#MariaDB has completely ruined the concept of the dynamically configurable #InnoDB buffer pool!
And this within a long-term support release series. To prevent this from affecting your production environment, I have described it:
www.fromdual.com/blog/mariadb...
Image Author: Cplakidas, GNU FDL v1.2
And this within a long-term support release series. To prevent this from affecting your production environment, I have described it:
www.fromdual.com/blog/mariadb...
Image Author: Cplakidas, GNU FDL v1.2
Someone is deleting my shared memory segments!
With #PostgreSQL under myEnv we regularly get shared memory segment errors:
FATAL: could not open shared memory segment "/PostgreSQL.4220847662":
I have described why this happens here:
www.fromdual.com/blog/deleted...
With #PostgreSQL under myEnv we regularly get shared memory segment errors:
FATAL: could not open shared memory segment "/PostgreSQL.4220847662":
I have described why this happens here:
www.fromdual.com/blog/deleted...
February 8, 2026 at 9:31 AM
Someone is deleting my shared memory segments!
With #PostgreSQL under myEnv we regularly get shared memory segment errors:
FATAL: could not open shared memory segment "/PostgreSQL.4220847662":
I have described why this happens here:
www.fromdual.com/blog/deleted...
With #PostgreSQL under myEnv we regularly get shared memory segment errors:
FATAL: could not open shared memory segment "/PostgreSQL.4220847662":
I have described why this happens here:
www.fromdual.com/blog/deleted...
Load CSV files into the database
Proof of concept how to load data from a CSV file into a #MariaDB/#MySQL or #PostgreSQL database to display locations on an #OpenStreeMap map with #Leaflet.
www.fromdual.com/blog/load-cs...
Proof of concept how to load data from a CSV file into a #MariaDB/#MySQL or #PostgreSQL database to display locations on an #OpenStreeMap map with #Leaflet.
www.fromdual.com/blog/load-cs...
February 7, 2026 at 8:41 AM
Load CSV files into the database
Proof of concept how to load data from a CSV file into a #MariaDB/#MySQL or #PostgreSQL database to display locations on an #OpenStreeMap map with #Leaflet.
www.fromdual.com/blog/load-cs...
Proof of concept how to load data from a CSV file into a #MariaDB/#MySQL or #PostgreSQL database to display locations on an #OpenStreeMap map with #Leaflet.
www.fromdual.com/blog/load-cs...