PostgreSQL

13 Nov 2024 08:13

There are also other parametrrs likes random_page_cost

PostgreSQL

13 Nov 2024 08:05

As of now,we are migration data from Oracle to postgres. So before going to live we have to tune these parameters. Is it possible for based on database size?

PostgreSQL

13 Nov 2024 07:53

Hello All,
Anyone have experience on tuning parameters please help me on below parameterd. After migrate from Oracle to postgres, we need to tune these parameters.

shared_buffers
huge_pages
huge_page_size
temp_buffers
work_mem
hash_mem_multiplier
maintenance_work_mem
autovacuum_work_mem
vacuum_buffer_usage_limit
logical_decoding_work_mem
min_dynamic_shared_memory
max_parallel_workers_per_gather
max_parallel_maintenance_workers
max_parallel_workers
max_worker_processes

PostgreSQL

13 Nov 2024 04:10

Yes. tomcat and hikaricp .. in hikaricp max_connection is 20 in 14 applications.
But I want to know from a postgresql perspective, how it creates connection and closes it. Suppose I write psql -U postgres.. it creates a new connection, now if I do \c mydb.. will it create a new connection or use the existing one?

PostgreSQL

12 Nov 2024 13:54

How connections are created in postgresql when connected by jdbc. In my case it suddenly reaches 800 where the max_connection is 1000. I don't know what's happening in the backend. If anyone knows plz help

PostgreSQL

12 Nov 2024 11:52

Configure both. If the replica fails to connect to the primary, it will fall back to fetching WALs from the archive (i.e., log shipping).

PostgreSQL

12 Nov 2024 10:41

If you have a standby server that recover using log shipping, it's going to restore getting archive files from the place that they were archived and apply them

PostgreSQL

12 Nov 2024 10:38

Log shipping, 16mb of lag, size of archive file

PostgreSQL

11 Nov 2024 19:21

In Postgres you can LISTEN for events. But those work very well.

This does NOT sound like a PostgreSQL issue.
At least not until you get down to the LISTEN / NOTIFY

PostgreSQL

11 Nov 2024 18:25

Please someone help me I need your help desperately . I have been trying to ask a lot of people and look up a lot of resources but none have worked so far

PostgreSQL

11 Nov 2024 14:58

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

09 Nov 2024 04:49

How to upgrade psql client from 11.x to 15.x on EC2 instance.

PostgreSQL

08 Nov 2024 17:06

Last 2 messages were copy and paste

PostgreSQL

08 Nov 2024 16:41

Same message of oom, without anymore data that you sent several days ago. Try giving more info

PostgreSQL

08 Nov 2024 16:31

Good job. Keep watching!

PostgreSQL

13 Nov 2024 08:07

It depends on many factors like database size, hardware, write vs read workload, the kind of queries you're doing etc.

PostgreSQL

13 Nov 2024 07:56

You should share about what your workload is and the issues you're having

PostgreSQL

13 Nov 2024 04:13

spring.datasource.tomcat.initial-size=10
spring.datasource.tomcat.max-wait=30000
spring.datasource.tomcat.max-active=40
spring.datasource.tomcat.max-idle=5
spring.datasource.tomcat.min-idle=4

spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=20
spring.datasource.hikari.idle-timeout=100000
spring.datasource.hikari.max-lifetime=1000

This is the hicaricp conf

PostgreSQL

12 Nov 2024 17:51

You probably have a client side connection pool (e.g. HikariCP) and configured that to use up to 800 connections. They usually default to actually use them if they get them 🤷‍♂

PostgreSQL

12 Nov 2024 11:53

N.B.: you should configure both anyway!

PostgreSQL

12 Nov 2024 10:44

i understand its possible to combine the two - log shipping + strearming.
how does it work and how i configure this?

PostgreSQL

12 Nov 2024 10:39

Everytime a wal file get full, is archived. And archiver is like copy from one directory to another place.

PostgreSQL

12 Nov 2024 10:27

Hi
I need some help understanding log shipping / streaming replication
streaming = streams wal records and apply on replica
log shipping = transfer the whole WAL file and apply on replica
so it means log shipping might have more lag?
how exactly does it work?

PostgreSQL

11 Nov 2024 19:08

What is related to postgres?

PostgreSQL

11 Nov 2024 18:25

Why am I not able to broadcast an event over a channel.I created event MessageSent. Had a private channels chat.$this->message->receiver_id.Then broadcasted the event in my sendMessage controller function by broadcast(new Message($message)).Started my reverb server debug mode.Wrote an Authorization route in channels.php.Also did some configuration in bootstrap/app.php regarding api token from sanctum. In database only jobs table is populated. But I dnt get the event in frontend.Yes I have run queue pho artisan queue:listen command as well

PostgreSQL

09 Nov 2024 08:15

I Need postgresql documentation file

PostgreSQL

08 Nov 2024 17:23

Well, you may start with the exact description of your tooling, query, the exact error message(s), explain of the query and so on.

A usual start of postgres debugging. Or anyother computer program debugging.

PostgreSQL

08 Nov 2024 16:45

Yes actually i am trying to reproduce this in test environment but enable to reproduce

PostgreSQL

08 Nov 2024 16:36

Any idea why this behaviour i am experiencing

PostgreSQL

08 Nov 2024 16:28

I have a PostgreSQL database cluster with two databases, both containing the same data. The difference between the databases is that one has a collation of ‘C’, while the other has a collation of ‘en_US.UTF-8’. When I run the same insert query on both databases, it executes successfully on the database with the collation ‘en_US.UTF-8’, but gives an Out of Memory (OOM) error when run on the database with the ‘C’ collation. Any idea why this behaviour