Re: [BUGS] BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342

2011-03-15 Thread Kevin Grittner
Tambet Matiisen tambet.matii...@gmail.com wrote: For a few days I've been getting this error from my nightly backup script: Warning: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342 pg_dump:

Re: [BUGS] SELECT '(1, nan, 3)'::cube;

2011-03-15 Thread Robert Brewer
Tom Lane wrote: Robert Brewer fuman...@aminus.org writes: I'm working on a hypercube implementation in Postgres using contrib/cube and need to insert 80,000 rows in one go from Python. Doing so with INSERT, even multiple statements in one call, is pretty slow. I've been investigating if

Re: [BUGS] SELECT '(1, nan, 3)'::cube;

2011-03-15 Thread Tom Lane
Robert Brewer fuman...@aminus.org writes: Tom Lane wrote: I'd suggest rethinking your design to avoid needing NaN in a cube. I could, of course, use a sentinel value like -1 or even -Inf to mean indeterminate, but I'd like future versions of this app (wink) to be able to use qnan's as IEEE

[BUGS] SELECT '(1, nan, 3)'::cube

2011-03-15 Thread Robert Brewer
Hi folks, I'm working on a hypercube implementation in Postgres using contrib/cube and need to insert 80,000 rows in one go from Python. Doing so with INSERT, even multiple statements in one call, is pretty slow. I've been investigating if using COPY is faster. It is, but there's a problem:

[BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-03-15 Thread Andy Lester
The following bug has been logged online: Bug reference: 5932 Logged by: Andy Lester Email address: a...@petdance.com PostgreSQL version: 9.0 Operating system: Linux Description:CLUSTER doesn't update n_dead_tup Details: The CLUSTER command does not update the