From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Kroeger <andrew@sprocks.gotdns.com>
Cc: Sven Clement <sven@dsign.lu>
Cc: Mark Lewis <mark.lewis@mir3.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance problems with large telemetric datasets on 7.4.2
Date: Fri, 03 Aug 2007 18:34:09 -0400
Message-ID: <4770.1186180449@sss.pgh.pa.us> (raw)
In-Reply-To: <46B39A77.8050105@sprocks.gotdns.com>
References: <881035ea0708030652r37b25a86g61e88e1f5e95eab2@mail.gmail.com>
<1186150836.19184.194.camel@archimedes>
<881035ea0708030857s621af020r4d3d7b994e2ca9a3@mail.gmail.com>
<46B39A77.8050105@sprocks.gotdns.com>
Andrew Kroeger <andrew@sprocks.gotdns.com> writes:
> With the table definitions you posted, one of the first things I noticed
> was that the default value for an integer column was a bigint value. I
> did some quick 32-bit math and found that the smallest legal 32-bit
> integer value is -2147483648, not -2147483684 (notice the last 2 numbers
> are transposed).
Oooh, good catch, but 7.4 seems to notice the overflow all right:
regression=# create temp table foo(f1 int default -2147483684::bigint);
CREATE TABLE
regression=# insert into foo default values;
ERROR: integer out of range
regression=# select version();
version
----------------------------------------------------------------
PostgreSQL 7.4.17 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)
So I think we can conclude that the OP never actually uses this default.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, andrew@sprocks.gotdns.com, sven@dsign.lu, mark.lewis@mir3.com
Subject: Re: Performance problems with large telemetric datasets on 7.4.2
In-Reply-To: <4770.1186180449@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox