Thread

1. Exhausted memory

   Jérome Knöbl <jknobl@mandanet.ch> — 1998-05-19T17:45:08Z

   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
   
   
   

2. Re: [SQL] Exhausted memory

   Marc G. Fournier <scrappy@hub.org> — 1998-05-20T00:06:08Z

   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