Postgres Pro
Downloads
Home   >   mailing lists

large database on postgres - Mailing list pgsql-general

From Tony Carter
Subject large database on postgres
Date
Msg-id DJEGLLPNDIAAIGPJHAALGEBEDFAA.tony@iat.net
Whole thread Raw
Responses Re: large database on postgres  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: large database on postgres  (Francisco Reyes <lists@natserv.com>)
Re: large database on postgres  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
Tree view 
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
need SCSI but is there any tuning I can do to speed this up?

-Tony

pgsql-general by date:

Previous
From: "David Siebert"
Date:
Subject: Re: read this and puke
Next
From: Mike Mascari
Date:
Subject: Possible feature