Re: [PERFORM] CPU load

of keeping it in memory (should it be really needed) ? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent via pgsql-performance

Re: [PERFORM] CPU bound at 99%

Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

8.1 ??? -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org

Re: [PERFORM] viewing source code

persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

[PERFORM] URI to kind of a benchmark

) of the speed has doubled. If reality confirmes, that 8.2 to 8.3 will be a small step in versions, and a great step in databases. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place

Re: [PERFORM] Performance on 8CPU's and 32GB of RAM

Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you there!

Re: [PERFORM] Data transfer very slow when connected via DSL

. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you there!

Re: [PERFORM] Data transfer very slow when connected via DSL

it took locally. Also, PG can now COPY from a query, so you don't really need the temp table... I know, but was stuck to 8.1 on some servers. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179

Re: [PERFORM] Data transfer very slow when connected via DSL

not find a solution so far; and for bulk data transfers I now programmed a workaround. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2007 will take place in Vilnius, Lithuania from Monday

Re: [PERFORM] Kernel cache vs shared_buffers

on Windows: set shared_buffers to minimum * 2 Adjust effective_cache_size to the number given as system cache within the task manager. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language

Re: [PERFORM] Kernel cache vs shared_buffers

persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

version possible (perhaps even for money :) which gives nice graphics and optimized, like those Windows Optimizers. :) I am sure, some DBAs in BIGCOMPs would be thrilled :) May that be a possible way? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

. And I really did not want to discredit the idea of properly configuring from the start. Just wanted to open an other option to do that tuning. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python

Re: [PERFORM] PostgreSQL in virtual machine

shared_buffers yielded better results. Growing effective_cache_size yielded the best results for me. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than

Re: [PERFORM] Tuning

default 2, and the system is responding better; especially after fixing the available memory setting within the planner. ... frustrating part is, I could not replicate this behavious with pg_bench :( Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b

Re: [PERFORM] pgBench on Windows

Does the one that ships in the installer not work?//Magnusit does work.*putting ashes on my head*Googled around and only found pgbench.c; never looked in program directory. Sorry, my mistake. Harald-- GHUM Harald Massa persuadere et programmareHarald Armin MassaReinsburgstraße 202b70197

Re: [PERFORM] measuring shared memory usage on Windows

Mark, And THAT is exactly the challenge of this thread: I am searching for tools to check shared memory usage on Windows. ipcs is not available. And neither Magnus nor Dave, both main contributors of the win32 port of PostgreSQL, and both way wiser concerning Windows internas then me, know of

Re: [PERFORM] measuring shared memory usage on Windows

Performance readers I follow up my promise:I try my theories :)) and contrary to all wisdom from all PostgreSQL tuning recommendations reconfigured shared memory nearly to theminimum: 1000 for maximum of 400 concurrent connections. (800 would beminimum). Single user performance was fine, now I

[PERFORM] pgBench on Windows

Hello Performancers,has anyone a pgBench tool running on Windows?I want to experiment with various settings to tune; and would prefer using something ready made before coming up with my own misstakes. Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197

[PERFORM] measuring shared memory usage on Windows

the hard way that just rising it can lead to a hard performance loss :) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords. ---(end

Re: [PERFORM] measuring shared memory usage on Windows

Magnus, So: has anybody a hint how I can check how much shared_memory is really used by PostgreSQL on Windows, to fine tune this parameter? I learned the hard way that just rising it can lead to a hard performance loss :)Not really sure :) We're talking about anonymous mapped memory, and Idon't

Re: [PERFORM] measuring shared memory usage on Windows

to access files on disk as memory areas; with the hope of propably better caching then not-memory-mapped files. That would explain my disturbing impressions of performance of PostgreSQL on win32 rising when lowering shared_memory... Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa

[PERFORM] measuring shared memory usage on Windows

:) Thanks for your thoughts, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords. ---(end of broadcast)--- TIP 2: Don't

Re: [PERFORM] measuring shared memory usage on Windows

memory nearly to the minimum: 1000 for maximum of 400 concurrent connections. (800 would be minimum). Single user performance was fine, now I am looking forward to full user scenario tomorrow. I will keep you posted. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa