On Thu, 13 Jun 2002, 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
> need SCSI but is there any tuning I can do to speed this up?
Well, let's do the standard info requests :)
Have you used vacuum analyze? What's the schema, query, and explain (or
explain analyze if you're using 7.2) output for the query.