Hello, I setup a command to execute psql from TextMate. Psql is the command line utility one can use to send SQL commands to the PostgreSQL database and get the results of the queires sent. It was very easy to setup and get working the problem is that on queries that return relatively large amounts of data the OS as a whole lags and gives the spinning wheel of death during the execution of the command(I had output set to HTML). The test case I used was to execute the command on a query that returns about 140,000 rows with about 4 columns of data so pretty skinny data overall relative to typical database data. Is there any way to make TextMate not consume the machine during the executing of this command. Maybe only show X amount of row instead of all the data? I noticed TextMate was consuming 500+ megs of memory and had around 1.8 gigs of swap. Not sure if those levels were directly related to the query output or not. All I know is TextMate didn't handle that use case very well.
Regards, Bob