Re: Some Solaris notes, and an invitation

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Some Solaris notes, and an invitation
Date: 2002-06-25 12:31:45
Message-ID: 20020625083145.J26398@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

On Tue, Jun 25, 2002 at 12:08:54PM +1200, Kurt at iadvance wrote:

> Are there any actual times you can provide on operations on
> some big tables (if you have any of around 10-100 Gb say) - just
> 'select count(*)' kind of stuff, maybe a 'select *' where its doing a
> sequential scan?

Ok, let me see what I can do today.

A

> We're using commodity hardware - AMD XP's - and wonder
> how what kind performance you can get with the 'big iron'.

Keep in mind that it's not always speed you're getting from the big
iron. In this case, for instance, part of the advantage is
redundancy.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mourad EL HADJ MIMOUNE 2002-06-25 12:52:18 Re: Table name length (maximum identifier length)
Previous Message Andrew Sullivan 2002-06-25 12:30:24 Re: Some Solaris notes, and an invitation

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-06-25 13:38:52 Re: Reduce heap tuple header size
Previous Message Andrew Sullivan 2002-06-25 12:30:24 Re: Some Solaris notes, and an invitation