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
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 |