spraci.info

Search

Items tagged with: postgres

#PostgreSQL 12 boosts open source #database performance

https://searchdatamanagement.techtarget.com/news/252472281/PostgreSQL-12-boosts-open-source-database-performance Sean Michael Kerner on #postgres #psql #db
 
#PostgreSQL considers seccomp() filters
https://lwn.net/Articles/800916/ #psql #postgres #db
 
...preparing a long article about #epo as it's a very slow news day for #gnu #linux apart from #postgres release
 
Using #PostgreSQL as a cache? http://renesd.blogspot.com/2019/10/using-postgresql-as-cache.html #postgres #psql (release imminent)
 

Question for other Podmins


I have two questions actually...
1. Where is the guide to convert MySQL to PostgresSQL?
2. Does configuring Redis increase loading speed on your pod or what exactly does it do (it currently is not enabled on my pod)?

#question #podmin #redis #mysql #postgres #postgressql #podminseekingpodmin
 
Abandoning #Oracle for an open source alternative https://www.cbronline.com/opinion/postgres-in-house-bruce-momjian #postgres #mysql
Should I Support Postgres In-House?
 
pgcli: Release v2.1.0
http://pgcli.com/v2.1.0.html
" #Pgcli is a command line interface for #Postgres #database that does auto-completion and syntax highlighting." #freesw #db
 
We're back, and now running with postgres, with major thanks to this blog post by @Brad Koehn ☑️.

Unfortunately, it looks like the migration script didn't encode emoji correctly, so they're now appearing as question marks (?). However, the database does support storing emoji, so if you had any in your profile you can edit it to put them back. Otherwise, everything appears to be functioning well!

#gibberfish #database #postgres #migration #maintenance
 
Somehow I missed that #postgres 11.2 had dropped. It's fully compatible with 11.1 databases, no need to dump and restore.

#postgresql
 
#postgres story
 

Hubzilla


Meine Hubzilla VM verlangsamt mein ganzes System. Eigentlich ist es die Hubzilla Datenbank. Meine Festplatte ist die ganze Zeit beschäftigt und der io wait daher immer über 50%.
Mysql tunen hat auch nichts gebracht.
Am Anfang lief alles gut mit 256-512MB Ram. Jetzt werden teilweise schon über 2GB gebraucht und alles läuft wie ein Sack Nüße.
Ich werde wohl die VM noch mal aufsetzen und dieses mal eine Postgres DB nehmen.
Hat jemand mit Hubzilla und Postgres erfahrung? (Anleitung oder Tipps?)

#Hubzilla #DB #Postgres #Mariadb #Mysql
 
Added documentation and some supporting scripts to my #Postgres #WAL-G #Docker image. Mostly I did this so I don't have to try to remember how to recover a database while I'm stressed out, but you can benefit from my labors too.

If you'd like a dead simple solution for continuously streaming backups of your Postgres database to #S3-compatible storage, this is for you. Even if you don't use Docker, feel free to copy the scripts into your own setup; there's no excuse for not having point-in-time backups these days!

https://gitlab.koehn.com/docker/postgres-wal-g

You can get the image on Docker Hub.
 
I managed to set up #duply for backups on my #kubernetes #NFS server, so everything gets backed up to the cloud. Well, to another cloud ( #S3, encrypted with #GPG).

All my #Postgres databases back themselves up to S3 using wal-g streaming archives. There's no state there that isn't backed up within an hour.
 
Back up your #Diaspora #postgres database to #S3-compatible hosts using WAL-G. Fast, painless, and largely automatic once you set it up.
 

Show HN: Pg-extend-rs, easy Postgres extensions in Rust


A project to make Postgres extensions in Rust easy, you might learn how to use macro_rules, attribute macros, allocators and some FFI in this post There were a few things that happened this year that…
Article word count: 2895

HN Discussion: https://news.ycombinator.com/item?id=18776589
Posted by bluejekyll (karma: 5969)
Post stats: Points: 114 - Comments: 13 - 2018-12-28T13:33:18Z

\#HackerNews #easy #extensions #pg-extend-rs #... Show more...
 

Bye Bye Mongo, Hello Postgres


In April the Guardian switched off the Mongo DB cluster used to store our content after completing a migration to PostgreSQL on Amazon RDS. This post covers why and how
Article word count: 3411

HN Discussion: https://news.ycombinator.com/item?id=18717168
Posted by philliphaydon (karma: 2149)
Post stats: Points: 250 - Comments: 29 - 2018-12-19T17:08:53Z

\#HackerNews #bye #hello #mongo #postgres
Article content:

... Show more...
 

At 22 years old, Postgres might just be the most advanced database yet


As a techy, many of the debates I engage in can be boiled down to just one question: Should we pick the new thing or the proven one? As passionate as this question is discussed, there are a handful of…
Article word count: 757

HN Discussion: https://news.ycombinator.com/item?id=18610601
Posted by max_sendfeld (karma: 347)
Post stats: Points: 244 - Comments: 106 - 2018-12-05T17:49:46Z

\#HackerNews #advanced #database #just #... Show more...
 

How Postgres is more than a relational database: Extensions


Extensions allow Postgres to be customized and extended in powerful new ways. Here we find a tour of extensions and how they can make Postgres into much more than a relational database
Article word count: 1339

HN Discussion: https://news.ycombinator.com/item?id=18555276
Posted by yannikyeo (karma: 514)
Post stats: Points: 113 - Comments: 24 - 2018-11-28T20:23:12Z

\#HackerNews #database #extensions #how #more... Show more...
 
[unknown]@ [unknown]LOG: could not accept SSL connection: Success
Uhhh wth #postgres.. it's not success if you didn't accept it. These are being spammed to my not-so-well performing server :/

https://www.reddit.com/r/PostgreSQL/comments/8gzmfe/logspam_could_not_accept_ssl_connection_success/

Image/photo

Server is spiking on IO wait a lot and things get slow. Any postgres experts for some tuning advice? Currently I'm mostly running on defaults, the only thing I've bumped up is effective_cache_size. I tried some other combos like tweaking shared_buffers and such but things generally only get worse. I have 16GB RAM on the server and it is hardly used. The server has 4 cores. I have quite a few apps using this server so lots of connections. Thinking maybe that is the problem?

#help #sysadmin #question
 

How to Manage Connections Efficiently in Postgres, or Any Database


Hitting the limit for maximum allowed connections is a common operational problem in Postgres. Here we look at a few techniques for managing connections and making efficient use of those that are…

HN Discussion: https://news.ycombinator.com/item?id=18220906
Posted by bgentry (karma: 4196)
Post stats: Points: 207 - Comments: 25 - 2018-10-15T16:08:12Z

\#HackerNews #any #connections #database #efficiently #... Show more...
 
It's interesting how much easier I can rest having better #diaspora database backups. I switched to using continuous archiving, which allows me to do point-in-time recovery and playback in case of a hack or a bad upgrade.

My main objective was a less intensive backup process than running pg_dump every hour, which this certainly is: my system's performance takes no hit when the offsite rsnapshot backups occur, because it only needs to copy the new files (I could also copy them offsite immediately, but haven't gotten around to it yet). Each month I create a new "base backup" from which a new set of streaming backups are applied.

If you're using a #Postgres database for your pod, and you haven't set up a backup yet, the instructions in the link above are easy to follow and will let you sleep easier. Yours wouldn't be the first pod to disappear due to database loss.
 

Postgres 11 – a First Look


Postgres 11 is almost here, in fact the latest beta shipped today, and it features a lot of exciting improvements. If you want to get the full list of features it is definitely worth checking out the…
Article word count: 796

HN Discussion: https://news.ycombinator.com/item?id=18043425
Posted by samaysharma (karma: 1368)
Post stats: Points: 212 - Comments: 87 - 2018-09-21T23:28:47Z

\#HackerNews #first #look #postgres
Article content:

Postgres 11 is almost here, in fact the latest beta shipped tod... Show more...
 
It takes a while to install the North American #OpenStreetMaps database into #Postgres. So far it's up to 340M nodes and counting.
 
In all my mucking about with my #Postgres #database, I discovered I had a corrupt #toast table. Not knowing what this was or how to recover it, I did some searching and found and article that (eventually) got the issue fixed. I had to manually recover the text of ten posts from #backups because they'd been lost, but that's what backups are for.
 
An easy way to do some simple tuning of your #Postgres database. Worked pretty well for me.
 
Hey everyone, I’m #newhere. I’m interested in #humor, #javascript, #linux, #postgres, #python, #sci-fi, and #vuejs.

Saw an blog article by one of the people who made diaspora saying to never use mongodb. I was looking for database articles but found the distributed aspect of diaspora is really intriguing, especially given all the censorship news lately, so i thought i would poke around and see what is up.
 

A Missing Link in Postgres 11: Fast Column Creation with Defaults


How a seemingly minor enhancement in Postgres 11 fills one of the system's biggest operational holes.

HN Discussion: https://news.ycombinator.com/item?id=17864837
Posted by grzm (karma: 7596)
Post stats: Points: 86 - Comments: 9 - 2018-08-29T02:11:28Z

\#HackerNews #column #creation #defaults #fast #link #... Show more...
 

Show HN: Graphql-engine: Fast, instant GraphQL APIs on Postgres


graphql-engine - Blazing fast, instant GraphQL APIs on Postgres with fine grained access control
Article word count: 43

HN Discussion: https://news.ycombinator.com/item?id=17540263
Posted by tango12 (karma: 101)
Post stats: Points: 142 - Comments: 41 - 2018-07-16T10:58:24Z

\#HackerNews #apis #fast #graphql #graphql-engine #instant #postgres #show
Article content:

Image/photo

You can’t perform that action at this time.

You signed in with another tab or window. [1]Reload to refresh your session. You signed out in another tab or window. [2]Reload to refresh your session.

Press h to open a hovercard with more details.

References

Visible links
1. file:///dev/
2. file:///dev/

HackerNewsBot debug: Calculated post rank: 108 - Loop: 125 - Rank min: 100 - Author rank: 16
 
#diaspora #Linux #postgreSQL

For whatever reason, my Diaspora* pod was slower and slower. I updated #Postgres from v9.5 to v10 and increased the allocated memory. If you see any trouble, please warn me.

Pour je ne sais quelle raison, mon pod Diaspora* était de plus en plus lent. J'ai mis à jour #Postgres de la version 9.5 à la 10 et ai alloué plus de mémoire. Si vous constatez quelque problème que ce soit, contactez-moi s'il vous plaît.
 

Ask HN: Have you ever chosen Postgres over Mongo and regretted it?


The past 2 years seem to have been the death knell for Mongo and the "NoSQL" hype, with Mongo moving toward SQL parity and SQL databases supporting JSON storage, like Postgres with JSONB.

At this point it seems that there are very few workloads for which Mongo is the best option compared to Postgres+JSONB. I'm wondering...

1) Have you ever chosen Postgres over Mongo, and regretted it? Why? Did you end up switching to Mongo? Was it better?

2) Can anyone name a use case where Mongo is clearly a better choice than Postgres+JSONB?

HN Discussion: https://news.ycombinator.com/item?id=17497164
Posted by chatmasta (karma: 9532)
Post stats: Points: 138 - Comments: 73 - 2018-07-10T11:37:34Z

\#HackerNews #and #ask #chosen #ever #have #mongo #over #postgres #regretted #you
HackerNewsBot debug: Calculated post rank: 116 - Loop: 227 - Rank min: 100 - Author rank: 31
 

Postgres 11 Beta 1 released


Posted on 2018-05-24 by PostgreSQL Global Development Group The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 11 is now available for download. This release…
Article word count: 925

HN Discussion: https://news.ycombinator.com/item?id=17144221
Posted by hardwaresofton (karma: 3587)
Post stats: Points: 133 - Comments: 42 - 2018-05-24T14:22:54Z

\#HackerNews #beta #postgres #released
Article content:

Posted on 2018-05-24 by PostgreSQL Global Development Group

The PostgreS... Show more...
 
Don't buy, download
http://redmonk.com/sogrady/2018/05/22/should-red-hat-buy-or-build-a-database/
Use #freesw
#mariadb and #postgres are both mature and reliable for just about any case or use case
Should Red Hat Buy or Build a Database?
 
#Diaspora #Ubuntu

hello #podmins,

My Diaspora* node runs on a Ubuntu 16.04 LTS server.
I could update to 18.04.
- Will there be any gain? (maybe with a new version of #Postgres?)
- Will this work fine or will the upgrade process be a pain in the back?

Did anybody try this?
 

Recursive Common Table Expressions in Postgres


Common Table Expressions in PostgreSQL are a powerful SQL construct. You can think of CTEs as a view that is materialized only while the query is running. Recursive CTEs allow themselves to be called…
Article word count: 787

HN Discussion: https://news.ycombinator.com/item?id=17124672
Posted by jesperht (karma: 445)
Post stats: Points: 143 - Comments: 55 - 2018-05-22T09:20:36Z

\#HackerNews #common #expressions #postgres #... Show more...
 
Built-in Sharding for #PostgreSQL
https://rhaas.blogspot.com/2018/05/built-in-sharding-for-postgresql.html
#psql #postgres
 
#PostgreSQL visits #LSFMM
https://lwn.net/Articles/752952/ #linux #db #postgres #psql
 
Currently I have one big server to handle all my web app needs, including DB, Redis, etc to support those. It's becoming a bit bogged down due to I/O. So, planning to spread out a bit.

What I can't decide is whether to have one #Postgres DB for all the apps on a larger server OR have multiple (smaller) servers and a #Docker Postgres for each app separately on the same server.

Opinions? :)

#selfhosted #sysadmin
 
Has the time finally come for PostgreSQL? https://www.zdnet.com/article/has-the-time-finally-come-for-postgresql/ loaded headline from #microsoft -sponsored #cbs #zdnet
#psql or #postgres or #PostgreSQL has been good for a DECADE
 
Later posts Earlier posts