Re: Using "LIMIT" is much faster even though, searching

Поиск

Список

Период

Сортировка

От	Hyun-Sung, Jang
Тема	Re: Using "LIMIT" is much faster even though, searching
Дата	1 декабря 2004 г. 07:42:09
Msg-id	41AD4AD0.908@siche.net обсуждение исходный текст
Ответ на	Re: Using "LIMIT" is much faster even though, searching with PK. (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы	Re: Using "LIMIT" is much faster even though, searching (Josh Berkus <josh@agliodbs.com>)
Список	pgsql-performance

before test, I already executed VACUUM FULL.
this result show up after vacuum full.

Tom Lane 쓴 글:

장현성 <siche@siche.net> writes:

but, sequence scan, as you see above result, there is big time 
difference between using LIMIT and without using it.

You've got a table full of dead rows.  Try VACUUM FULL ...
		regards, tom lane

В списке pgsql-performance по дате отправления:

От: Tom Lane
Дата: 01 декабря 2004 г., 07:26:43
Сообщение: Re: Using "LIMIT" is much faster even though, searching with PK.

От: Josh Berkus
Дата: 01 декабря 2004 г., 08:06:52
Сообщение: Re: Using "LIMIT" is much faster even though, searching