Re: [PERFORM] Guidelines on best indexing strategy for varying searches on 20+ columns

Thanks for the answers. > Den 30/06/2014 kl. 20.04 skrev Jeff Janes : > > On Wed, Jun 25, 2014 at 1:48 AM, Niels Kristian Schjødt > wrote: >> Hi, >> I’m running a search engine for cars. It’s backed by a postgresql 9.3 >> installation. >> >> Now I’m unsure about the best approach/strategy on d

Re: [PERFORM] Guidelines on best indexing strategy for varying searches on 20+ columns

On Wed, Jun 25, 2014 at 1:48 AM, Niels Kristian Schjødt wrote: > Hi, > I’m running a search engine for cars. It’s backed by a postgresql 9.3 > installation. > > Now I’m unsure about the best approach/strategy on doing index optimization > for the fronted search. > > The problem: > > The table co

Re: [PERFORM] Guidelines on best indexing strategy for varying searches on 20+ columns

Thanks for your suggestions, very useful. See comments inline: Den 25/06/2014 kl. 23.48 skrev Merlin Moncure : > On Wed, Jun 25, 2014 at 3:48 AM, Niels Kristian Schjødt > wrote: >> Hi, >> I’m running a search engine for cars. It’s backed by a postgresql 9.3 >> installation. >> >> Now I’m unsur

Re: [PERFORM] Guidelines on best indexing strategy for varying searches on 20+ columns

On Wed, Jun 25, 2014 at 3:48 AM, Niels Kristian Schjødt wrote: > Hi, > I’m running a search engine for cars. It’s backed by a postgresql 9.3 > installation. > > Now I’m unsure about the best approach/strategy on doing index optimization > for the fronted search. > > The problem: > > The table co

[PERFORM] Guidelines on best indexing strategy for varying searches on 20+ columns

Hi, I’m running a search engine for cars. It’s backed by a postgresql 9.3 installation. Now I’m unsure about the best approach/strategy on doing index optimization for the fronted search. The problem: The table containing the cars holds a around 1,5 million rows. People that searches for car