Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Melton Low
Resending. Hit the send button too soon. Use apt-get to install sudo apt-get install libreadline-dev sudo apt-get install zlib1g-dev and other dependencies mentioned in the source distribution INSTALL file. ln -s /usr/bin/make /usr/bin/gmake This will give you gmake which would already be in

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Melton Low
Use apt-get to install sudo apt-get install libreadline-dev and zlib1g-dev. Then do a symbolic link for make to gmake. On Sun, Feb 27, 2011 at 11:39 PM, Selva manickaraja wrote: > Yes, true now it looks like pg-general. I started out this discussion > because I couldn't get Performance Testin

Re: [PERFORM] Finding rows in table T1 that DO NOT MATCH any row in table T2

2009-10-20 Thread Melton Low
How about DELETE FROM T1 WHERE T1.PK IN (SELECT T1.PK FROM T1 EXCEPT SELECT T2.FK FROM T2); Mel On Tue, Oct 20, 2009 at 7:59 AM, Tom Lane wrote: > Shaul Dar writes: > > I assume this will work but will take a long time: > > > DELETE * FROM T1 where T1.PK NOT IN > > (SELECT T1.PK FROM T1, T2 wh

Re: [PERFORM] table full scan or index full scan?

2009-10-17 Thread Melton Low
I don't know if this will help. In my days with Oracle and Sybase, it use to work for both. Just give PG a hint like this select count(*) from test where id > 0; You can try it while you wait for other on the list with more knowledge for a different idea. Mel On Sun, Oct 11, 2009 at 4:26 AM,