Re: PG8.2.1 choosing slow seqscan over idx scan

Поиск
Список
Период
Сортировка
От Jeremy Haile
Тема Re: PG8.2.1 choosing slow seqscan over idx scan
Дата
Msg-id 1169051281.3778.1169737659@webmail.messagingengine.com
обсуждение исходный текст
Ответ на Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance
> 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: PG8.2.1 choosing slow seqscan over idx scan
Следующее
От: Kim
Дата:
Сообщение: Re: [HACKERS] unusual performance for vac following 8.2