Sure thing ... I turned on VERBOSE so I'll let it run for the next few days (the weekend is kind of a bad time since activity on the database is low) but by monday or tuesday I should have a few nightly runs to post to the list .. Thanks, Dave > -----Original Message----- > From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] > Sent: Friday, July 08, 2005 9:52 AM > > "David Esposito" <pgsql-general@xxxxxxxxxxxxxxxxxxxxx> writes: > > Hmm, how are you getting 1/6? The ballpark seems to be > about 50% or more for > > those first 4 ... > > Ooops, I got confused about which column was which. > > Could we see the results of "vacuum verbose" on this table? Even > better, verbose output from two successive nightly runs? > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
