20.02.2013 19:45, bricklen пишет:
On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed <gta3user@gmail.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" | "" |