From: Craig Ringer <ringerc@ringerc.id.au>
To: Silvio Brandani <silvio.brandani@tech.sdb.it>
Cc: Ruslan A. Bondar <fsat@list.ru>
Cc: pgsql-admin@postgresql.org
Subject: Re: database not using indexes
Date: Thu, 10 Nov 2011 10:43:08 +0800
Message-ID: <4EBB3A3C.1090706@ringerc.id.au> (raw)
In-Reply-To: <4EBAB303.2080307@tech.sdb.it>
References: <4EBA9AAC.9030900@tech.sdb.it>
<20111109195838.237a4470@list.ru>
<4EBAB303.2080307@tech.sdb.it>
On 10/11/11 01:06, Silvio Brandani wrote:
> Ok,
>
> the problem was on a big table on query like this:
>
> select outmessage0_.out_msg_id as out1_0_
> from edi.out_messages outmessage0_, edi.transaction_set_partners
> transactio1_
> where outmessage0_.transaction_set_partner=transactio1_.trn_set_prtn_id
> and outmessage0_.status_id='TOSND'
> and transactio1_.legacy_sender_id='ALL'
> and transactio1_.legacy_receiver_id='00004542'
> and outmessage0_.transaction_set_id='INTERNAL_USE'
> order by outmessage0_.out_msg_id
Please read:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
and as linked to there, read:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
then try again including all the information you are asked for. In
particular, you have not included EXPLAIN ANALYZE output or any
information about your PostgreSQL version. Failure to provide that
information makes it difficult or impossible to answer your question,
wasting your time and everyone else's.
We don't link to that document just for fun. It's information that is
important to answer questions properly.
--
Craig Ringer
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-admin@postgresql.org
Cc: ringerc@ringerc.id.au, silvio.brandani@tech.sdb.it, fsat@list.ru
Subject: Re: database not using indexes
In-Reply-To: <4EBB3A3C.1090706@ringerc.id.au>
* 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