[PERFORM] go for a script! / ex: PostgreSQL vs. MySQL

Hi guys, I followed the discussion and here are my 0.2$: I think instead of thinking about where to put the information about tuning, someone should provide a "pgsql-autotune". Maybe even a shell script would do the trick. It's not so hard to find out, how much memory is installed, and IMHO SHAR

Re: [PERFORM] Is there a reason _not_ to vacuum continuously?

>> > It's part of postgresql 7.3. Just get it from the 7.3 >> > contrib dir - it works fine with 7.2 >> That's nice to hear. Thanx for that info. > That's alright - cron job it for once a month - that's what > I do. Basically the problem is that in certain cases > (monotonically increasing seria

Re: [PERFORM] Is there a reason _not_ to vacuum continuously?

> Yes, there is reindexdb :) Not on my machine. (RH 7.3) #rpm -qa|grep postgres postgresql-server-7.2.3-5.73 postgresql-libs-7.2.3-5.73 postgresql-devel-7.2.3-5.73 postgresql-7.2.3-5.73 What package am I missing? regards, Oliver Scheit ---(end of broadc

Re: [PERFORM] Is there a reason _not_ to vacuum continuously?

ere's vacuumdb, but is there somehting similar like reindexdb ? regards, Oliver Scheit ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [PERFORM] Sanity check requested

>> > Be sure to mount noatime >> >> I did "chattr -R +A /var/lib/pgsql/data" >> that should do the trick as well or am I wrong? >> > > According to the man page it gives the same effect. > There are a few things you should consider though: > - new files won't be created with the same options (I

Re: [PERFORM] Sanity check requested

> Be sure to mount noatime I did "chattr -R +A /var/lib/pgsql/data" that should do the trick as well or am I wrong? regards, Oli ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]