Re: [PERFORM] 8rc2 BLCKSZ

2004-12-22 Thread Tom Lane
Vivek Khera khera@kcilink.com writes: One of the suggestions handed to me a long time ago for speeding up PG on FreeBSD was to double the default blocksize in PG. I tried it, but found not a significant enough speed up to make it worth the trouble to remember to patch every version of Pg

Re: [PERFORM] Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE

2004-12-22 Thread Tom Lane
Pailloncy Jean-Gerard [EMAIL PROTECTED] writes: I think I have a test case for 7.4.2 Can you send me the test data (off-list)? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] Why so much time difference with a same query/plan?

2004-12-22 Thread Yann Michel
Hi, On Wed, Dec 22, 2004 at 01:52:40PM -0800, Litao Wu wrote: Does the order of columns in the index matter since more than 50% customer_id = 158? I think it does not in Oracle. Will the performance be better if I change index xxx_idx to (domain, customer_id, created)? Well, in Oracle