Home > mailing lists

Sub SELECTS - Mailing list pgsql-admin

From	Waruna Geekiyanage
Subject	Sub SELECTS
Date	September 27, 2002 11:31:33
Msg-id	003701c2649f$a5f6fc80$705e5ecb@A.GEEKIYANAGE Whole thread Raw
Responses	Re: Sub SELECTS
List	pgsql-admin

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?

From: Steven Singer
Date: 27 September 2002, 11:31:00
Subject: Re: [DBmirror Issue] recordchange() dies in packageData unless

From: Jens Pilemand Ottesen
Date: 27 September 2002, 11:31:39
Subject: restore db from files