Re: literal limits in 8.3

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: literal limits in 8.3
Date: 2008-11-24 17:08:46
Message-ID: 20081124170846.GA2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, Nov 24, 2008 at 10:45:42AM -0500, Tom Lane wrote:
> Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> > It's a normal 32bit Intel Debian system, nothing much special done
> > to increase the kernel/user split or anything like that as far as I
> > remember on this box. If I try with larger sizes it falls over with
> > "out of memory", but up until around 755MB (760MB fails) it gives back
> > "INSERT 0 1" which I've always read as inserting a row. A select on the
> > table gives this inserted row containing a zero length string.
>
> Well, I can't reproduce that here. Something strange about your
> configuration maybe?

Not that I know of. I've just created a test cluster to make sure and I
get the same behaviour. Minimal set of commands are:

LANG=C /usr/lib/postgresql/8.3/bin/initdb pg83
vi pg83/postgresql.conf

changed port to 5444 to prevent conflicts, everything else default.

/usr/lib/postgresql/8.3/bin/postgres -D pg83 -k /tmp

in a seperate shell:

echo "create database smason;" | psql -p 5444 -h /tmp template1
echo "create table test ( col text );" | psql -p 5444 -h /tmp

./test 64 | psql -p 5444 -h /tmp
results in:
INSERT 0 1
Time: 3354.269 ms

./test 512 | psql -p 5444 -h /tmp
results in:
INSERT 0 1
Time: 50.452 ms

echo "select length(col) from test;" | psql -p 5444 -h /tmp
results in:
length
----------
67108864
0

Anything else to try? All PG packages are from debian backports with
version "8.3.4-2~bpo40+1", anybody else getting this?

Hum, maybe I should try building from source and see if it's something
to do with the Debian packages. [/me twiddles thumbs while code builds]
... done ... I get the same result for both 8.3.4 and 8.3.5. I'm kind
of stuck for ideas now!

Sam

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-11-24 17:13:56 Re: filter statements in logs
Previous Message Scott Marlowe 2008-11-24 17:04:55 Re: filter statements in logs

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-24 17:21:33 Re: Snapshot warning
Previous Message Peter Eisentraut 2008-11-24 17:00:02 Re: blatantly a bug in the documentation