All Questions
Tagged with pgadmin-4 postgresql-performance
3 questions
-2
votes
1
answer
165
views
Problem :simple query takes too long to complete (over 7 minutes) [closed]
CREATE OR REPLACE FUNCTION public.fn_question_3_3()
RETURNS TABLE(name character varying, surname character varying, person_t person_type)
AS
$$
DECLARE
pt person_type;
BEGIN
RETURN QUERY
...
1
vote
1
answer
63
views
Adding condition (Similarity) causes sequence scan
Struggling with this one a little bit, as I would have expected the performance to be better combining the queries that separated.
The queries are produced using Django ORM 1.11.
With the ...
- 53
0
votes
1
answer
124
views
Update column value divisible by 100
Hello experts I need to update next column value with divisible by 100
- 125