Alexei Novakov <[EMAIL PROTECTED]> writes:
> Attaching the dumps of the tables. And here is the
> query:
> select T1.MAIN_ID, T6.LEVEL_IND, T12.MAIN_ID
> from TMP_1 T1, TMP_2 T2, TMP_2 T3, TMP_2 T4, TMP_2 T5,
> TMP_3 T6,
> TMP_2 T7, TMP_2 T8, TMP_2 T9, TMP_2 T10, TMP_2
> T11, TMP_1 T12
> wher
"Alexei" <[EMAIL PROTECTED]> writes:
> Although the result
> of the query always was correct whichever plan it's using. I repete - I did
> not do anything between queries, but just ran the same 'explain select ...'
> sequentially. The query itself is heavy, but pretty strightforward - 2
> tabl
The following bug has been logged online:
Bug reference: 1878
Logged by: Alexei
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows 2000
Description:Different execution plans for the same query.
Details:
I was doing performance evaluat
