On Thursday 28 November 2002 04:33 pm, Richard Huxton wrote:
> On Thursday 28 Nov 2002 3:20 pm, Tom Lane wrote:
> > snpe <snpe@snpe.co.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.
I do EXPLAIN
Query work sometime without any reason - I don't execute another program
Thanks
Haris Peco