Home > mailing lists

large database on postgres - Mailing list pgsql-general

From	Tony Carter
Subject	large database on postgres
Date	June 14, 2002 18:49:42
Msg-id	DJEGLLPNDIAAIGPJHAALGEBEDFAA.tony@iat.net Whole thread Raw
Responses	Re: large database on postgres Re: large database on postgres Re: large database on postgres
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:

From: "David Siebert"
Date: 14 June 2002, 18:49:39
Subject: Re: read this and puke

From: Mike Mascari
Date: 14 June 2002, 19:05:13
Subject: Possible feature

large database on postgres - Mailing list pgsql-general

Previous

Next