Most of that fix should already be in the PG15 3.3.5 except for the parts that
have PG16 guards, cause they wouldn’t work in PG15 or lower.
So If you find trying to reapply to 3.3.5 works I’d be surprised and be
interested in which portion of patch you applied.
From: Nikhil Shetty
Hi all,
I need to rotate a raster, for that I'm using the function ST_SetRotation, like
so:
CREATE TABLE plot_3_rotated AS
SELECT ST_SetRotation(rast, 0.03516235334249185) rast
FROM plot_3;
But I see that is not producing the expected results and is changing size of
the raster. What am I doing
Is there a guide on what and how to do with PostGIS configuration to speed
up operations like interecting?
Regards,
David
There isn’t a single guide I can think of.
Generally the key factors I can think of for speeding intersects, are make sure
you have spatial indexes in place, parallelization, and memory.
Here is one that details how to config params for parallelization
product_assurance=# SELECT version(), postgis_full_version();
version
|
postgis_full_version
And the query?
From: Shaozhong SHI
Sent: Monday, March 18, 2024 7:57 AM
To: Regina Obe
Cc: PostGIS Users Discussion
Subject: Re: PostGIS performance issue
product_assurance=# SELECT version(), postgis_full_version();
version
By size, what do you mean exactly? It would change the width and height.
What are you expecting rotation to do. Perhaps you can give example out of the
below and some sample
ST_Width, ST_Height, ST_SkewX before and after and what you were expecting.
Hi Regina,
I checked the code that we used to build 3.3.5 packages and you are right
the fix is already present but not sure why we are still getting the error
on PG15.
I will debug and get back to you.
Thanks,
Nikhil
On Mon, Mar 18, 2024 at 1:55 PM Regina Obe wrote:
> Most of that fix
Hi Regina and all,
Elaborating a bit more. I have a vector layer consisting of a rectangle (farm
plot), and this rectangle is subdivided into several (polygons) stripes
parallel to the outer edge of the rectangle. I want to produce a raster where
the rectangle and stripes long edges are