Skip site navigation (1) Skip section navigation (2)

Re: Any better plan for this query?..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Any better plan for this query?..
Date: 2009-05-11 15:23:58
Message-ID: 1323.1242055438@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Dimitri <dimitrik(dot)fr(at)gmail(dot)com> writes:
> Anyone may explain me why analyze target may have so huge negative
> secondary effect?..

If these are simple queries, maybe what you're looking at is the
increase in planning time caused by having to process 10x as much
statistical data.  Cranking statistics_target to the max just because
you can is not necessarily a good strategy.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Stefan KaltenbrunnerDate: 2009-05-11 16:05:25
Subject: Re: PostgreSQL with PostGIS on embedded hardware
Previous:From: DimitriDate: 2009-05-11 15:18:31
Subject: Re: Any better plan for this query?..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group