Craig Ringer wrote:
Josh Berkus wrote:
Folks,
I turned on temp file logging for PostgreSQL to see if I needed to
adjust work_mem. Oddly, it's logging file usage up to 33 times per
executed query (and no, the query isn't large enough to need 33 separate
sorts).
Are you sure there's not a sort
Josh Berkus wrote:
> Folks,
>
> I turned on temp file logging for PostgreSQL to see if I needed to
> adjust work_mem. Oddly, it's logging file usage up to 33 times per
> executed query (and no, the query isn't large enough to need 33 separate
> sorts).
Are you sure there's not a sort happening i
Folks,
I turned on temp file logging for PostgreSQL to see if I needed to
adjust work_mem. Oddly, it's logging file usage up to 33 times per
executed query (and no, the query isn't large enough to need 33 separate
sorts).
Any idea what's going on here?
--Josh
--
Sent via pgsql-performance
