Re: [PERFORM] Partitions and work_mem?

2014-11-17 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Oct 16, 2014 12:58 AM, Tom Lane t...@sss.pgh.pa.us wrote: That is in fact exactly what people pay Red Hat to do, and it was my job to do it for Postgres when I worked there. I don't work there any more, but I'm sure my replacement is entirely

Re: [PERFORM] Partitions and work_mem?

2014-11-17 Thread Dave Johansen
On Mon, Nov 17, 2014 at 8:13 AM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Oct 16, 2014 12:58 AM, Tom Lane t...@sss.pgh.pa.us wrote: That is in fact exactly what people pay Red Hat to do, and it was my job to do it for Postgres when I worked there.

Re: [PERFORM] Partitions and work_mem?

2014-11-16 Thread Dave Johansen
On Wed, Oct 15, 2014 at 3:25 PM, Josh Berkus j...@agliodbs.com wrote: On 10/15/2014 01:19 PM, Dave Johansen wrote: Sorry I don't understand what you mean by that. My understanding is that RedHat maintains fixes for security and other major issues for packages that have been EOLed. Are you

Re: [PERFORM] Partitions and work_mem?

2014-11-16 Thread Magnus Hagander
On Oct 16, 2014 12:58 AM, Tom Lane t...@sss.pgh.pa.us wrote: Igor Neyman iney...@perceptron.com writes: From: Dave Johansen [mailto:davejohan...@gmail.com] This conversation has probably become a bit off topic, but my understanding is that what you're paying RedHat for is a stable platform

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Josh Berkus
On 10/14/2014 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 merge sorts of

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Dave Johansen
On Wed, Oct 15, 2014 at 10:10 AM, Josh Berkus j...@agliodbs.com wrote: On 10/14/2014 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.

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Igor Neyman
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Dave Johansen Sent: Wednesday, October 15, 2014 4:05 PM To: Josh Berkus Cc: pgsql-performance Subject: Re: [PERFORM] Partitions and work_mem? On Wed, Oct 15, 2014 at 10:10 AM, Josh Berkus

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Dave Johansen
*Subject:* Re: [PERFORM] Partitions and work_mem? On Wed, Oct 15, 2014 at 10:10 AM, Josh Berkus j...@agliodbs.com wrote: On 10/14/2014 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

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Igor Neyman
From: Dave Johansen [mailto:davejohan...@gmail.com] Sent: Wednesday, October 15, 2014 4:20 PM To: Igor Neyman Cc: Josh Berkus; pgsql-performance Subject: Re: [PERFORM] Partitions and work_mem? On Wed, Oct 15, 2014 at 1:08 PM, Igor Neyman iney...@perceptron.commailto:iney...@perceptron.com

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Dave Johansen
On Wed, Oct 15, 2014 at 1:36 PM, Igor Neyman iney...@perceptron.com wrote: *From:* Dave Johansen [mailto:davejohan...@gmail.com] *Sent:* Wednesday, October 15, 2014 4:20 PM *To:* Igor Neyman *Cc:* Josh Berkus; pgsql-performance *Subject:* Re: [PERFORM] Partitions and work_mem? On Wed

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Igor Neyman
From: Dave Johansen [mailto:davejohan...@gmail.com] Sent: Wednesday, October 15, 2014 4:49 PM To: Igor Neyman Cc: Josh Berkus; pgsql-performance Subject: Re: [PERFORM] Partitions and work_mem? On Wed, Oct 15, 2014 at 1:36 PM, Igor Neyman iney...@perceptron.commailto:iney...@perceptron.com

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Josh Berkus
On 10/15/2014 01:19 PM, Dave Johansen wrote: Sorry I don't understand what you mean by that. My understanding is that RedHat maintains fixes for security and other major issues for packages that have been EOLed. Are you implying that that's not the case? Or something else? RH probably

Re: [PERFORM] Partitions and work_mem?

2014-10-15 Thread Tom Lane
Igor Neyman iney...@perceptron.com writes: From: Dave Johansen [mailto:davejohan...@gmail.com] This conversation has probably become a bit off topic, but my understanding is that what you're paying RedHat for is a stable platform for a long period of time. That means creating/backporting of

[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

Re: [PERFORM] Partitions and work_mem?

2014-10-14 Thread Jeff Janes
On Tue, Oct 14, 2014 at 10:08 AM, Dave Johansen davejohan...@gmail.com 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