Re: [PERFORM] [HACKERS] fsync method checking

2004-03-19 Thread Kevin Brown
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

Re: [PERFORM] string casting for index usage

2004-03-19 Thread Michael Adler
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

Re: [PERFORM] string casting for index usage

2004-03-19 Thread Tom Lane
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