Re: [GENERAL] Forced external sort?

On Fri, Sep 11, 2015 at 11:45 AM, wrote: > I've got a poorly indexed query and was attempting a quick work around in > production by increasing work_mem when it was called. EXPLAIN ANALYZE is > telling me this: > > Sort Method: external sort Disk: 1253824kB > > > So I set the

Re: [GENERAL] clone_schema function

Melvin Davidson wrote: > "seriously flawed" is a bit of a stretch. Most sane developers would not > have schema names of one letter. > They usually name a schema something practical, which totally avoids your > nit picky exception. That's confusing the example with the problem it shows.

Re: [GENERAL] clone_schema function

With thanks to a suggestion by David G. Johnston, I've attached another revised version of the function that hopefully eliminates the problem reported by Daniel Verite. This version also handles CamelCase schemas and tables better. If anyone else finds a problem, kindly attach a dump of the