[GENERAL] ERROR: Bad interval external representation '0'

Hi Is there a problem with averaging time intervals? I get this error with AVG( inserttime - last) ERROR: Bad interval external representation '0' but SUM( inserttime - last) / COUNT (inserttime) seems to work just fine. Details below, database version is 7.1. thanks, Philip sceppdata=> \

[GENERAL] LARGE db dump/restore for upgrade question

Hi I have a very large database of seismic data. It is about 27 Gb now, and growing at about the rate of 1 Gb every 3-4 days. I am running postgres 7.1.2. I might possibly try to upgrade to 7.2 when it comes out, but I don't know if it will be possible for me to do 7.3 due to the pg_dump/pg_rest

[GENERAL] overhead of "small" large objects

Hi I'm putting lots of small (~10Kb) chunks of binary seismic data into large objects in postgres 7.0.2. Basically just arrays of 2500 or so ints that represent about a minutes worth of data. I put in the data at the rate of about 1.5Mb per hour, but the disk usage of the database is growing at

[GENERAL] pgdump, large objects and 7.0->7.1

Hi I am having problems with large objects in 7.0.3, high disk usage, slow access and deletes of large objects and occasional selects that hang with the background process going to 98% of the CPU and staying there. Having read that there are alot of large object improvements in 7.1, I was thinki

Re: [GENERAL] defunct postmasters

, frame at 0xb400: eip = 0x4013da02; saved eip 0x80e07b1 called by frame at 0xb414 Arglist at 0xb400, args: Locals at 0xb400, Previous frame's sp is 0x0 Saved registers: ebp at 0xb400, eip at 0xb404 On Fri, 11 May 2001, Tom Lane wrote: > Philip Crotw

Re: [GENERAL] defunct postmasters

known. Arglist at 0xb400, args: Locals at 0xb400, Previous frame's sp is 0x0 Saved registers: ebp at 0xb400, eip at 0xb404 (gdb) On Fri, 11 May 2001, Tom Lane wrote: > Philip Crotwell <[EMAIL PROTECTED]> writes: > > I am running postgres7.1 on redhat 6.2 a