[PERFORM] What index for 'like (%keyword%)' ???

Hi everyone, I am building a query which uses a clause like "Where doc_description like '%keyword%'". I know a normal index won't be of any use here, but since the table in question will get fairly big, I do want to use an index. Can anyone give me some advise on what kind of index I can use here

[PERFORM] data=writeback

Hi everyone, I have done some reading on filesystems and I thought to optimize the settings for my PostgreSQL system. I use the ext3 filesystem and have the PostgreSQL data and WAL on different physical drives. I made some adjustments to my /etc/fstabd file, so it looks like this : LABEL=/

Re: [PERFORM] data=writeback

> > > > LABEL=/usr/local/pgsql /usr/local/pgsql ext3 > > > > noatime,data=writeback 1 2 > > > > LABEL=/usr/local/pgsql /usr/local/pgsql/wal ext3 > > > > noatime,data=ordered1 2 > > > > > > The same label mounted on two different mount points is probably I > > > typo? > > > > > > No,

Re: [PERFORM] data=writeback

> > LABEL=/usr/local/pgsql /usr/local/pgsql ext3 > > noatime,data=writeback 1 2 > > LABEL=/usr/local/pgsql /usr/local/pgsql/wal ext3 > > noatime,data=ordered1 2 > > The same label mounted on two different mount points is probably I typo? No, the same label mounted on two different mo