Re: Some help on buffers and other performance tricks - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Some help on buffers and other performance tricks
Date
Msg-id 20051110004332.GE8230@surnet.cl
Whole thread Raw
In response to Re: Some help on buffers and other performance tricks  (Ron Peacetree <rjpeace@earthlink.net>)
Responses Re: Some help on buffers and other performance tricks  (Frank Wiles <frank@wiles.org>)
List pgsql-performance
Frank Wiles wrote:

>   Obviously there are systems/datasets/quantities where this won't
>   always work out best, but for the majority of systems out there
>   complicating your schema, maxing your hardware, and THEN tuning
>   is IMHO the wrong approach.

I wasn't suggesting to complicate the schema -- I was actually thinking
in systems where some queries are not using indexes, some queries are
plain wrong, etc.  Buying a very expensive RAID and then noticing that
you just needed to create an index, is going to make somebody feel at
least somewhat stupid.

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
Y una voz del caos me habló y me dijo
"Sonríe y sé feliz, podría ser peor".
Y sonreí. Y fui feliz.
Y fue peor.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Some help on buffers and other performance tricks
Next
From: Frank Wiles
Date:
Subject: Re: Some help on buffers and other performance tricks