Hi Tom,
Thanks for the hint, I'll give that a go later today or tomorrow and see
if that fixes the problem. Incidentally, I did try looking for a
changelog for 7.3.2 to see if there were any known issues that had been
fixed since 7.3.1, but it appears that the release notes pages in the
documentation have not been updated since the release of 7.3 (see
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=release.
html)
Cheers,
Mark.
---
Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England
Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 25 February 2003 15:17
> To: Mark Cave-Ayland
> Cc: PostgreSQL General
> Subject: Re: [GENERAL] Join query crashes 7.3.1 backend...
>
> "Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk> writes:
> > I'm having a problem executing a join query which causes the
postgresql
> > backend to crash.
>
> Please try 7.3.2. There's a (longstanding) overflow problem in the
> hash join code that only triggers on sufficiently large input sets.
> It was detected and fixed a couple months ago...
>
> regards, tom lane