PostgreSQL

11 June 2025 09:03

Hello All,

I need some clarification regarding the cleanup of large objects (LOBs) in PostgreSQL. We are currently migrating data from Oracle to PostgreSQL using ora2pg. For BLOB data, we are using the OID data type instead of bytea due to size limitations and performance considerations.
During the migration, if the process fails midway, some large objects might already be committed to the database. When we re-run the migration, it results in additional large objects being created, thereby consuming more disk space.

I would like to understand:

What is the best approach to safely remove large objects associated with a specific table ?

Can vacuumlo be used in this scenario to clean up orphaned large objects, and are there any risks or precautions we should be aware of?

PostgreSQL

10 June 2025 18:57

PostgreSQL Documentation has a few resources to learn DBMS
https://www.postgresql.org/docs/online-resources/.

PostgreSQL

09 June 2025 16:55

PostgreSQL Person of the Week interview with: Teresa Lopes

https://postgresql.life/post/teresa_lopes/

PostgreSQL

07 June 2025 19:53

Is anyone familiar with any PII tool (open source) with GUI? Not only CLI
That works with postgres 9+

PostgreSQL

07 June 2025 08:23

It will work only in those sessions only not all active connection was impact

PostgreSQL

04 June 2025 18:43

Postgres vibe hacking session live - join! https://www.youtube.com/watch?v=OlzLF2VVZ8U

PostgreSQL

04 June 2025 14:29

And did you SELECT pg_reload_conf() ?

PostgreSQL

04 June 2025 08:59

hello all, I set log min duration statement to 1 min, but still seeing all logs of prepared sqls like bind, delete etc. what configuration should I change

PostgreSQL

02 June 2025 20:49

PostgreSQL Person of the Week interview with: Dilan Tek

https://postgresql.life/post/dilan_tek/

PostgreSQL

31 May 2025 13:32

Phones from 2016-2017 already have more than 6gb of ram

PostgreSQL

31 May 2025 13:31

Yeah, I'm waiting for mainline support on mine. It's almost there

PostgreSQL

31 May 2025 13:28

I host everything locally for a reason, no cloud needed 😎

PostgreSQL

31 May 2025 11:24

More like Radxa Rock 5B

PostgreSQL

30 May 2025 20:21

Next PostgreSQL cluster will be hosted on Raspberry Pis instead of a big machine with small VMs /s

PostgreSQL

30 May 2025 19:08

Virtualization will always be anything from 20 to 90% slower than bare metal in latency and speed

PostgreSQL

11 June 2025 09:00

whitelist this through pg_hba file

PostgreSQL

10 June 2025 17:51

Which one is best platform for learning postgressql

PostgreSQL

09 June 2025 09:02

Hi guys,

Need your help,

I want to open (automatically open when I pass credentials) and do automate login (automatically connect to db) for pgadmin

How can I achieve it please help me

PostgreSQL

07 June 2025 08:27

If you define this in postgres conf file then this will effect globally

PostgreSQL

06 June 2025 09:26

Hi All, I have a function in which I want to define statement timeout for 5 sec and we are using the Pgbouncer as well with session pooling, so if I put set statement_timeout at function header will it impact any other user/query or anything ,anyhow???

PostgreSQL

04 June 2025 15:31

it is prepared statements logs “bind” etc

PostgreSQL

04 June 2025 09:42

what‘s your parmeter log_statement ?

PostgreSQL

03 June 2025 06:17

Actually I am working on infomix to postgresql migration project ..I am looking for support kindly let me know any one can help me

PostgreSQL

02 June 2025 13:07

Hi Team, is there a DB2 Admin available who can assist me…preferably from Hyderabad ?

PostgreSQL

31 May 2025 13:32

Another dream of mine is buying used phones with mainline support and put proxmox ve on them to do a cluster

PostgreSQL

31 May 2025 13:29

I have a few Rock 5Bs and with a good SSD they work pretty well, more IO than the RPis. Just a shame the software support is less good.

PostgreSQL

31 May 2025 13:25

I've tried a few times to get a talk accepted of: my Raspberry PI is faster than your cloud server :)

PostgreSQL

30 May 2025 20:23

PGLite to the rescue, run it on your browser.

https://github.com/electric-sql/pglite

PostgreSQL

30 May 2025 19:09

On my proxmox node a 3000MB/s capable SSD becomes "only" 600MB/s even with paravirtualization

PostgreSQL

30 May 2025 18:29

I’m planning to set up MySQL and PostgreSQL with high workload and I/O.
Do you recommend running them on VMware vCenter with vSAN storage, or directly on a physical server (bare-metal with local storage)?
Which one will give better performance and reliability for this use case?