Re: Query only slow on first run

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query only slow on first run
Дата
Msg-id 24967.1196288664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query only slow on first run  (cluster <skrald@amossen.dk>)
Ответы Re: Query only slow on first run  (cluster <skrald@amossen.dk>)
Список pgsql-performance
cluster <skrald@amossen.dk> writes:
> I could really use any kind of suggestion on how to improve the query in
> order to make it scale better for large data sets The 6-7000 ms for a
> clean run is really a showstopper. Need to get it below 70 ms somehow.

Buy a faster disk?

You're essentially asking for a random sample of data that is not
currently in memory.  You're not going to get that without some I/O.

            regards, tom lane

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

Предыдущее
От: Jean-David Beyer
Дата:
Сообщение: Re: Query only slow on first run
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Query only slow on first run