Thread: Exhausted memory

Exhausted memory

From

Jerome Knobl

Date:

19 May 1998, 13:41:26

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

Re: [SQL] Exhausted memory

From

The Hermit Hacker

Date:

19 May 1998, 20:05:42

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