>
> I'd bet your old database is in C locale and the new one is not.
>
Remind me never to never bet against you :-).
> The LIKE optimization requires an index that's sorted according to plain
> C (strcmp) rules. A regular text index will be that way only if the
> database's LC_COLLATE is C.
>
>
Jim Nasby writes:
> On 12/31/15 9:02 AM, Tom Lane wrote:
>> If you don't want to rebuild the whole database, you can create indexes to
>> support this by declaring them with COLLATE "C", or the older way is to
>> declare them with text_pattern_ops as the index opclass.
> Do you have to do anythin
On 12/31/15 9:02 AM, Tom Lane wrote:
If you don't want to rebuild the whole database, you can create indexes to
support this by declaring them with COLLATE "C", or the older way is to
declare them with text_pattern_ops as the index opclass.
Do you have to do anything special in the query itself
Anton Melser writes:
> I moved a DB between two "somewhat" similar Postgres installs and am
> getting much worse plans on the second. The DB was dumped via pg_dump
> (keeping indexes, etc.) and loaded to the new server.
> [ "like 'foo%'" is not getting converted into index bounds ]
I'd bet your
Hi,
It is looking like some missing optimization that was removed from RC
> release.
>
Thanks. Is there some discussion of why these optimisations were removed? I
started looking at some of the more complicated queries I do and there are
many occasions where there are 10-30x performance degradati
Hi
> Does anyone have any ideas? All data are loaded into this table via copy
> and no updates are done. Autovacuum settings weren't changed (and is on
> both). Do I need to increase shared_buffers to half of available memory for
> the planner to make certain optimisations? Anything else I'm miss
Hi,
I moved a DB between two "somewhat" similar Postgres installs and am
getting much worse plans on the second. The DB was dumped via pg_dump
(keeping indexes, etc.) and loaded to the new server.
The first (installed via emerge):
select version();
PostgreSQL 9.4rc1 on x86_64-pc-linux-gnu, comp
