Re: temporary tables, indexes, and query plans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: temporary tables, indexes, and query plans
Date: 2010-10-27 19:43:13
Message-ID: 26190.1288208593@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:
> The most recent experiment shows me that, unless I create whatever
> indexes I would like to see used *before* the large (first) update,
> then they just don't get used. At all.

You're making a whole lot of assertions here that don't square with
usual experience. I think there is some detail about what you're
doing that affects the outcome, but since you haven't shown a concrete
example, it's pretty hard to guess what the critical detail is.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pitts 2010-10-27 19:44:52 Re: temporary tables, indexes, and query plans
Previous Message Jon Nelson 2010-10-27 19:29:08 Re: temporary tables, indexes, and query plans