Large temporary file generated during query

Поиск
Список
Период
Сортировка
От Ryan Kelly
Тема Large temporary file generated during query
Дата
Msg-id 20121207215804.GA23450@llserver.lakeliving.com
обсуждение исходный текст
Ответы Re: Large temporary file generated during query
Список pgsql-general
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. The query has the following sequence
of plan nodes when run through EXPLAIN:

HashAggregate -> Result -> Append -> [Seq Scan | Bitmap Heap Scan, ...]

Where there are many "Seq Scan" or "Bitmap Heap Scan" nodes being
generated, one for each partition of the partitioned table.

So, why are these files being created?

Also, I suppose this data on-disk can be kept in memory instead by increasing
work_mem to a suitable value?

Thanks,
-Ryan Kelly


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: unlooged tables
Следующее
От: Aleksey Tsalolikhin
Дата:
Сообщение: Re: How to mix psql commands and SQL commands on the shell command line?