Re: large database on postgres

From: "Tony Carter" <tony(at)iat(dot)net>
To: "Bill Moran" <wmoran(at)potentialtech(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: large database on postgres
Date: 2002-06-14 22:19:10
Message-ID: DJEGLLPNDIAAIGPJHAALEEDPDFAA.tony@iat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yup, its a typo! It should read 256mb.
-Thanks

-----Original Message-----
From: Bill Moran [mailto:wmoran(at)potentialtech(dot)com]
Sent: Friday, June 14, 2002 5:36 PM
To: Tony Carter
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] large database on postgres

Tony Carter wrote:
> Hello,
> I have one application that I'm trying to move the db to pgsql. The db
> contains around 15 million rows of data. I'm running into 10 second delays
> when doing a simple select on an index column.
>
> My test box is Linux 1ghz Celeron 25MB Ram, 7200rpm IDE drive. I know I
^^
Is this a typo? If not, I would suggest that you're going to need more than
25M for a db server with 15mil rows if you want hot performance!

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-06-14 22:22:35 Re: I must be blind...
Previous Message Nigel J. Andrews 2002-06-14 22:09:49 Re: I must be blind...