Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 6 November 2012 14:50, Gunnar "Nick" Bluth wrote: > Am 06.11.2012 21:24, schrieb Petr Praus: > > On 6 November 2012 14:17, Gunnar "Nick" Bluth wrote: > >> Am 06.11.2012 21:08, schrieb Petr Praus: >> >> >>> 2MB: http://explain.depesz.c

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 4 November 2012 02:48, Gunnar "Nick" Bluth wrote: > Am 03.11.2012 18:19, schrieb Petr Praus: > > On 3 November 2012 12:09, Gunnar "Nick" Bluth wrote: > >> Am 03.11.2012 16:20, schrieb Petr Praus: >> >> >>Your CPUs are indeed pr

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 6 November 2012 13:38, Gunnar "Nick" Bluth wrote: > Am 06.11.2012 18:38, schrieb Petr Praus: > > > Yes, but note that this happens only in Linux. Increasing work_mem on my > iMac increases performance (but the queries are slower under OSX than on > virtualize

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 6 November 2012 14:17, Gunnar "Nick" Bluth wrote: > Am 06.11.2012 21:08, schrieb Petr Praus: > > >> 2MB: http://explain.depesz.com/s/**ul1 <http://explain.depesz.com/s/ul1> >> 4MB: http://explain.depesz.com/s/**IlVu<http://explain.depesz.com/s/IlVu>

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

e kernel version that you using (particularly in Linux systems) > - the tuning to kernel variables > - the type of discs that you are using (SSDs are very fast, like you saw > in your iMac system) > > On 10/30/2012 02:44 PM, Petr Praus wrote: > > I just found one particularly interesting

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 3 November 2012 05:31, Gunnar "Nick" Bluth wrote: > Am 02.11.2012 17:12, schrieb Petr Praus: > > Your CPUs are indeed pretty oldschool. FSB based, IIRC, not NUMA. A > process migration would be even more expensive there. > >Might be worth to >> - manua

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

On 3 November 2012 12:09, Gunnar "Nick" Bluth wrote: > Am 03.11.2012 16:20, schrieb Petr Praus: > > >Your CPUs are indeed pretty oldschool. FSB based, IIRC, not NUMA. A >> process migration would be even more expensive there. >> >> > Ok, I've a

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

lesystem that you are using > - the kernel version that you using (particularly in Linux systems) > - the tuning to kernel variables > - the type of discs that you are using (SSDs are very fast, like you saw > in your iMac system) > > > On 10/30/2012 02:44 PM, Petr Praus wrote: &g

Re: [PERFORM] Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

I did run each query several times, the results I posted are for ~10th run of the query. The zone reclaim mode is 0. On 2 November 2012 00:39, Scott Marlowe wrote: > Two possibilities: > > caching. make sure to run each query several times in a row. > > zone reclaim mode. If this has gotten t

[PERFORM] Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

ng but it doesn't really explain it. [1]: http://pgfoundry.org/projects/pgtune/ [2]: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server [3]: http://www.depesz.com/2011/07/03/understanding-postgresql-conf-work_mem/ Thanks, Petr Praus PS: I also posted the question here: http:

[PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

would expect. What am I doing wrong here? Thanks. On 30 October 2012 14:08, Petr Praus wrote: > Hello, > > I have a PostgreSQL 9.2 instance running on RHEL 6.3, 8-core machine with > 16GB of RAM. The server is dedicated to this database, the disks are local > RAID10. Given that