| 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: | Whole Thread | Raw Message | 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 |