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

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] Discovering the most searched values for a field

Em 13-01-2012 17:08, Josh Berkus escreveu: On 1/13/12 10:08 AM, alexandre - aldeia digital wrote: Hi, Is there a simple way (or a tool) to discover the most searched values in a field from a table ? In the pg_stats, I can see the most common values generated by ANALYZE, but I want to know how

Re: [PERFORM] Partitioning by status?

Em 13-01-2012 17:05, Josh Berkus escreveu: On 1/13/12 2:44 AM, alexandre - aldeia digital wrote: Also, (2) only really works if you're going to obsolesce (remove) archive records after a certain period of time. Otherwise the sub-partitioning hurts performance. Is there any moves to include

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

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