Re: Slow deletes - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow deletes
Date
Msg-id 25102.1029245380@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow deletes  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> I considered a patch to make the parser treat all numbers as unknown, but
> that would break any code that relies on numbers-are-int4 (think function
> and operator type resolution).

Right ... if there were a simple solution we'd have done it already.

The line of thought that's been discussed in the past is to add an
UNKNOWNNUMERIC placeholder type, with similar behavior to UNKNOWN except
that it's used for something that was a numeric-looking literal rather
than a string-looking literal.  I don't recall that anyone worked out
a complete proposal --- check the archives if you want to work on this.

            regards, tom lane

pgsql-general by date:

Previous
From: "Mario Weilguni"
Date:
Subject: oid2name reports much fewer files...
Next
From: Robert Treat
Date:
Subject: Re: Very slow insert speed