Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sbraaa
  • Content: Threads
  • Order by date
  1. sbraaa

    Memory problems with vacuum!!!

    I've notice that when vacuumdb runs nightly it uses all the available memory but when process ends it doesn't release the memory so next processes had to swap on disk. My statement is: vacuumdb --analyze dbname when i first boot up the linux box, this is the situation provided by TOP: 11:59am...
  2. sbraaa

    question about SQL statement from a beginner

    Hi, my question is: update table set field1 = 0; update table set field2 = 0; update table set field3 = 0; update table set field4 = 0; or update table set field1=0, set field2=0, set field3=0, set field4=0 which is the fastest?
  3. sbraaa

    monitoring postgresql query

    I'm using postgresql 6.5.3 and i need to monitoring querys executed by user but i don't know who. I try to enable log files at postmaster startup but the information write to log file aren't that useful... (i could get this infos just using 'top' or 'ps -ef | grep postmaster'). So i had...

Part and Inventory Search

Back
Top