From: ach <alanchines@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: statistics target for columns in unique constraint?
Date: Sat, 18 May 2013 08:35:51 -0700 (PDT)
Message-ID: <1368891351220-5756093.post@n5.nabble.com> (raw)
In-Reply-To: <51916C59.6010700@catalyst.net.nz>
References: <1368457293547-5755256.post@n5.nabble.com>
<CABRT9RBwmDxjq-tzLMh6rFX-suJYVQMiGSQAADsueg07rvB1dg@mail.gmail.com>
<51916C59.6010700@catalyst.net.nz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Thanks guys! I'm gonna try tuning the statistics back down to 10 on that
table and see what that does to the insertion rates. Oh and for Mark: Not
to worry - i'd actually tuned the stats there up myself awhile ago in an
experiment to see if -that- would've sped insertions some; back before i'd
had enough mileage on postgres for it to have occurred to me that might just
have been useless ;-)
One quick follow up since I'm expecting y'all might know: Do the statistics
targets actually speed performance on an index search itself; the actual
lookup? Or are the JUST to inform the planner towards the best pathway
decision? In other words if I have statistics set to 1000, say, in one
case, and the planner chose the exact same path it would have if they'd just
been set to 100, would the lookup return faster when the stats were at 1000?
Or would it actually take the same time either way? My hunch is it's the
latter...
--
View this message in context: http://postgresql.1045698.n5.nabble.com/statistics-target-for-columns-in-unique-constraint-tp5755256...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: alanchines@gmail.com
Subject: Re: statistics target for columns in unique constraint?
In-Reply-To: <1368891351220-5756093.post@n5.nabble.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