Paul Norman

I've looked into something other than delete/copy a few times and the problem I always run into is the lack of primary key. Conceptually the problem is a bit broader,...

I think it would be good to hear from the people making banners. Would they submit multiple PNGs in different languages?

[PostgreSQL Foreign Data Wrappers](https://wiki.postgresql.org/wiki/Foreign_data_wrappers) includes most databases or off-the-shelf file formats we're likely to want to use, with varying levels of support.

note: this was added in OMT 3.15

> Partition them on what? ID for the OSM data tables. I'm not sure about GPX. > I don't see how it helps with maintenance anyway It avoids doing it...

> And are you really saying that rewriting a column doesn't need to lock the whole set of chunks anyway? Can it really cope with half the chunks being in...

> Sure billion node partitions might reduce the time from a day to a few hours say, if there's enough I/O concurrency to get a more or less linear speedup,...

> I am much more concerned by the limitations listed at https://www.postgresql.org/docs/10/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS which suggest that many of our constraints would have to be dropped. Do we have unique or exclusion...

> Well I imagine they are mostly, if not all, on the id column but I don't see anything which allows that in that text? If you partition on id...

> I don't find those restrictions in the 9.5 documentation (https://www.postgresql.org/docs/9.5/ddl-partitioning.html). It seems Declarative partitioning was only introduced in Postgres 10. Yep, 10 added a 3rd way to do partitions....