Re: [PERFORM] pg9 replication over WAN ?

2011-10-06 Thread mark
> -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, >

Re: [PERFORM] : Performance Improvement Strategy

2011-10-06 Thread Scott Marlowe
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

Re: [PERFORM] : Performance Improvement Strategy

2011-10-06 Thread Raghavendra
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