Re: Slow statement using parallelism after 9.6>11 upgrade

> On Sep 3, 2019, at 7:06 AM, Arnaud L. wrote: > > Le 03/09/2019 à 15:43, Tom Lane a écrit : >> "Arnaud L." writes: >>> We have upgraded our database from 9.6 to 11 (and updated PostGIS from 2.3 >>> to 2.5 as well). >>> ... >> Have you re-ANALYZEd the database? The problem with this query >

Re: table name

ALTER TABLE "regions-20180101" rename to regions_20180101; > On Jun 11, 2020, at 11:54 AM, Marc Millas wrote: > > sorry if my question is tooo simple :-) > > I got a shapefile from the french gov. > I import it with postgis 3.01 utility. > fine ! > the table created by this utility is named re

Re: pg_upgrade of 11 -> 13: free(): invalid pointer

> On Nov 17, 2020, at 11:44 AM, Bruce Momjian wrote: > > On Tue, Nov 17, 2020 at 11:59:10AM -0500, Jeremy Wilson wrote: >> pg_restore: WARNING: terminating connection because of crash of another >> server process >> DETAIL: The postmaster has commanded this server process to roll back the >

Re: Cannot terminate backend

Afraid so. You can wait longer, I guess. You may have found two bugs… the lack of an interrupt in the dbscan loop, which I’m working on now. And maybe an infinite looping case? In which case if you want a fix on that, you’ll have to share your data and query. P. > On Mar 31, 2023, at 7:41 AM,

Re: postgis after pg_upgrade

If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to update the SQL-side bindings, everything should improve. > On Nov 30, 2018, at 5:11 AM, Slavcho Trnkovski wrote: > > Hi, > > I have postgresql 9.4 with postgis extension installed (latest version, > 2.4.5). I upgraded po

Re: Geographic coordinate values format conversion to DD (Decimal Degrees) format

> On Dec 4, 2018, at 12:36 PM, Allan Kamau > wrote: > > Does PostgreSQL (more specifically PostGIS) have functions for these types of > conversions. > > Below are examples of the geographic coordinates values I have coupled with > the resulting decimal degrees val

Re: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

On Thu, Mar 14, 2019 at 8:43 AM Julien Rouhaud wrote: > > On Thu, Mar 14, 2019 at 3:25 PM Adrian Klaver > wrote: > > > > On 3/14/19 6:14 AM, Julien Rouhaud wrote: > > > On Thu, Mar 14, 2019 at 1:20 PM fuzk wrote: > > >> > > >> Dear Adrian, > > >> > > >> My setting is as following. > > >> > > >>

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

> On Mar 31, 2021, at 11:24 AM, Tom Lane wrote: > > Stephan Knauss writes: >> Hello Tom, the output below looks similar to the OOM output you >> expected. Can you give a hint how to interpret the results? > > Looks like the answer is that wherever the leak is, it's not accounted > for by th

Re: index unique

Primary key is going to be a BTREE index. I'm surprised you require the geometry in order to achieve uniqueness? You can't put the geometry into a BTREE because it's too large. You could add a column and stick the MD5 hash of the geometry there, and use that as the last piece of uniqueness? If t

Re: proj_create errors in EDB 13.5 installation macOS

> On Jan 21, 2022, at 4:45 AM, Moen, Paul T. wrote: > > I am seeing the following errors in my PostgreSQL log files and wonder if > this is a problem with EDB's installation. Yes, missing the proj.db would certainly make proj unhappy. Search your system first and see if the file is actuall

SearchSysCache() tutorial?

Is there anywhere any documentation on SearchSysCache? I find I end up on these long spelunking expeditions through the code base for a particular problem, find the answer after many hours, then forget everything I learned because I don't exercise my knowledge frequently enough. A decent reference

Re: SearchSysCache() tutorial?

On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey wrote: > Is there anywhere any documentation on SearchSysCache? I find I end up > on these long spelunking expeditions through the code base for a > particular problem, find the answer after many hours, then forget > everything I learn

Re: SearchSysCache() tutorial?

> On Dec 11, 2017, at 11:37 AM, Melvin Davidson wrote: > > > > On Mon, Dec 11, 2017 at 2:26 PM, Paul Ramsey <mailto:pram...@cleverelephant.ca>> wrote: > On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey <mailto:pram...@cleverelephant.ca>> wrote: > &

Re: SearchSysCache() tutorial?

> On Dec 11, 2017, at 12:40 PM, Andres Freund wrote: > > On 2017-12-11 11:26:51 -0800, Paul Ramsey wrote: >> On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey >> wrote: >>> Is there anywhere any documentation on SearchSysCache? I find I end up >>> on these