Re: 8.3 beta problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marek Lewczuk <newsy(at)lewczuk(dot)com>
Cc: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: 8.3 beta problems
Date: 2007-10-16 16:46:11
Message-ID: 19230.1192553171@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marek Lewczuk <newsy(at)lewczuk(dot)com> writes:
>> I'm testing 8.3beta and I think that there is a problem with gist/gin
>> indexes. The performance of 8.3 is very bad comparing to 8.2.

Comparing to 8.2.which-exactly?

I'm wondering if you have an example that doesn't work well with the
gist page-splitting heuristic changes that Teodor put in awhile back.
Those are all in 8.2.5 already, though you might have to REINDEX to
really notice a change if the index was first built with an older
8.2.x release.

Can you provide sample data illustrating the problem?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurent Duperval 2007-10-16 16:46:42 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Stanislav Raskin 2007-10-16 16:38:37 Updating a production database schema from dev server