Re: Slow deletes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Edmund Dengler <edmundd(at)eSentire(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Slow deletes
Date: 2002-08-13 13:29:40
Message-ID: 25102.1029245380@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2002-08-13 13:33:52 Re: Very slow insert speed
Previous Message Mario Weilguni 2002-08-13 13:17:00 oid2name reports much fewer files...