Re: Sub SELECTS - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Sub SELECTS
Date
Msg-id 20020927091506.X40745-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Sub SELECTS  ("Waruna Geekiyanage" <waruna@nirmani.com>)
List pgsql-admin
On Wed, 25 Sep 2002, Waruna Geekiyanage wrote:

> I have a select query with 2 sub selects.
> When I run that query CPU usage goes to 98% for postgres.
> Does sub selects eat more resources and slower the queries?
> Is there any alternatives to sub selects?

It depends on what you're doing.  The query and table schema
would be useful.



pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: hardware question
Next
From: Willy Wonka
Date:
Subject: old db on a new system