Quick Links

large database on postgres

From:	"Tony Carter" <tony(at)iat(dot)net>
To:	<pgsql-general(at)postgresql(dot)org>
Subject:	large database on postgres
Date:	2002-06-13 22:20:07
Message-ID:	DJEGLLPNDIAAIGPJHAALGEBEDFAA.tony@iat.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: large database on postgres at 2002-06-14 21:17:05 from Stephan Szabo
Re: large database on postgres at 2002-06-14 21:35:44 from Bill Moran
Re: large database on postgres at 2002-06-15 14:02:53 from Francisco Reyes
Re: large database on postgres at 2002-06-22 09:10:55 from Curt Sampson

Browse pgsql-general by date

	From	Date	Subject
Next Message	McCaffity, Ray (Contractor)	2002-06-13 22:41:24	Re: read this and puke
Previous Message	chris.gamble	2002-06-13 22:13:46	Re: read this and puke