PostgreSQL

24 February 2025 08:57

It's three or four extra commands and you'll never have to wonder again 😉

PostgreSQL

24 February 2025 08:21

Which intra cluster security is used in Streaming replication and how to configure it?

PostgreSQL

23 February 2025 18:23

Just create a separate DB with a wrapper function with SECURITY DEFINER and grant login and execution of that wrapper function only.

PostgreSQL

23 February 2025 11:40

Both are extremely inefficient as they can only use full table scan and filtering.
You'd better use functional index on (lower(field)) and then the first variant of your query.

PostgreSQL

23 February 2025 11:03

HI! Which of below queries will be more effective?

select count(*) from my_table where lower("comment") = 'tax';
   
 select count(*) from my_table where "comment" ilike 'tax';

PostgreSQL

22 February 2025 20:13

after base, recommend most valuable skill is query optimization, if will not handle go to DBA stuff

PostgreSQL

22 February 2025 20:01

Can someone give me the link where I can study about the architecture of the PostgreSQL.

PostgreSQL

21 February 2025 12:19

Oracle Package supported In postgres?

PostgreSQL

20 February 2025 12:46

https://sticker.how/

PostgreSQL

20 February 2025 12:38

There's a standard for hexagon stickers at conferences

PostgreSQL

18 February 2025 09:18

If put \dt+ n pg total relation size is diff

PostgreSQL

18 February 2025 09:01

What is the exact query/view you're checking? Are you checking through the file system?

PostgreSQL

18 February 2025 08:10

Db level can see table size is same

PostgreSQL

18 February 2025 06:12

Hi Team good morning we had one issue in production server we scheduled one purge script every weekend for one particular table we could see the delete operation is completed but we are not getting space I have manually tried vacuum analyze or full also but still table size growing but there is no lob data types or toast so how to resolve this any inputs please ….

PostgreSQL

17 February 2025 16:44

That whole CVE is quite a mess. Apparently it showed up in a brain-dead security (!) product that pipes commands incl. user input into psql. But alas, there's a CVE number with a rather high score, so everybody gets nervous 🤷‍♂

PostgreSQL

24 February 2025 08:27

Is this an interview question?

PostgreSQL

24 February 2025 07:06

For my own curiosity, why do we need to create the wrapper function in a separate DB ? I have a similar implementation for other purposes, stored in the postgres db. I wonder if I left an open door …

PostgreSQL

23 February 2025 16:39

Hello Experts,
Need a clarificaton on a custom role creation.

is there a way to create a role only to run pg_terminate_backend() but with no other permissions like DDL or DML modification.

i want this user to be used for killing queries but deny other privileges ..
please suggest

PostgreSQL

23 February 2025 11:40

I would go with first because it's explains the purpose clearly (comment should be equal to tax) and also won't ILIKE spend a few extra cycles to check for pattern?

PostgreSQL

22 February 2025 20:43

https://www.interdb.jp/pg/index.html

PostgreSQL

22 February 2025 20:13

manual good start
https://www.postgresql.org/docs/

PostgreSQL

22 February 2025 09:34

Hi All
I am doing MySQL to postgres migration.

Can Someone suggest how to do migration

PostgreSQL

20 February 2025 13:11

Of course there's at least one standard ... ;-)

PostgreSQL

20 February 2025 12:45

I've seen at least three different sizes, but I had no ruler around to measure the exact dimensions.

PostgreSQL

20 February 2025 11:53

Got a question for you all: if you have hexagon stickers on your laptop, what size (in mm) are the stickers? And if you have different sizes, which size do you prefer?

PostgreSQL

18 February 2025 09:02

Since migration is pretty much populating a database, check this documentation: https://www.postgresql.org/docs/current/populate.html

PostgreSQL

18 February 2025 08:59

harish:
Hi All
I am doing oracle to postgres migration using ora2pg, we have total 67 tables out of this 66 tables completed fast only one table is taking long time

It has a text data type

Can Someone suggest how to speed up this migration

PostgreSQL

18 February 2025 08:08

Where are you seeing the data being used?

PostgreSQL

17 February 2025 16:47

And the stars need to be aligned!

PostgreSQL

17 February 2025 16:42

Basically, an attacker would need to have access to the client configuration for everywhere but the Asian deployments where BIG5 is used already, and at that point if you can control the client the sql injection sounds like the last of your problems