Adam Kornick <akornick(at)whgrp(dot)com> writes:
> I have a moderately complex query running on small views (10-30
> records) which used to work, but is now dying unexptecedly.
Sounds like a backend core dump. Please look for the core file
(should be under $PGDATA/base/yourdbnumber/) and send us a debugger
backtrace. You might have to recompile with --enable-debug to get
a useful (symbolic) backtrace.
If you are feeling out of your depth with that request, instead
put together a self-contained example that triggers the crash,
and send it along.
regards, tom lane