From: Marcus Engene <mengpg2@engene.se>
To: pgsql-performance@postgresql.org
Subject: Re: wildcard makes seq scan on prod db but not in test
Date: Mon, 09 May 2011 21:11:00 +0200
Message-ID: <4DC83C44.5070206@engene.se> (raw)
In-Reply-To: <4DC7F2B3020000250003D424@gw.wicourts.gov>
References: <4DC82D28.7020105@engene.se>
<4DC7F2B3020000250003D424@gw.wicourts.gov>
On 5/9/11 8:57 , Kevin Grittner wrote:
>
> That could be a difference is collations. What do you get from the
> query on this page for each database?:
>
> http://wiki.postgresql.org/wiki/Server_Configuration
>
> -Kevin
>
>
There's indeed a different collation. Why is this affecting? Can i force
a column to be ascii?
The (fast) test server:
version | PostgreSQL 9.0.4 on x86_64-apple-darwin10.7.0,
compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc.
build 5664), 64-bit
effective_cache_size | 512MB
lc_collate | C
lc_ctype | UTF-8
maintenance_work_mem | 128MB
max_connections | 100
max_stack_depth | 2MB
port | 5435
server_encoding | UTF8
shared_buffers | 512MB
temp_buffers | 8192
TimeZone | Europe/Zurich
wal_buffers | 1MB
work_mem | 128MB
(14 rows)
The (slow) production server:
version | PostgreSQL 9.0.4 on
x86_64-unknown-linux-gnu, compiled by
GCC gcc (Debian 4.3.2-1.1) 4.3.2, 64-bit
checkpoint_completion_target | 0.9
checkpoint_segments | 64
effective_cache_size | 48GB
lc_collate | en_US.UTF-8
lc_ctype | en_US.UTF-8
listen_addresses | localhost,10.0.0.3,74.50.57.76
maintenance_work_mem | 1GB
max_connections | 600
max_stack_depth | 2MB
port | 5435
server_encoding | UTF8
shared_buffers | 8GB
temp_buffers | 32768
TimeZone | UTC
work_mem | 128MB
(16 rows)
Thanks,
Marcus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mengpg2@engene.se
Subject: Re: wildcard makes seq scan on prod db but not in test
In-Reply-To: <4DC83C44.5070206@engene.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox