[GENERAL] Multiple column indexes

2007-01-19 Thread Garth Keesler
the potential performance gains? Thanx, Garth ---(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

Re: [GENERAL] Multiple column indexes

2007-01-19 Thread Garth Keesler
I thought as much. Thanx for the reply, Garth Merlin Moncure wrote: On 1/19/07, Garth Keesler [EMAIL PROTECTED] wrote: I have a primary key made up of two varchar(128) columns, typically less than 16 chars each. Concatenating the two columns would still be unique. Would it make sense

Re: [GENERAL] Handling of large objects in DBD::Pg? (fwd)

2001-02-23 Thread garth
Attached are large object read and write functions I wrote based on information I gleened from the DBD::Pg install test script. They read and write to buffers rather than files because my information wasn't comming from a file and wasn't going to one. However if you need the data to go