Received: from lucas.mandanet.ch (lucas.mandanet.ch [195.15.14.192]) by hub.org (8.8.8/8.7.5) with SMTP id NAA05115 for ; Tue, 19 May 1998 13:41:24 -0400 (EDT) Received: from thomas.mandanet.ch (thomas.mandanet.ch [195.15.14.193]) by lucas.mandanet.ch (NTMail 3.02.13) with ESMTP id ca007126 for ; Tue, 19 May 1998 19:45:07 +0100 Message-ID: <3561C524.307AE030@mandanet.ch> Date: Tue, 19 May 1998 19:45:08 +0200 From: Jerome Knobl Organization: MandaNET X-Mailer: Mozilla 4.04 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Exhausted memory Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have a big trouble! :-(( I make some big sql request on lot of table (about 12, but I tried with less). Postgres take a lot of time (more than 10 minutes) to compute my request. I trie the same request with the same table on MSAccess and it take 2 seconds ?!? I tried to create some index, but it wasn't better. If you have some idea, send my it. JK