Re: Another optimizer question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gordan Bobic" <gordan(at)freeuk(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Another optimizer question
Date: 2001-01-19 15:24:42
Message-ID: 8401.979917882@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gordan Bobic" <gordan(at)freeuk(dot)com> writes:
> If I do a view that produces the data I want through joins, it takes hours,
> even with all fields indexed, and after VACUUM ANALYZE. Doing SET ENABLE
> SEQ_SCAN = OFF doesn't seem to make any difference. The query plan changes,
> but select times are still roughly the same... Doing the separate
> subqueries on each table and joining data manualy in the application code
> takes literaly seconds.

Um, have you updated since I changed the subselect-restriction
processing two days ago?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harrelson, CulleyX 2001-01-19 15:28:43 RE: couple of general questions
Previous Message Tom Lane 2001-01-19 15:22:42 Re: .so functions and SQL queries