Re: Horribly slow query/ sequential scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
Cc: db(at)zigo(dot)dhs(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Horribly slow query/ sequential scan
Date: 2007-01-09 15:13:04
Message-ID: 7472.1168355584@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Gregory S. Williamson" <gsw(at)globexplorer(dot)com> writes:
> HAving burdened others with my foolishness too often, I hesitate to
> ask, but could someone either point me to a reference or explain what
> the difference might be ... I can see it with the eyes but I am having
> trouble understanding what Informix might have been doing to my (bad
> ?) SQL to "fix" the query.

Me too. Does informix have anything EXPLAIN-like to show what it's
doing?

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Plugge, Joe R. 2007-01-09 15:36:46 Re: Horribly slow query/ sequential scan
Previous Message Devrim GUNDUZ 2007-01-09 14:16:58 Re: Running PG on cluster files systems