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