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!
-
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!
-
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...- sbraaa
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
-
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?- sbraaa
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
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...- sbraaa
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
