Re: [PERFORM] spikes in pgbench read-only results

2012-01-23 Thread Tomas Vondra
On 23 Leden 2012, 18:03, Merlin Moncure wrote: > 2012/1/22 Tomas Vondra : >> Hi, >> >> I'm working on a benchmark that demonstrates the effects of moving >> tables or indexes to separate devices (SSD and HDD), and one thing that >> really caught my eye are spikes in the tps charts. See this: >> >>

Re: [PERFORM] spikes in pgbench read-only results

2012-01-23 Thread Merlin Moncure
2012/1/22 Tomas Vondra : > Hi, > > I'm working on a benchmark that demonstrates the effects of moving > tables or indexes to separate devices (SSD and HDD), and one thing that > really caught my eye are spikes in the tps charts. See this: > >  http://www.fuzzy.cz/tmp/data-indexes/indexes.html > > T

[PERFORM] spikes in pgbench read-only results

2012-01-22 Thread Tomas Vondra
Hi, I'm working on a benchmark that demonstrates the effects of moving tables or indexes to separate devices (SSD and HDD), and one thing that really caught my eye are spikes in the tps charts. See this: http://www.fuzzy.cz/tmp/data-indexes/indexes.html The first one is a database with data on