Postgres Pro
Downloads
Home   >   mailing lists

Re: wildcard makes seq scan on prod db but not in test - Mailing list pgsql-performance

From Tom Lane
Subject Re: wildcard makes seq scan on prod db but not in test
Date
Msg-id 2757.1304966916@sss.pgh.pa.us
Whole thread Raw
In response to wildcard makes seq scan on prod db but not in test  (Marcus Engene <mengpg2@engene.se>)
List pgsql-performance
Tree view 
Marcus Engene <mengpg2@engene.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

pgsql-performance by date:

Previous
From: Marcus Engene
Date:
Subject: wildcard makes seq scan on prod db but not in test
Next
From: "Kevin Grittner"
Date:
Subject: Re: wildcard makes seq scan on prod db but not in test