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

Am 03.11.2012 18:19, schrieb Petr Praus: On 3 November 2012 12:09, Gunnar "Nick" Bluth mailto:gunnar.bl...@pro-open.de>> 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

Re: [PERFORM] Constraint exclusion in views

On Sat, Nov 3, 2012 at 10:23 PM, Tom Lane wrote: > Josh Berkus writes: >>> Funny thing is, if I set constraint_exclusion=on, it works as >>> expected. But not with constraint_exclusion=partition. > >> The difference between "on" and "partition" is how it treats UNION. >> This seems to be working

[PERFORM] Suggested test points for a performance tool?

Hello everyone, If one would create a postgres performance tool, what would one like to measure aside from the obvious things common to all databases (query times, locks etc)? I'm in the slightly difficult situation of being asked to port "Jet Profiler for MySQL" (http://www.jetprofiler.com) fo

Re: [PERFORM] Suggested test points for a performance tool?

On Mon, Nov 5, 2012 at 12:54 AM, Christoffer Lernö wrote: > • Top Queries - See which queries are being run the most on your server. > • Top Users - See which users are using your server the most. > • Top Tables - See which database tables are opened the most. > • Top States - See which states you

[PERFORM] DBT-1

where should i get the original working source code of DBT-1 bechmark and it is compatible with postgres 9.2? -- View this message in context: http://postgresql.1045698.n5.nabble.com/DBT-1-tp5730629.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via p

[PERFORM] DBT-1

where should i get the original working source code of DBT-1 benchmark and it is compatible with postgres 9.2? Best Regards [Description: a] Samrat Revagade |Software Engineer | NTTDATA Global Technology Services Pvt. Ltd.| samrat.revag...@nttdata.com