Hi, Cristopher,
Christopher Kings-Lynne schrieb:
Are there any tools that help with postgres/postgis performance tuning?
So they measure the acutal tuple costs and cpu power, or suggest optimal
values for the index sample counts?
Have you turned on the stat_* settings in postgresql.conf and
Markus,
As far as I examined, those views only count several things like fetched
rows and pages, and cache hits.
I would like something that really measures values like random_page_cost
or cpu_tuple_cost that are hardware dependent.
I assume such thing does not exist?
Nope. You gotta
Josh Berkus josh@agliodbs.com writes:
I would like something that really measures values like random_page_cost
or cpu_tuple_cost that are hardware dependent.
I assume such thing does not exist?
Nope. You gotta whip out your calculator and run some queries.
Preferably a whole lot of
On Mon, Jan 31, 2005 at 03:26:12PM -0500, Tom Lane wrote:
Josh Berkus josh@agliodbs.com writes:
I would like something that really measures values like random_page_cost
or cpu_tuple_cost that are hardware dependent.
I assume such thing does not exist?
Nope. You gotta whip out your
Jim C. Nasby [EMAIL PROTECTED] writes:
On Mon, Jan 31, 2005 at 03:26:12PM -0500, Tom Lane wrote:
Preferably a whole lot of queries. All the measurement techniques I can
think of are going to have a great deal of noise, so you shouldn't
twiddle these cost settings based on just a few examples.
On Tue, Feb 01, 2005 at 12:06:27AM -0500, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
On Mon, Jan 31, 2005 at 03:26:12PM -0500, Tom Lane wrote:
Preferably a whole lot of queries. All the measurement techniques I can
think of are going to have a great deal of noise, so you
Are there any tools that help with postgres/postgis performance tuning?
So they measure the acutal tuple costs and cpu power, or suggest optimal
values for the index sample counts?
Have you turned on the stat_* settings in postgresql.conf and then
examined the pg_stat_* system views?
Chris