Re: [HACKERS] effective_cache_size less than shared_buffers

2009-02-26 Thread Harald Armin Massa
stem cache" from task manager. shared_buffers (on windows) should be rather small. My real-workload-tests (no benchmarks, real usage of DB-Server) showed that big shared buffers on Windows have a negative effect on PostgreSQL performance. I have found no explanation WHY it is this way. Harald

Re: [HACKERS] pg_upgrade project status

2009-01-27 Thread Harald Armin Massa
everything. Python is present on all Linux, Windows users are totally comfortable with .exe files. 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 Birm

Re: [HACKERS] Cool hack with recursive queries

2008-11-20 Thread Harald Armin Massa
straw to argue against MySQL: "But it cannot do Mandelbrot, so it is not l33t" It's easier then to argue ACID and stuff. -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009

Re: [HACKERS] Block-level CRC checks

2008-10-01 Thread Harald Armin Massa
t;what do after corruption has been detected" 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-hackers mailing

Re: [HACKERS]

2008-06-25 Thread Harald Armin Massa
> of it.What should i do? > thanks > > > Explore the seven wonders of the world Learn more! -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pidgeon - EuroPyth

Re: [HACKERS] Packages in oracle Style

2008-06-01 Thread Harald Armin Massa
g to provide this tarball compiled to a PostgreSQL-8.3.1 usable win32-dll ? ATM I am using session variables in pure PL/SQL via temp tables. ..:) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pidgeon

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-20 Thread Harald Armin Massa
Mark,A model that intended to try and guarantee uniqueness would provide aUUID generation service for the entire host, that was not specific to any application, or database, possibly accessible via the loopbackaddress. It would ensure that at any given time, either the time isnew, or the sequence i

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-18 Thread Harald Armin Massa
> Anyone who thinks UUIDs are guaranteed unique has been drinking too much> of the kool-aid.  > Identifier uniqueness considerations:> This document specifies three algorithms to generate UUIDs: the> first leverages the unique values of 802 MAC addresses to > guarantee uniqueness, t

Re: [HACKERS] [GENERAL] Private email requests

2005-11-24 Thread Harald Armin Massa
Bruce, list, I translated that part to german, I know the source is strong in Germany - maybe it can be a helpfull addition - even if most speak English, they are even more happy to read sth. in German. Harald  Due to time constraints, I do not directly answer general PostgreSQLquestions.  For a