20.02.2013 19:45, bricklen пишет:
> On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed<gta3user(at)gmail(dot)com> wrote:
>> Postgresql 9.2.3 is processing my query is much longer than Postgresql
>> 9.1.8:
>> Postgresql 9.1.8 - 2292 ms
>> Postgresql 9.2.3 - 163336 ms
>>
>> I provided my query in attach and the database dump too,
>> this bug is reproducible.
> 1). Can you supply the EXPLAIN ANALYZE plans for both queries?
> 2). Have you ANALYZEd the relevant tables recently?
> 3). Maybe supply the results of this query too:
>
> SELECT name, current_setting(name), source
> FROM pg_settings
> WHERE source NOT IN ('default', 'override')
> UNION ALL
> SELECT 'version' as name, version(), null;
1) Explains in attach
2) tables are does not analyzed yet
3) Here they are
Postgres 9.2.3:
"application_name" "pgAdmin III - Query Tool" "client"
"bytea_output" "escape" "session"
"client_encoding" "UNICODE" "session"
"client_min_messages" "notice" "session"
"DateStyle" "ISO, DMY" "session"
"default_text_search_config" "pg_catalog.russian" "configuration file"
"lc_messages" "ru_RU.utf-8" "configuration file"
"lc_monetary" "ru_RU.utf-8" "configuration file"
"lc_numeric" "ru_RU.utf-8" "configuration file"
"lc_time" "ru_RU.utf-8" "configuration file"
"listen_addresses" "*" "configuration file"
"log_timezone" "W-SU" "configuration file"
"max_connections" "100" "configuration file"
"max_stack_depth" "2MB" "environment variable"
"port" "5432" "environment variable"
"shared_buffers" "24MB" "configuration file"
"TimeZone" "W-SU" "configuration file"
"version" "PostgreSQL 9.2.3 on x86_64-pc-linux-gnu, compiled by
x86_64-pc-linux-gnu-gcc (Gentoo 4.5.4 p1.0, pie-0.4.7) 4.5.4, 64-bit" ""
Postgres 9.1.8:
"application_name" "pgAdmin III - Query Tool" "client"
"bytea_output" "escape" "session"
"client_encoding" "UNICODE" "session"
"client_min_messages" "notice" "session"
"DateStyle" "ISO, DMY" "session"
"default_text_search_config" "pg_catalog.russian" "configuration file"
"lc_messages" "ru_RU.utf-8" "configuration file"
"lc_monetary" "ru_RU.utf-8" "configuration file"
"lc_numeric" "ru_RU.utf-8" "configuration file"
"lc_time" "ru_RU.utf-8" "configuration file"
"listen_addresses" "*" "configuration file"
"log_timezone" "W-SU" "environment variable"
"max_connections" "100" "configuration file"
"max_stack_depth" "2MB" "environment variable"
"port" "5432" "environment variable"
"shared_buffers" "24MB" "configuration file"
"silent_mode" "on" "command line"
"TimeZone" "W-SU" "environment variable"
"version" "PostgreSQL 9.1.8 on x86_64-pc-linux-gnu, compiled by
x86_64-pc-linux-gnu-gcc (Gentoo 4.5.4 p1.0, pie-0.4.7) 4.5.4, 64-bit" ""