Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] A Better External Sort? - Mailing list pgsql-performance

From Michael Stone
Subject Re: [HACKERS] A Better External Sort?
Date
Msg-id 20051005094315.GX2241@mathom.us
Whole thread Raw
In response to Re: [HACKERS] A Better External Sort?  (Hannu Krosing <hannu@skype.net>)
List pgsql-performance
Tree view 
On Tue, Oct 04, 2005 at 12:43:10AM +0300, Hannu Krosing wrote:
>Just FYI, I run a count(*) on a 15.6GB table on a lightly loaded db and
>it run in 163 sec. (Dual opteron 2.6GHz, 6GB RAM, 6 x 74GB 15k  disks in
>RAID10, reiserfs). A little less than 100MB sec.

And none of that 15G table is in the 6G RAM?

Mike Stone

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: [HACKERS] A Better External Sort?
Next
From: "Douglas J. Trainor"
Date:
Subject: Re: Is There Any Way ....