Re: Oddity with view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com>
Cc: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Oddity with view
Date: 2008-11-10 18:31:38
Message-ID: 11916.1226341898@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com> writes:
> How on earth did the seqscan suddenly take 4x longer? And why is the
> subquery scan then doubling the amount of time again?

Maybe the disk access is less sequential because of the need to fetch
the other table too?

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim 'Decibel!' Nasby 2008-11-10 18:36:12 Re: Oddity with view (now with test case)
Previous Message Andrus 2008-11-10 18:23:41 Re: Simple indexed IN query takes 40 seconds