Re: large database on postgres - Mailing list pgsql-general

From Tony Carter
Subject Re: large database on postgres
Date
Msg-id DJEGLLPNDIAAIGPJHAALEEDPDFAA.tony@iat.net
Whole thread Raw
In response to Re: large database on postgres  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
Yup, its a typo! It should read 256mb.
-Thanks


-----Original Message-----
From: Bill Moran [mailto:wmoran@potentialtech.com]
Sent: Friday, June 14, 2002 5:36 PM
To: Tony Carter
Cc: pgsql-general@postgresql.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


pgsql-general by date:

Previous
From: "Tony Carter"
Date:
Subject: Re: large database on postgres
Next
From: "Bertin, Philippe"
Date:
Subject: Re: Clients for administration?