Re: [PERFORM] For full text indexing, which is better, tsearch2 or

On Fri, Nov 28, 2003 at 01:18:48PM +0800, Christopher Kings-Lynne wrote: > > >Any thoughts? > > Actually, I ran my tests using tsearch V1. I wonder if there has been > some weird regression between tsearch 1 and 2? Maybe. tsearch2 doesn't seem production ready in other respects (untsearch2.sql

Re: [PERFORM] Maximum Possible Insert Performance?

On Mon, 2003-11-24 at 19:16, Greg Stark wrote: > William Yu <[EMAIL PROTECTED]> writes: > > > > You're right, though, mirroring a solid state drive is pretty pointless; if > > > power fails, both mirrors are dead. > > > > Actually no. Solid state memory is non-volatile. They retain data even with

Re: [PERFORM] simple left join slows query more than expected

Jonathan Knopp <[EMAIL PROTECTED]> writes: > I'v spent a couple days playing with this problem and searching the mailing lists and > docs etc but come up with nothing. Any help would be much appreciated. Don't use inheritance to define the contacts table. regards, tom lane