Re: [SQL] Exhausted memory - Mailing list pgsql-sql

From The Hermit Hacker
Subject Re: [SQL] Exhausted memory
Date
Msg-id Pine.BSF.3.96.980519210543.580f-100000@thelab.hub.org
Whole thread Raw
In response to Exhausted memory  (Jerome Knobl <jknobl@mandanet.ch>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] How to handle a requirement for nextval
Next
From: "Eugene Selkov Jr."
Date:
Subject: Re: [SQL] Case in-sensitive searches