[ADMIN] Performance tunning

2003-07-28 Thread Romildo Wildgrube
Hi, According to some postings it looks like there is a recommendation to separate the database files from the transaction logs into separated disk/raid. I was wondering if someone know where the transaction logs are setup and how can I change to point to a new location. Romi

[ADMIN] Partition DB Tables by month

2003-07-28 Thread Romildo Wildgrube
Hi, Is there a way to break the data files by month like in Oracle so that I can easely drop the tables on a monthly basis? Is this something postgres supports or is there a work around solution? Any help will be much appreciated. Romi ---(end of broadcast)

Re: [ADMIN] a question

2003-07-31 Thread Romildo Wildgrube
There are two interfaces that I know of. 1) pgAdmin II is a windows based interface to postgress but they already have a alpha code for pgAdmin III wich will work on unix and other platforms. http://www.pgadmin.org 2) phpPgAdmin which is a web based interface to postgres done in php. Very coo