Hello
I don't know. I checked similar query on similar dataset (size), and I
have a times about 3 sec on much more worse notebook. So problem can
be in disk IO operation speed - maybe in access to TOASTed value.
2010/11/21 Humair Mohammed :
> I am running 64-bit Windows 7 Enterprise with 8G RAM a
--- On Fri, 11/19/10, Robert Klemme wrote:
> From: Robert Klemme
> Subject: Re: [PERFORM] best db schema for time series data?
> To: pgsql-performance@postgresql.org
> Date: Friday, November 19, 2010, 7:16 PM
> On Fri, Nov 19, 2010 at 10:50 AM,
> Louis-David Mitterrand
>
> wrote:
> > On Tue, No
You may also try the Sun's F5100 (flash storage array) - you may
easily get 700 MB/s just with a single I/O stream (single process), so
just with 2 streams you'll get your throughput.. - The array has 2TB
total space and max throughput should be around 4GB/s..
Rgds,
-Dimitri
On 11/18/10, Greg Sm
