On Thursday 28 Nov 2002 3:20 pm, Tom Lane wrote:
> snpe <snpe(at)snpe(dot)co(dot)yu> writes:
> > Query work sometime ; timing is from 1 second to 170 second, but sometime
> > return tuplestore : write error
>
> The only common reason for that is running out of disk space.
Given the number of tables in the query, have you tried an EXPLAIN? If you've
got unconstrained joins going on somewhere that could generate a huge
result-set. Sorry - haven't got time to try the query myself at present.
--
Richard Huxton