Postgres Pro
Downloads
Home   >   mailing lists

Re: PG8.2.1 choosing slow seqscan over idx scan - Mailing list pgsql-performance

From Jeremy Haile
Subject Re: PG8.2.1 choosing slow seqscan over idx scan
Date
Msg-id 1169051281.3778.1169737659@webmail.messagingengine.com
Whole thread Raw
In response to Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Tree view 
> That's about 32% dead rows.  Might be worth scheduling a vacuum full,
> but it's not like I was afraid it might be.  It looks to me like you
> could probably use a faster I/O subsystem in that machine though.

I'll try to schedule a full vacuum tonight.  As far as I/O - it's using
SAN over fiber.  Not as fast as internal SCSI though...

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Next
From: Kim
Date:
Subject: Re: [HACKERS] unusual performance for vac following 8.2