[GENERAL] free space?

2006-12-15 Thread Greg Mitchell
Is there a way to see how free space is distributed across tables after running vacuum (without looking through the verbose output)? Thanks, Greg Automated Trading Desk, LLC (ATD) is the sole owner of Automated Trading Desk Brokerage Services, LLC (ATDB) and Automated Trading Desk Financial Ser

Re: [GENERAL] can this be done in one SQL selcet statement?!

2006-12-08 Thread Greg Mitchell
First, I think the table design is probably not the best way to do this. In the relational database world, Table 2 probably should look like this: NODE1 NODE2 NODE1 NODE3 NODE2 NODE4 NODE2 NODE3 Then you could do: INSERT INTO table1 SELECT DISTINCT column2 FROM table2 WHERE column2 NO