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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html