Received: from thelab.hub.org (tc-41.acadiau.ca [131.162.2.141]) by hub.org (8.8.8/8.7.5) with ESMTP id UAA24276 for ; Tue, 19 May 1998 20:05:41 -0400 (EDT) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.8.8/8.8.2) with SMTP id VAA29661; Tue, 19 May 1998 21:06:08 -0300 (ADT) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Tue, 19 May 1998 21:06:08 -0300 (ADT) From: The Hermit Hacker To: Jerome Knobl cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Exhausted memory In-Reply-To: <3561C524.307AE030@mandanet.ch> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 19 May 1998, Jerome Knobl wrote: > 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 ?!? What does the 'explain' command show you? Do you have appropriate INDICES in place...? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org