server closed

From: staub(at)gik(dot)uni-karlsruhe(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: server closed
Date: 2002-12-16 13:51:37
Message-ID: 3DFDDA69.8B005024@gik.uni-karlsruhe.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

does anybody know why I get the following message:

psql:1: message type 0x44 arrived from server while idle
psql::1: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:1: connection to server was lost

I try to overlap two geometrys:

select pol.the_geom as polgeo, cc.the_geom as lpgeo from Polygons pol,
CompleteChain cc where pol.the_geom && cc.the_geom;

In Relation CompleteChain are 198017 tupel and in Polygons 58063.
Are that too many tuple for about 1GB RAM and 2GB Swap?
And how can I find out the maximum number of tuple for doing such
queries?

Thanks
Guido Staub

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-12-16 13:56:09 Re: Total crash of my db-server
Previous Message Henrik Steffen 2002-12-16 13:48:41 Re: Total crash of my db-server