On Tue, 2005-08-16 at 18:53 -0400, Tom Lane wrote:
> Mary Edie Meredith <[EMAIL PROTECTED]> writes:
> > I'm still very concerned about what I'm seeing in the oprofile:
> > namely: .CreateLWLocks is the second highest entry for postgres.
> > http://developer.osdl.org/maryedie/DBT2_PGSQL/59/oprofile.txt
>
> This says there's something wrong with your oprofile setup.
> CreateLWLocks is run *once* at postmaster startup, and it doesn't
> take all that long. Check to see if maybe your executables are
> out of sync with what oprofile is looking at?
Ok, Tom, sounds correct. thanks.
>
> 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
