Hi Dan,
2017-07-31 18:29 GMT+02:00 Dan Lyke :
>
> So over this weekend I exported the entire database out and imported it
> into a new instance. Now that one table size is down to 34GB (from
> 70GB before), which seems more in-line with the earlier database version
> (I guess something happened w
On Thu, 27 Jul 2017 09:33:03 +0200
Giuseppe Broccolo wrote:
> Moreover, if RAM resource is enough to contain the data in memory,
> blocks distribution
> on disk should not be a problem (anyway, since we are talking about
> this, could you provide
> the ratio datasetsize/RAMresource?).
So over thi
> On Fri, Jul 28, 2017 at 10:56:14PM -0400, Regina Obe wrote:
>> a) geom geometry means no restriction whatsoever. No typmod is applied.
>> b) geometry typmod is short for any 2D geometry so it won't allow Zs.
> It keeps striking me that there's no way to have unconstrained number of
> dimen
On Fri, Jul 28, 2017 at 10:56:14PM -0400, Regina Obe wrote:
> a) geom geometry means no restriction whatsoever. No typmod is applied.
> b) geometry typmod is short for any 2D geometry so it won't allow Zs.
It keeps striking me that there's no way to have unconstrained number
of dimensions when
You can try using this extension available on github for schema cloning, it
provides complete schema clone (DDL and Data).
https://github.com/vibhorkum/cloneschema
-- Ahsan
On Mon, Jul 31, 2017 at 2:09 PM, Regina Obe wrote:
> I think you'd have better luck asking this on pgsql-general news lis
I think you'd have better luck asking this on pgsql-general news list.
https://www.postgresql.org/list/pgsql-general/
There is no PostGIS related question here.
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf
Of Olivier Leprêtre
Sent: Sunday, July 30, 2017 2:
