pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Claude Speed <gta3user@gmail.com>
To: pgsql-bugs@postgresql.org
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
Date: Thu, 21 Feb 2013 12:55:06 +0400
Message-ID: <5125E0EA.2090509@gmail.com> (raw)
In-Reply-To: <5125C676.2040202@gmail.com>
References: <5125C676.2040202@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>

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" 	""

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Attachments:

  [image/jpeg] psql9.2.3.jpeg (130.0K, ../5125E0EA.2090509@gmail.com/3-psql9.2.3.jpeg)
  download | view image

  [image/jpeg] psql9.1.8.jpeg (127.9K, ../5125E0EA.2090509@gmail.com/4-psql9.1.8.jpeg)
  download | view image

view thread (8+ messages)  latest in thread

Message-ID: <5125E0EA.2090509@gmail.com>
Permalink:  ../5125E0EA.2090509@gmail.com/
Also on:    postgresql.org/message-id/5125E0EA.2090509@gmail.com

copy link · copy postgr.es

reply

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-bugs@postgresql.org
  Cc: gta3user@gmail.com
  Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
  In-Reply-To: <5125E0EA.2090509@gmail.com>

* 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