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
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... |