> -Original Message-
> From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
> ow...@postgresql.org] On Behalf Of Ben Ciceron
> Sent: Wednesday, October 05, 2011 3:53 PM
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] pg9 replication over WAN ?
>
> Hello,
>
On Wed, Oct 5, 2011 at 12:15 PM, Tom Lane wrote:
> Scott Marlowe writes:
>> It used to be that cluster on a very randomly ordered table was much
>> slower than doing something like select * into newtable from oldtable
>> order by col1, col2; Is that still the case in 9.0/9.1?
>
> Fixed in 9.1, p
Thanks Kevin.
Am in 9.1 and tested same scenario, how exactly storage metrics are
calculated. Please comment.
*Table Structure:*
postgres=# \d test
Table "public.test"
Column | Type | Modifiers
+-+---
id | integer |
name | text|
*No. of rows:*
postgr