Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Melvin Davidson
On Tue, Nov 8, 2016 at 1:53 PM, Hector Yuen wrote: > Hello, > > I am confused on which are the parameters for different queries. I am > trying to run VACUUM on a big table, and it is easier for me to set the > work memory for the specific session instead of tuning it in >

[GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Hector Yuen
Hello, I am confused on which are the parameters for different queries. I am trying to run VACUUM on a big table, and it is easier for me to set the work memory for the specific session instead of tuning it in postgresql.conf. I noticed that if I do: set work_mem='1GB'; it doesn't help VACUUM,

Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Melvin Davidson
On Wed, Nov 9, 2016 at 10:05 AM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 15:54:13, skrev Adrian Klaver < > adrian.kla...@aklaver.com>: > > On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > > På onsdag 09. november 2016 kl. 03:02:54, skrev John R

Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread David G. Johnston
On Wed, Nov 9, 2016 at 7:54 AM, Adrian Klaver wrote: > On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > > > > > > https://www.postgresql.org/docs/current/static/runtime- > config-resource.html >

Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Andreas Joseph Krogh
På onsdag 09. november 2016 kl. 15:54:13, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > >:

Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Adrian Klaver
On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > >: > > On 11/8/2016 2:34 PM, Hector Yuen wrote: > > I am confused on which are the parameters for different queries. I am

Re: [GENERAL] which work memory parameter is used for what?

2016-11-08 Thread Andreas Joseph Krogh
På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce < pie...@hogranch.com >: On 11/8/2016 2:34 PM, Hector Yuen wrote: > I am confused on which are the parameters for different queries. I am > trying to run VACUUM on a big table, and it is easier for me to

Re: [GENERAL] which work memory parameter is used for what?

2016-11-08 Thread John R Pierce
On 11/8/2016 2:34 PM, Hector Yuen wrote: I am confused on which are the parameters for different queries. I am trying to run VACUUM on a big table, and it is easier for me to set the work memory for the specific session instead of tuning it in postgresql.conf. I noticed that if I do: set

[GENERAL] which work memory parameter is used for what?

2016-11-08 Thread Hector Yuen
Hello, I am confused on which are the parameters for different queries. I am trying to run VACUUM on a big table, and it is easier for me to set the work memory for the specific session instead of tuning it in postgresql.conf. I noticed that if I do: set work_mem='1GB'; it doesn't help VACUUM,