Re: [GENERAL] Re: can't seem to use index
От
admin
Тема
Re: [GENERAL] Re: can't seem to use index
Дата
Msg-id
Pine.BSF.4.10.10001111110270.58707-100000@server.b0x.com
Ответ на
Re: [GENERAL] Re: can't seem to use index (Patrick Welche)
Список
Дерево обсуждения
can't seem to use index admin <admin@wtbwts.com>
Re: [GENERAL] can't seem to use index Patrick Welche <prlw1@newn.cam.ac.uk>
Re: [GENERAL] can't seem to use index Patrick Welche <prlw1@newn.cam.ac.uk>
Re: can't seem to use index admin <admin@wtbwts.com>
Re: [GENERAL] Re: can't seem to use index Frank Mandarino <fam@risca.com>
Re: [GENERAL] Re: can't seem to use index admin <admin@wtbwts.com>
Re: [GENERAL] Re: can't seem to use index Frank Mandarino <fam@risca.com>
Re: [GENERAL] Re: can't seem to use index Patrick Welche <prlw1@newn.cam.ac.uk>
Re: [GENERAL] Re: can't seem to use index admin <admin@wtbwts.com>
Re: [GENERAL] can't seem to use index Aaron Holtz <aholtz@bright.net>
postgres-user <-> unix user "Tomas B. Winkler" <tomasw@cs.huji.ac.il>
Re: postgres-user <-> unix user "Roderick A. Anderson" <raanders@altoplanos.net>
Re: postgres-user <-> unix user Peter Eisentraut <peter_e@gmx.net>
Re: postgres-user <-> unix user "Tomas B. Winkler" <tomasw@cs.huji.ac.il>
Re: postgres-user <-> unix user Peter Eisentraut <peter_e@gmx.net>
Yes, I did try vacuum analyze, but my search query still uses a sequential scan. > > I then tried changing the btree index to a hash talbe and went through the > > same procedure of vacumming and restarting a psql session. Yet again, the > > index wasn't being used. > > But did you try vacuum analyze or just vacuum? >
В списке pgsql-general по дате отправления
