Oops, PostgreSQL 7.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) Yeah I know I need to upgrade to the release version... > -----Original Message----- > From: Sean Chittenden [mailto:sean@chittenden.org] > Sent: Tuesday, March 30, 2004 9:04 PM > To: Mooney, Ryan > Subject: Re: Large DB > > > > However the two indexes are also - large (which may be part of the > > problem, which is why I'm trying just starttime for an > index; They are > > currently in the 140-150G range). > > echo 'SELECT version();' | psql template1 > > What version of PostgreSQL are you using? :) -sc > > -- > Sean Chittenden > > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
