I wrote:
> Note, too, that the preferred method isn't likely to depend just on the
> operating system, it's likely to depend also on the filesystem type
> being used.
>
> Linux provides quite a few of them: ext2, ext3, jfs, xfs, and reiserfs,
> and that's just off the top of my head. I imagine th
On Thu, Mar 18, 2004 at 03:39:12PM -0500, Tom Lane wrote:
> Michael Adler <[EMAIL PROTECTED]> writes:
> > In porting an application from v7.2 and v7.3, I noticed that a join on a varchar
> > column and a text column was ignoring indices that were helpful in v7.2. When I
> > explicitly cast the te
Michael Adler <[EMAIL PROTECTED]> writes:
> On Thu, Mar 18, 2004 at 03:39:12PM -0500, Tom Lane wrote:
>> A desultory test didn't show any difference between 7.2.4 and 7.3.6
>> in this respect, however. Perhaps you forgot to ANALYZE yet in the
>> new database?
> I have a test with sample data and