Notices tagged with postgresql
-
Embed this notice
Linux Walt (@lnxw37j1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw37j1@gnusocial.jp)'s status on Saturday, 30-Mar-2024 10:34:43 JST Linux Walt (@lnxw37j1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} #SPC is closing and moving to another domain because of some database performance issues. The idea is that starting over will mean a much smaller database and a much smaller number of outside connections, and therefore should reduce or eliminate the database overtaxing.
The Pleroma dev team has been engaged, and has found several performance improvements that will soon be available to all instances.
https://shitposter.club/notice/AgMHxZ8s8zH2zwJZrs
#Pleroma #PostgreSQL -
Embed this notice
Helge Heß (helge@mastodon.social)'s status on Saturday, 23-Mar-2024 13:57:28 JST Helge Heß Did you know that you can write #PostgreSQL stored procedures in #SwiftLang? "Bringing Swift to the Backend of the Backend’s Backend!"
http://www.alwaysrightinstitute.com/plswift/ -
Embed this notice
Rimu (rimu@mastodon.nzoss.nz)'s status on Friday, 01-Mar-2024 19:19:50 JST Rimu Added full-text search to #PieFed today.
After reading a massive tome about #ElasticSearch earlier this week I realised it was complete overkill and just used the full-text capabilities of #PostgreSQL instead.
Currently PieFed has 46,000 posts and results are fast. It'll be interesting to see how well it copes when there are more posts. Anyone want to make a guess when it'll bog down?
In conversation from mastodon.nzoss.nz permalink -
Embed this notice
Paolo Melchiorre 🏖️ (paulox@fosstodon.org)'s status on Tuesday, 19-Dec-2023 20:58:21 JST Paolo Melchiorre 🏖️ Dear #Fediverse, I ask you for #help 🌌
Recommend me some #books to buy on 📚
• #Python (language)
• #Django
• #Accessibility (#web)
• #PostgreSQL
• #ArtificialIntelligence
• #DesignPatterns
• #FreeSoftware
• #OpenSourceI'd like to have 🪪
• author
• title
• suggestion reason
• purchase URLI prefer #ePUB (more than Amazon and content with DRM), but #paperback is fine if there are no alternatives ✨
Thank you 🙏
P.S. It's fine to propose books that you've written 👍
P.P.S. #boost please 🔁
In conversation from fosstodon.org permalink -
Embed this notice
sumiyaki (sumiyaki@misskey.cloud)'s status on Monday, 06-Nov-2023 23:36:43 JST sumiyaki 0.18.5に更新した #Lemmy サーバはまあ順調に連合しているみたい。インスタンスのリストに相手のバージョンが表示されつつある。一部のサーバとしか連合していないけど、これが世界に広がっていったら #PostgreSQL のDBとかは肥大化していくのだろうか?
In conversation from misskey.cloud permalink -
Embed this notice
sumiyaki (sumiyaki@misskey.cloud)'s status on Sunday, 05-Nov-2023 02:05:03 JST sumiyaki #Lemmy はなんとか更新ができた、と思う。連合に関して問題がありそうで心配。
古い方のpostgresだけdocker composeで起動。bashで中にはいる。pg_dumpでbackup。
新規のpostgresのみ起動、bashで中に入り、psqlでrestore。pg_restoreができなかった。コマンドとしては、
docker compose run -d -v $(pwd):/tmp postgres
docker compose exec postgres /bin/bash
pg_dump -d lemmy -U lemmy >/tmp/lemmy-postgres.sql
------------------------------------------------
docker compose run -d -v $(pwd):/mnt postgres
docker compose exec postgres /bin/bash
psql -U lemmy -d lemmy -f /mnt/lemmy-postgres.sql
#Docker も #PostgreSQL も全く分かってないので大苦労。コマンドの使い方がわかってないので沢山のエラーに悩まされた。In conversation from misskey.cloud permalink -
Embed this notice
sumiyaki (sumiyaki@misskey.cloud)'s status on Saturday, 04-Nov-2023 12:07:03 JST sumiyaki 次は、以前のsubdomain、管理者とかパスワードなど、さらにdbの内容を戻したり書き込めばうまく行く、と思いたい。また後でやろう。#Lemmy #PostgreSQL
In conversation from misskey.cloud permalink -
Embed this notice
sumiyaki (sumiyaki@misskey.cloud)'s status on Saturday, 04-Nov-2023 11:59:57 JST sumiyaki 結局、#Lemmy は
https://github.com/LemmyNet/lemmy/releases/tag/0.18.5
https://github.com/LemmyNet/lemmy/archive/refs/tags/0.18.5.tar.gz
からdockerだけ抜き出した。
https://github.com/LemmyNet/lemmy/blob/main/config/defaults.hjson
もpostgresのpasswordで参考にした。
lemmy.hjson
docker-compose.yml
の編集。
lemmy.hjsonのdatabaseのところにpassword:の行を追加。
mkdir -p volumes/pictrs
cd volumes
chown -R 991:991 pictrs
nohup docker compose up &
これでなんとか正しく起動したみたい。
nohupは吐かれるlogが多いので記録するため。
本番は
docker compose up -d
になるはず。#docker #postgres #PostgreSQLIn conversation from misskey.cloud permalink Attachments
-
Embed this notice
SolSoCoG (solsocog@ieji.de)'s status on Thursday, 26-Oct-2023 01:18:53 JST SolSoCoG Any tips on why 50 mastodon pull requests cause postgres to max out a 16x5,4ghz cpu? #mastoadmin #postgresql . The db is going since 2017 and went through some postgres updates, now at version 16. Did I miss some mandatory postgres db care instructions? I mean the queue is being dealt with but its quite a horrendous cpu usage imho.
In conversation from ieji.de permalink -
Embed this notice
sumiyaki (sumiyaki@plr.ph3j.com)'s status on Wednesday, 25-Oct-2023 23:26:42 JST sumiyaki うちの #Pleroma とそのDBのメンテを明日ぐらいからやるかもしれない。
実行する直前にまた連絡するつもり。
https://maintenance.ph3j.com/
にて記す予定。
DBのテーブルの一部をpsqlでdownloadしたし、投稿した記事や通知などもAPI+pythonスクリプトも使いdownloadした。
あとは #postgresql のdumpと
pleromaでのremote発の古い記事のpruneとdump/restore。
まずはそこまでできるかな。In conversation from plr.ph3j.com permalink Attachments
-
Embed this notice
sumiyaki (sumiyaki@plr.ph3j.com)'s status on Thursday, 19-Oct-2023 21:33:46 JST sumiyaki #Pleroma の更新でやることは、
1. PleromaのDBの一部のテーブルをCSVでCOPY
2. 自分の書き込みや通知をdownload
3. DBの全体バックアップ
4. Pleromaの古いリモートの記事に削除フラッグ
5. DBのvacuu full
6. Pleromaの更新
というシナリオでやるつもり。
今、1は終わっている。
最初の問題は #Postgresql のDBのvacuum fullのところ。DBのサイズは16GBくらいで、ディスクの空き容量は(工面して)7GBくらい。 #Vacuum がうまくできるかどうか?
それについて、いろいろと考えたけど、DBを #backup / #restore したら、自動的に削除フラッグがついたデータは書き戻されなくて実質的にvacuumになるのではないか?
それをググったりしたけど、いまいちわからない。BardとかBing+ChatGPTにでも聞いてみるかな。
分かる方いらっしゃったら、教えてください。In conversation from plr.ph3j.com permalink -
Embed this notice
John Shaft (shaft@piaille.fr)'s status on Wednesday, 04-Oct-2023 23:55:43 JST John Shaft Et hop, cluster #PostgreSQL de ma machine de supervision mis à jour vers la version 16. 🐘
In conversation from piaille.fr permalink -
Embed this notice
洪 民憙 (Hong Minhee) (hongminhee@todon.eu)'s status on Thursday, 21-Sep-2023 07:34:51 JST 洪 民憙 (Hong Minhee) Has anyone used #Neon, a serverless #PostgreSQL offer? I'm curious what the experience has been like using it.
In conversation from todon.eu permalink -
Embed this notice
diazcarrete@hachyderm.io's status on Wednesday, 20-Sep-2023 09:31:19 JST DiazCarrete The #Rel8 #Haskell library lets you construct #Postgresql #SQL queries using a monadic interface.
"Rel8 has a fairly unique feature in that it’s able to return not just lists of rows, but can also return trees."
https://rel8.readthedocs.io/en/latest/cookbook.html#tree-like-queries
In conversation from hachyderm.io permalink Attachments
-
Embed this notice
keithzg (keithzg@fediverse.keithzg.ca)'s status on Thursday, 03-Aug-2023 09:55:06 JST keithzg I am having an absolutely terrible time trying to get ActiveState Perl installed. Literally my opinion of #PostgreSQL has dropped dramatically due to it being a stated requirement for Windows builds, it's that unacceptably bad... In conversation from fediverse.keithzg.ca permalink -
Embed this notice
keithzg (keithzg@fediverse.keithzg.ca)'s status on Thursday, 03-Aug-2023 09:55:01 JST keithzg Abandoned ship, though I remain very very curious how this was considered reasonable by anyone. Though in fairness these days as soon as I see a .yaml file anywhere I tend to go “oh, shit, this is some software with insane build and usage nonsense that only corporate devs think is remotely acceptable”.
Conversely, #StrawberryPerl installed very easily and obviously, and all I needed to do was add its bin folder to my %PATH% et voila, it built the part of PostgreSQL I needed to build just fine.
Seems pretty silly the #PostgreSQL docs recommend, borderline insist, on using ActiveState Perl when Strawberry Perl provides #Perl in a far more “actually provides it to you” way :P
In conversation from fediverse.keithzg.ca permalink -
Embed this notice
Stéphane Bortzmeyer (bortzmeyer@mastodon.gougere.fr)'s status on Monday, 24-Jul-2023 15:46:46 JST Stéphane Bortzmeyer C'est quand même génial, comme juste d'ajouter deux index à #PostgreSQL fait passer une tâche cron de trois jours à un quart d'heure.
In conversation from mastodon.gougere.fr permalink -
Embed this notice
Gytis Repečka (gytis@fedi.lt)'s status on Friday, 21-Jul-2023 15:31:28 JST Gytis Repečka @aral @jan It is insanely bad query programming to have 3.5k IDs in WHERE clause 🤯 Considering table is properly indexed and vacuumed, I would split them into 100-200 microbatches and if each involves pinging a separate server of a follower account, even make those batches smaller. LIMIT and OFFSET should be the start from database side and then some task queueing from backend 🧐 #postgresql #sql #performance :postgresql:
In conversation from fedi.lt permalink -
Embed this notice
Federico Campoli :postgresql: (4thdoctor_scarf@fosstodon.org)'s status on Saturday, 08-Jul-2023 12:01:59 JST Federico Campoli :postgresql: DBA a life in the shadows
Database administration is weird. The job is a strange combination of theory and practice, strictness and loose rules mixed together in a magic blend.The DBA is probably one of the most obscure and one of the less appreciated roles within the IT organisations.
Today is the day to say thank you to your DBA!
#dba #dbaday #databaseadministration #postgresql #mysql #oracle #sqlserver #firebird
In conversation from fosstodon.org permalink -
Embed this notice
堂場きみ子@ボッチ鯖 (kimiko_dover@kimikodover.ddns.net)'s status on Monday, 22-May-2023 20:03:45 JST 堂場きみ子@ボッチ鯖 【 #Mastodon を構成する技術要素 】
下記記事で勉強中。。。。🤔
https://handon.hatenablog.jp/entry/2018/12/18/004652
(引用)
要素名 ソフトウェア名 概要
web server #nginx HTTP/HTTPSリクエスト処理
web #rails Web処理(通常処理)
streaming #Node.js Web処理(Userstreamのみ)
media #swift 画像やカスタム絵文字の格納
db #postgresql アカウント情報やトゥートの格納
cache #redis キューキャッシュ
job queue #sidekiq ジョブハンドラーIn conversation from kimikodover.ddns.net permalink Attachments