Re: [PERFORM] CPU load

son is there for quering all that data again and again instead 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

Re: [PERFORM] Less rows -> better performance?

600MB, that 2500MB minus 600MB is some bloat from not vacuuming or bloated indexes. So, before the start of the next semester, at least do vacuum. (maybe also reindex) Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0

Re: [PERFORM] CPU bound at 99%

e request. 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 in Vilnius, Lithuania - Stay tuned! -- Sent via pgsql-performance mailing list (pgsql-performance@postg

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

an have in a table in postgresql 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-performanc

Re: [PERFORM] count * performance issue

is the latest stable version. > > is there any article saying the difference between this 7.3 and 8.4 > > > -- 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

Re: [PERFORM] viewing source code

hb. 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 in Vilnius, Lithuania - Stay tuned!

[PERFORM] URI to kind of a benchmark

"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

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

a not compatible manner... 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 in Vilnius, Lithuania - Stay tuned!

Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

ere 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

a VPN. It took 10-50x the time 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 7043

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

t is doing with cursors. 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

en. I did 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, Lith

Re: [PERFORM] Kernel cache vs shared_buffers

-- 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 keywords. ---(end of broadcast)--- TIP 9: In versions

Re: [PERFORM] Kernel cache vs shared_buffers

mb 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 - P

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

", with usually being a table grown bigger then n records. 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 Reinsburgs

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

a pointy flashy 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 M

Re: [PERFORM] PostgreSQL in virtual machine

ations, smaller 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

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 Stuttgart0

[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 Stu

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

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 o

Re: [PERFORM] measuring shared memory usage on Windows

o all wisdom from all PostgreSQL tuning recommendations reconfigured shared 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 -- G

[PERFORM] measuring shared memory usage on Windows

onour :) 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:

Re: [PERFORM] measuring shared memory usage on Windows

ald 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 6: explain analyze is your friend

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

[PERFORM] measuring shared memory usage on Windows

greSQL on Windows, to fine tune this parameter? I learned 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 on