Re: wildcard makes seq scan on prod db but not in test

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcus Engene <mengpg2(at)engene(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: wildcard makes seq scan on prod db but not in test
Date: 2011-05-09 18:48:36
Message-ID: 2757.1304966916@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marcus Engene <mengpg2(at)engene(dot)se> writes:
> There are about 2M rows on bonddump and 4M rows on bond90.
> bonddump is on a 8MB RAM machine, bond90 is on a 72MB RAM machine.
> The table is analyzed properly both places.

I'll bet one database was initialized in C locale and the other not.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-05-09 18:57:07 Re: wildcard makes seq scan on prod db but not in test
Previous Message Marcus Engene 2011-05-09 18:06:32 wildcard makes seq scan on prod db but not in test