Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PG8.2.1 choosing slow seqscan over idx scan
- From: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
- To: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>
- Cc: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
- Date: Wed, 17 Jan 2007 11:28:01 -0500
> 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...
- Follow-Ups:
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Scott Marlowe
- Re: PG8.2.1 choosing slow seqscan over idx scan
- References:
- PG8.2.1 choosing slow seqscan over idx scan
- From: Jeremy Haile
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Tom Lane
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Jeremy Haile
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Chad Wagner
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Jeremy Haile
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Scott Marlowe
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Jeremy Haile
- Re: PG8.2.1 choosing slow seqscan over idx scan
- From: Scott Marlowe
- PG8.2.1 choosing slow seqscan over idx scan
- Prev by Date: Re: PG8.2.1 choosing slow seqscan over idx scan
- Next by Date: Re: [HACKERS] unusual performance for vac following 8.2
- Previous by thread: Re: PG8.2.1 choosing slow seqscan over idx scan
- Next by thread: Re: PG8.2.1 choosing slow seqscan over idx scan
- Indexes: