Re: Issues of slow running queries when dealing with Big Data

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Issues of slow running queries when dealing with Big Data
Дата
Msg-id CAHOFxGrZehS5ivsKU_HCSx67Cm4tU72CPqrOd7j6XYpL6GdOVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Issues of slow running queries when dealing with Big Data  (Shaozhong SHI <shishaozhong@gmail.com>)
Ответы Re: Issues of slow running queries when dealing with Big Data  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-general
Дерево обсуждения
Many thanks.  Is this way correct?  I am learning what is meant by 'top posting'.

Yes.

On the subject of your settings, I don't see anything for work_mem, random_page_cost and other commonly tuned parameters. That would be a good start. What sort of machine specs are there for Postgres instance? Cpu, ram, disk type (spinning disk, ssd, etc)? Are any other applications running on this machine? 

Do you have an example query and explain analyze output? Are you aware of https://explain.depesz.com/ ?

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: bad JIT decision
Следующее
От: Shaozhong SHI
Дата:
Сообщение: Re: Issues of slow running queries when dealing with Big Data