From: Ioannis Anagnostopoulos <ioannis@anatec.com>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: A very long running query....
Date: Sat, 21 Jul 2012 20:24:24 +0100
Message-ID: <500B01E8.1000405@anatec.com> (raw)
In-Reply-To: <CAGTBQpYTtCsvOL7APqwo2EM+A4GBAB3uGg2gnS1Mkp27b51iYw@mail.gmail.com>
References: <5007FC82.9070007@anatec.com>
<5009CB5A.7070801@anatec.com>
<CAGTBQpa07PMrLA3qsM9Zf9QXcPvgntyVX7qL9CqEwQtK9LH1hA@mail.gmail.com>
<5009CD43.8000300@anatec.com>
<CAGTBQpYY1cVYZtVNt9mdHjhZy=wQZac-aERAcmkeXs2D+Ym7cA@mail.gmail.com>
<3639.1342825802@sss.pgh.pa.us>
<500B0014.5070600@anatec.com>
<CAGTBQpYTtCsvOL7APqwo2EM+A4GBAB3uGg2gnS1Mkp27b51iYw@mail.gmail.com>
On 21/07/2012 20:19, Claudio Freire wrote:
> On Sat, Jul 21, 2012 at 4:16 PM, Ioannis Anagnostopoulos
> <ioannis@anatec.com> wrote:
>> I am not sure that I can see an improvement, at least on src_id that have
>> lots of msg_id per day the query never returned even 5 hours later running
>> "exaplain analyze". For smaller src_id
>> (message wise) there might be some improvement or it was just the analyse
>> that I run. As I said the stats goes quickly out of scope because of the big
>> number of updates. So it looks like that
>> it is not the "funny" "where" concatenation or some kind of index
>> construction problem. Which brings us back to the issue of the
>> "statistics_target" on per column. My problem is that given the
>> query plan I provided you yesterday, I am not sure which columns
>> statistics_target to touch and what short of number to introduce. Is there
>> any rule of thumb?
> What's the size of your index, tables, and such?
> In GB I mean, not tuples.
The message_copies_wk2 that I currently hit is 13GB and 11 the Indexes, the
ship_a_pos_messages_wk2 is 17GB and 2.5MB the index and the ship_objects
is 150MB table and index approx.
Yiannis
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: ioannis@anatec.com, klaussfreire@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: A very long running query....
In-Reply-To: <500B01E8.1000405@anatec.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