"Maksim Likharev" <mlikharev@aurigin.com> writes:
> I have consistent PG crash on some query,
> so I was able to isolate a simple query that crash postgres...
> SELECT p.docid FROM prod.t_documents AS p
> INNER JOIN t_tempdocs AS t
> ON p.docid = t.docid
> LEFT OUTER JOIN prod.t_refs AS ct
> ON ct.docid = p.docid;
It's difficult to provide any advice when you haven't told us exactly
what the failure is nor shown the table definitions ...
> We run PG 7.3 on SunOS
I'd recommend an update to 7.3.3 on general principles, but it's
impossible to guess whether that would fix the problem for you.
regards, tom lane