Re: index with LIKE

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "'Martijn van Oosterhout'" <kleptog(at)svana(dot)org>
Cc: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: index with LIKE
Date: 2004-06-12 15:47:10
Message-ID: 02a701c45094$8616a770$9800a8c0@henrik
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


hello,

I ran vacuum analyze on all 3 servers,
and all servers show the same encoding: SQL_ASCII

any other idea?

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.de Tel. +49 1805 9977 501*
mail: steffen(at)topconcepts(dot)de Fax. +49 1805 9977 502*
--------------------------------------------------------
SMS Versand ab 9.9 Cent: http://sms-gw.topconcepts.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------
*) EUR 0,12/Min. (CNS24)

> -----Ursprüngliche Nachricht-----
> Von: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
> Gesendet: Mittwoch, 9. Juni 2004 22:10
> An: Henrik Steffen
> Cc: pgsql
> Betreff: Re: [GENERAL] index with LIKE
>
>
> On Wed, Jun 09, 2004 at 09:00:31AM +0200, Henrik Steffen wrote:
> >
> > hello all,
> >
> > on my master-db-server i'm running postgres 7.4.1,
> > and I have got two slave-servers running postgres 7.4.2
>
> <snip>
>
> > Is there such a difference in 7.4.1 to 7.4.2 ?
> >
> > A retardation of 722 ms is not acceptable for me, and I
> don't see why
> > the indexes are not used.
> > Do you have an idea? I have run VACUUM ANALYZE several times, and
> > REINDEX TABLE foo and even
> > DROPped and reCREATEd the index. Didn't help.
>
> The classic issue is what encoding are the databases. Anything other
> than C and like won't use indexes.
>
> Also, you did a vacuum analyze on both, right?
>
>
> Hope this helps,
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> http://svana.org/kleptog/
> > Patent. n. Genius is 5%
> inspiration and 95% perspiration. A patent is a
> > tool for doing 5% of the work and then sitting around
> waiting for someone
> > else to do the other 95% so you can sue them.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message S Peri 2004-06-12 16:43:37 Re: postgres .sql files -test database
Previous Message Jim Seymour 2004-06-12 11:19:05 Re: Opteron scaling with PostgreSQL