On Nov 1, 2010, at 9:15 AM, Dan Schaffer wrote:
> We have an application that needs to do bulk reads of ENTIRE Postgres tables
> very quickly (i.e. select * from table). We have observed that such
> sequential scans run two orders of magnitude slower than observed raw disk
> reads (5 MB/s versu
Try going through the archives first because your question probably
has been answered many times already (altho there is no definitive
question as to what server postgresql would need to run to fit your
purpose).
Also, this is English list. If you prefer to ask questions in
Brazilian/Portuguese th
> -Original Message-
> From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
> ow...@postgresql.org] On Behalf Of Benjamin Krajmalnik
> Sent: Monday, December 13, 2010 1:45 PM
> To: Greg Smith
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Hardware recom
2010/12/8 salima :
>
> Pessoal,
>
> Estou com uma dúvida ao fazer Tunning no arquivo de configuração do
> Postgres.
>
> Minha aplicação tem varios acessos simultâneos, chegando picos de 2000 mil
> ou até mais. Por ser uma aplicação Web fica dificil de se estipular o
> "max_connections", sem contar
> -Original Message-
> From: Greg Smith [mailto:g...@2ndquadrant.com]
> Sent: Saturday, December 11, 2010 2:18 AM
> To: Benjamin Krajmalnik
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Hardware recommendations
>
>
> What sort of total read/write rates are you seeing w
On 12/12/10 6:43 PM, Royce Ausburn wrote:
> Hi all,
>
> I notice that when restoring a DB on a laptop with an SDD, typically postgres
> is maxing out a CPU - even during a COPY. I wonder, what is postgres usually
> doing with the CPU? I would have thought the disk would usually be the
> bottl
On 12/13/2010 10:43 AM, Royce Ausburn wrote:
Hi all,
I notice that when restoring a DB on a laptop with an SDD, typically postgres
is maxing out a CPU - even during a COPY. I wonder, what is postgres usually
doing with the CPU? I would have thought the disk would usually be the
bottleneck i
