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]

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 think), so

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

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] 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 broadcast

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 serial indexes)

[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