Re: Large temporary file generated during query

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Large temporary file generated during query
Дата
Msg-id CAMkU=1z9fGHF=2dChs4W-=6suE2JCEpXR6NHQ=F3TmtcxhR8CA@mail.gmail.com
обсуждение исходный текст
Ответ на Large temporary file generated during query  (Ryan Kelly <rpkelly22@gmail.com>)
Ответы Re: Large temporary file generated during query
Список pgsql-general
Дерево обсуждения 
On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly <rpkelly22@gmail.com> wrote:
> I have a very large query that also touches quite a bit of data. It
> generates a large temporary file (actually, several, because the total
> size is about 4.5GB). I'm wondering which part of the query's plan
> causes these files to be created.

Doing an "explain (analyze, buffers)" should tell you that.

Cheers,

Jeff

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

Предыдущее
От: Aleksey Tsalolikhin
Дата:
Сообщение: Re: How to mix psql commands and SQL commands on the shell command line?
Следующее
От: wd
Дата:
Сообщение: Re: How to find which query a waiting query waiting for?