From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | martin(at)tiogatours(dot)nl |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16534: autovacuum_autoanalyze not working on latitude(earth) expression |
Date: | 2020-07-10 14:36:16 |
Message-ID: | 2072934.1594391776@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> I have indexes on on the latitude() and longitude() values of an
> earth-column. I can analyze these tables, but autoanalyze fails. Because
> autoanalyze fails, it will keep trying to analyze these tables.
Yeah, the earthdistance module is not really up to production standards.
It fails to worry about search path effects, so its references to cube
functions will fail if cube isn't in the search path, which it probably
won't be during autovacuum.
Possibly at some point somebody will care enough to patch the module
to attach "SET search_path" clauses to all the SQL functions. But
generally, people who want this kind of thing in production are probably
going to want PostGIS, so it's not surprising that earthdistance is
an unloved backwater :-(
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Kornilov | 2020-07-10 19:58:05 | Re: BUG #16534: autovacuum_autoanalyze not working on latitude(earth) expression |
Previous Message | PG Bug reporting form | 2020-07-10 14:00:42 | BUG #16534: autovacuum_autoanalyze not working on latitude(earth) expression |