From: Mark Thornton <mthornton@optrak.com>
To: pgsql-performance@postgresql.org
Subject: Performance of CLUSTER
Date: Sun, 10 Jun 2012 09:20:26 +0100
Message-ID: <4FD458CA.3070902@optrak.com> (raw)
What is the expected performance of cluster and what tuning parameters
have most effect?
I have a set of 5 tables with identical structure (all inherit a common
table). The sizes given are total relation size. The clustering index is
a gist index on a (non null) geographic(linestring) column
1. 327600 rows, 105MB, 15.8s
2. 770165 rows, 232MB, 59.5s
3. 1437041 rows, 424MB, 140s
4. 3980922 rows, 1167MB, 276s
5. 31843368 rows, 9709MB, ~ 10 hours
Server is version 9.1. with postgis 1.5.4.
Regards,
Mark Thornton
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: mthornton@optrak.com
Subject: Re: Performance of CLUSTER
In-Reply-To: <4FD458CA.3070902@optrak.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