Hi Team,
Thanks for your support.
Could you please suggest on below query.
EnvironmentPostgreSQL: 9.5.15
Postgis: 2.2.7
Mostly table contain GIS data.
While analyzing the table getting below NOTICE. It seems is pretty
understanding, but needs help on the below points.
1. What might be the reason fo
Hi Team,
Thanks for your support.
Could you please suggest on below query.
EnvironmentPostgreSQL: 9.5.15
Postgis: 2.2.7
The table contains GIS data which is fiber data(underground routes).
We are using the below query inside the proc which is taking a long time to
complete.
**
Hi Team,
Thanks for your support.
We are using below environment:
*Application :*
=
Programming Language : JAVA
Geoserver
Database Stack:
===
PostgreSQL : 9.5.15
Postgis
We have 3 geoserver queries and are getting some performance issues.
The index has been created on g
gt; VACUUM (VERBOSE, ANALYZE) tablename;
>
> Regards,
> Mohammed Afsar
> Database engineer
>
> On Fri, May 22, 2020, 12:30 PM postgann2020 s
> wrote:
>
>> Hi Team,
>>
>> Thanks for your support.
>>
>> Could you please suggest on below query.
>>
&g
ns. It is even
> expected that the BitmapHeapScan takes most of the execution
> time.
>
> So the execution looks to be the proper one.
>
> Giuseppe.
>
> Il giorno ven 22 mag 2020 alle ore 08:11 postgann2020 s <
> postgann2...@gmail.com> ha scritto:
>
>> Hi Te
Hi Giuseppe, Raúl,
Thank you for the clarification.
Regards,
PostgAnn.
On Fri, May 22, 2020 at 2:34 PM wrote:
> As Giuseppe mentioned, it only means that Postgis didn't find any
> geometry (or all of them were NULL or empty) when gathering
> information during the analyze call. It is not an is
Hi Team,
Thanks for your support.
Could someone please suggest on the below query.
One of the query which was created on GIS data is taking a long time and
even it is not taking the index as well. I have included all the required
details for reference.
Database Stack:
===
PostgreS
t; use a GIST or GIN index.
>
> Have a look at
> https://niallburkley.com/blog/index-columns-for-like-in-postgres/
>
> Greetings,
>
> Andreas
>
> On 2020-05-22 12:45, postgann2020 s wrote:
>
> Hi Team,
>
> Thanks for your support.
>
> Could someone pl
#x27;%,sheath--64690'::text) OR (TABLE_NAME.parental_path =
'sheath--64690'::text))
Rows Removed by Filter: 1930188
Buffers: shared hit=2967 read=69606 dirtied=1
Could you please suggest on this.
Regards,
PostgAnn.
On Fri, May 22, 2020 at 5:43 PM postgann2020 s
wrot