#postgressql — Public Fediverse posts

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

身為工程師兼DJ，把文件中的 #PostgresSQL 看成 #ProgressiveSQL 是很正常的事....

#ProgressvieTrance

Gerade auf der Arbeit die Datenbank durch Komprimierung um den Faktor 4 verkleinert und die Performance verbessert. Fühlt sich gut an.
Danke #Timescale #PostgresSQL

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

PostgreSQL 17がやってくる(3) ログインイベントトリガ
https://qiita.com/nuko_yokohama/items/dbd000f49f7d3fd27e36?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgresSQL #PostgreSQL17

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

It turns out that a #PostgresSQL table to store URLs crawled is a bad idea: the table is currently 749G on disk. In contrast, a bloom filter with a 1e-7 error for a billion items will take up about 4G https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=

#mwmbl #opensource #searchengine

It turns out that a #PostgresSQL table to store URLs crawled is a bad idea: the table is currently 749G on disk. In contrast, a bloom filter with a 1e-7 error for a billion items will take up about 4G https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=

#mwmbl #opensource #searchengine