Re: would number of fields in a table affect search-query time?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Miles Keaton <mileskeaton(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: would number of fields in a table affect search-query time?
Date: 2004-10-05 02:06:33
Message-ID: 200410041906.33483.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Miles,

> would the number of fields in a table significantly affect the
> search-query time?

Yes.

In addition to the issues mentioned previously, there is the issue of
criteria; an OR query on 8 fields is going to take longer to filter than an
OR query on 2 fields.

Anyway, I think maybe you should tell us more about your database design.
Often the fastest solution involves a more sophisticated approach toward
querying your tables.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Clery 2004-10-05 06:39:23 Re: Comparing user attributes with bitwise operators
Previous Message Steinar H. Gunderson 2004-10-04 23:34:36 Re: would number of fields in a table affect search-query time?