Posts by Lorenzo Freitas • 46 points
5 posts
-
0
votes1
answer130
viewsA: SLA calculation in Postgresql
I don’t know if I understand you very well, but you want to know the records that are on business time? If yes the solution commented earlier solves. Below is an example according to the previous…
-
0
votes1
answer62
viewsA: Filters in the Web Panel
The first question to check is whether this GRID is based on attributes or variables only. When the GRID is based on attribute the LOAD event runs per line, when the GRID is based on variables only…
-
0
votes1
answer279
viewsA: Division between postgresql functions
You should only make a clause from and assign aliases to each of the "tables", which are actually called functions that return a table. However it doesn’t seem to make much sense this query, you…
postgresqlanswered Lorenzo Freitas 46 -
1
votes1
answer454
viewsA: Very time consuming query depending on query ID
I recommend you run the queries with pgAdmin3 or pgAdmin4 first, or even through psql. It seems that in one bank it is fast and in another it is slow, it can be some indexing problem. First if…
postgresqlanswered Lorenzo Freitas 46 -
2
votes1
answer209
viewsA: Backup in Postgres
There is no native table or view in Postgresql for this purpose, but what can be done is a manual solution as follows: Both the pg_dump.exe (responsible for the backup), regarding the pg_restore.exe…