38 reputation
5
bio website
location
age
visits member for 1 year, 11 months
seen Oct 5 '12 at 1:20

Oct
4
comment Running a CTE query in a loop using PL/pgSQL
Took care of the problems I mentioned and added the coordinate_id's, my bad design decision caused it to run slow. Many thanks for all your help, I think I'll delve deeper into the concepts of databases and performance tuning as soon as this project of mine is wrapped up.
Sep
28
accepted Running a CTE query in a loop using PL/pgSQL
Sep
28
comment Running a CTE query in a loop using PL/pgSQL
Very detailed, thanks a lot.
Sep
27
comment Running a CTE query in a loop using PL/pgSQL
@ErwinBrandstetter Yes, both are intentional. My only purpose is to look for number of user requests within the given timeframes (calltime determines the timespan, cal.stamp values are for the join part, if the cal.stamp gets the same starting time as calltime, the starting hour yields 0 results which is against the query-flow) for the coordinates I pass as parameters.
Sep
27
awarded  Supporter
Sep
27
comment Running a CTE query in a loop using PL/pgSQL
@wildplasser on it, thanks.
Sep
27
comment Running a CTE query in a loop using PL/pgSQL
@wildplasser well the lat/lon values in the first table -that contains coordinates and timestamps- are not the same as the lat/lons in the second table -since I created "grids" with top left and bottom right coordinates according to a certain criteria- but it just dawned upon me that I could join the two parts whenever the latitude/longitude values from the first table are between the top left and bottom right lat/lons of the second table -I will test for about 1.06 million lat/lons so plpgsql was the first thing that came to my mind but I suppose this makes it even better-
Sep
27
awarded  Custodian
Sep
27
reviewed Approve suggested edit on Running a CTE query in a loop using PL/PGSQL
Sep
27
asked Running a CTE query in a loop using PL/PGSQL
Sep
27
asked Running a CTE query in a loop using PL/pgSQL
Sep
24
awarded  Scholar
Sep
24
accepted Retrieving queries when the hour of starting timestamp is less than the hour of ending timestamp
Sep
24
awarded  Teacher
Sep
12
answered Retrieving queries when the hour of starting timestamp is less than the hour of ending timestamp
Sep
12
awarded  Student
Sep
12
asked Retrieving queries when the hour of starting timestamp is less than the hour of ending timestamp