>
> I'm pretty sure that most committers would want to apply the
> rm_identity part in a separate commit first. Could you make it
> two patches, one introducing rm_identity, and another with
> xlogdump using it?
Carp the code:
const char *
clog_identify(uint8 info)
{
switch (info)
{
t;
" -> Seq Scan on road (cost=0.00..1636.32 rows=11832 width=3612)"
CREATE TABLE road
(
shape geometry,
id integer
)
WITH (
OIDS=FALSE
);
There are redundant call when sorting?
> On Tue, Jul 1, 2014 at 2:16 PM, Martijn van Oosterhout
> wrote:
> > On Su
The simplified scene:
select slowfunction(s) from a order by b limit 1;
is slow than
select slowfunction(s) from (select s from a order by b limit 1) as z;
if there are many records in table 'a'.
The real scene. Function ST_Distance_Sphere is slow, the query:
SELECT ST_Distance_Sphere(s, ST_Geo
