Re: [PERFORM] Partitions and work_mem?

2014-10-14 Thread Jeff Janes
On Tue, Oct 14, 2014 at 10:08 AM, Dave Johansen wrote: > I'm running Postgres 8.4 on RHEL 6 64-bit and I had a question about how > work_mem and partitions interact. > > https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#work_mem > The above wiki states that "if a query involves doing

[PERFORM] Partitions and work_mem?

2014-10-14 Thread Dave Johansen
I'm running Postgres 8.4 on RHEL 6 64-bit and I had a question about how work_mem and partitions interact. https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#work_mem The above wiki states that "if a query involves doing merge sorts of 8 tables, that requires 8 times work_mem." If I ha