[GENERAL] vacuuuuuuum!!!
hi all. I'm here again. to PostgreSQL DB, I'm using "vacuum" command in a file which is executed at certain time in a day by cron the file is like follows; psql inmsr < delete from "TBL1" where "atime" < 'now'; commit; delete from "TBL2" where "atime" < 'now'; commit; delete from "TBL3" where "atime" < 'now'; commit; vacuum analyze; commit; "delete" commands're done successfully, but when looking up the DB files under /usr/local/pgsql/data/base/ , those tables still have some memories. Also, keys that those tables have seem not to be deleted. Does command "vacuum cannot clean up the keys ?? How can I "vacuum" up the memories?? OR, I might be wrong in a use of "vacuum" command. could you tell me how it actually works? what I want to do with this file is, to clean up the accumlated data from a DB once in a month, so that we can save memory. I do aprreciate for your advise. thank you! hiroko Ogawa [EMAIL PROTECTED]
[GENERAL] Tiiiiiiiiiiiiime
hi all. from a DB table, I'd like to SELECT out the date of 3months before. the command should be => select * from MYTBL where time =XX ; what whould it like to be at X ? I thought that I can use the type of 'today', which is meant to be the 0:00am of the day. or 'current' or things like this. but how can you make it "0:00am of three days ago"? also, if you know about it, I'd like to know about the difference between 'current' and 'now'. thanks about that. hiroko ogawa
[GENERAL] about signals
we are now going to develop a system using PostgreSQL on Linux. this is the first time for us to use PostgreSQL , as well as Linux. many things we would like to ask... this time, the question is about SIGNALS. I know there are some signals used for the interactions between postmaster and backend(DB server). but not the details. for example, think of the case when you make PostgreSQL-included programs used as LIBRARY. if a signal occured at PostgreSQL-process when other apllication is applying to that LIBRARY, does this application catch that signal (from PostgreSQl) in mistake for the one from its child process?? we would be much pleased if you help us about this question. we need more detailed information about how they work. the info about where we can get answers is pleased, too. and this is rather urgent. I do waiting for your reply!!!