Re: Sub SELECTS

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Waruna Geekiyanage <waruna(at)nirmani(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Sub SELECTS
Date: 2002-09-27 16:15:34
Message-ID: 20020927091506.X40745-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • Sub SELECTS at 2002-09-25 14:27:11 from Waruna Geekiyanage

Browse pgsql-admin by date

  From Date Subject
Next Message roco 2002-09-27 18:49:47 FATAL 1: Database dialup does not exist in pg_database
Previous Message Andrew Sullivan 2002-09-27 14:17:14 Re: Readline problems & postgresql-7.2.2