Re: index with LIKE
От | Henrik Steffen |
---|---|
Тема | Re: index with LIKE |
Дата | |
Msg-id | 02a701c45094$8616a770$9800a8c0@henrik обсуждение исходный текст |
Ответ на | Re: index with LIKE (Martijn van Oosterhout <kleptog@svana.org>) |
Ответы |
Re: postgres .sql files -test database
Re: index with LIKE |
Список | 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@topconcepts.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@svana.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@svana.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. >
В списке pgsql-general по дате отправления: