All Questions
Tagged with performance postgresql
1,575
questions
1
vote
0
answers
46
views
PostgreSQL unresponsive when restarting after many inserts using PGVector container
Description:
I am facing an issue where PostgreSQL becomes unresponsive after restarting. The setup utilizes the PGVector:pg16 Docker container. Below is the schema for the relevant table:
CREATE ...
0
votes
0
answers
6
views
Scaling user feed (Posts) from many sources
I have a scaling issue we are running into. I have a social media app - the user feed has posts from them, posts from the groups they are part of and posts where their groups are tagged in the ...
1
vote
1
answer
40
views
Postgresql Left Join via intersecting geometry columns leads to wrong Sum and correction has bad performance
I have two tables with the following structure and a lot of data:
CREATE TABLE lines
(
"Id" text COLLATE pg_catalog."default" NOT NULL,
"ProjectId" text COLLATE ...
- 2,363
0
votes
1
answer
44
views
Dynamic SQL vs. generic query with dynamic filters
I'm working on a SQL query where the filters can be dynamic, and I'm concerned about its efficiency. My current approach is as follows:
SELECT *
FROM table t
WHERE (:param1 IS NULL OR t.example = :...
- 299
0
votes
1
answer
57
views
Performance of SQL query in a big table
I have a postgres table looking like the following:
id: int [PK]
scenario_id: int [FK]
node_id: int Optional[FK]
element_id: int Optional[FK]
result: char(20)
value: double
unit: char(12)
Where I ...
- 1,548
0
votes
1
answer
28
views
Filtering rows While Joining Two Tables(dataframes)
Currently I have 2 tables, lets say symbol_data and cve_data.
symbol_data is structured as below:
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 ...
- 1
1
vote
1
answer
39
views
I don't understand why a simple JoinTable is this slow with Spring boot compared to SQL JOIN TABLE
I have two really simple JPA Spring Entities : Farm and Coordinates
@Entity
@Getter
@Setter
@Table(name = "farms")
public class FarmEntity {
@Id
Long id;
@Column(name = "...
- 11
0
votes
1
answer
78
views
Improve execution time of a query that populates data
Good morning everyone, how are you?
I need help related to a process whose popular purpose is data from one table to another, at the moment I'm using spring boot with native query, but it's taking ...
- 85
0
votes
0
answers
45
views
Postgres query optimization with some joins
Using postgres i have a query that is taking 7 seconds to run,
first, i will give some context ,
i have a table called courses with ~600 rows
create table code:
CREATE TABLE public.courses
(
id ...
- 1
0
votes
1
answer
40
views
Which query used an index in Postgresql
I'm using the pg_stat_all_indexes table to get the number of index scan used (idx_scan).
Is there a way to determine which query used an index? A sampling of the queries (like in pg_stat_statements) ...
- 377
0
votes
0
answers
64
views
RANGE vs HASH partitioning for high volume time series data in postgres
I have a large time series data set consisting of ~3 months of records, something like 6-8 billion rows. It's very write heavy compared to reads but the access pattern will be consistently tied to ...
- 73
0
votes
0
answers
30
views
Optimizing PostgreSQL Connection Limits on Windows Server 2019: Balancing Performance and Stability
In our production environment, we are utilizing Windows Server 2019 with 4 cores and 4 threads. Currently, PostgreSQL is configured with a maximum connection limit of 150. However, there are ...
1
vote
1
answer
36
views
Optimize PostgreSQL query to insert users into the database
The use case goes like this.
There is a signup endpoint on which the user will submit their email and password
4 rows have to be created at once with a couple of ids generated
The tables look like ...
- 5,931
0
votes
0
answers
84
views
Postgresql query takes 9 minutes to execute, how can we reduce time to 60 seconds?
Below is my Postgresql query that is taking 9 minutes to execute. Please help me reduce the execution time to 60 seconds, so my API does not throw a timeout error.
SELECT DISTINCT
rdfg....
0
votes
2
answers
68
views
postgresql query taking 3 min to execute ,how can i reduce the time to within 60 seconds
I need help optimize below postgresql query.
Currently its taking more than 3 min to get the data , due to that my API got timeout ,can you please help me to get the result set within 59 seconds.
...