[ADMIN] Re: 7.1 ... wtf?

Hi, hmm I don't know if I'm right but I think when I run the postmaster with default values configured it should run at least in a acceptable manner. But it does not. Also it does not respond to any minor tweaks like increasing wal-buffers, wal-files, sort-mem, etc. ... Its just doing his weird

[ADMIN] 7.1 ... wtf?

Hi again, sometime ago i had a post on 7.1 performance .. this is still up-to-date cause the performance is bad like hell but i have a little bit bigger problem now. I have a dual p3-1ghz + 1gig ram. The hardware is new (asus dual board + registered ecc sdram) and is quite nice but postgres7.1

[ADMIN] Re: Re: 7.1 performance

Hi, Two things you should check. 1) Are you using persistent connections in your PHP scripts? not that good for 250+ apache httpd sessions running (only serving php ... images/static content is balanced to another server). ;) definitly no. 2) Are you certain your queries are utilizing the

[ADMIN] Re: 7.1 performance

Hi, i use the same settings for sort_mem, buffers, etc. just no fsync. I thought 7.1 wouldn't need that anymore. Does the behavior change if you turn off fsync again? No. The Database is loaded with up to 25req/s ... most of them are just simple SELECTS (no ORDER BY, no JOINS) ... i

[ADMIN] 7.1 performance

Hi there, i just upgraded my database system from 7.0.3 to 7.1 ... i did a dumpall and psql -f dump.sql to the new db. the data is in place correctly and its running fine. but as soon as i put the connections back on to the db the load raised to 6. prior to the upgrade the system load was an 0.3

[ADMIN] FATAL 1: Memory exhausted in AllocSetAlloc()

Hi there! The last db-crash (kernel panic) caused a little error on my db-files i think. After the crash i had to recreate some indexes but no data were lost. Everything is running quite ok now, except for one BIG error. The postgres process crashes every now and then without giving any

[ADMIN] postgres getting bigger and bigger ...

Hi there! I just wondered if it is normal that a running postmaster is getting bigger and bigger the more time it runs. I have configured by postmaster to accept a maximum of 64 sessions. When I start it each session is about 1,5 - 3mb of RAM. After 3-4 days each process is about 140mb of RAM

Re: [ADMIN] Lack of Performance

Hi again! -B 256 -i -N 48 -o '-F -S 512' I have a gig of ram and use: -B 32768 -o "-F -S 65534" Hmmm, during peak time these values have no influence to perfomance at all. :( The values help to decrease the load during "not-so-busy" times, but during peak times the load is still