Will get what you asked for ASAP. Thanks for your time.
--
Aaron
On June 25, 2014 5:55:29 PM EDT, Shaun Thomas wrote:
>On 06/25/2014 04:40 PM, Aaron Weber wrote:
>
>> In the meantime, I guess I wasn't clear about some other particulars
>> The query's where clause is only an "IN", with a list of
On 06/25/2014 04:40 PM, Aaron Weber wrote:
In the meantime, I guess I wasn't clear about some other particulars
The query's where clause is only an "IN", with a list of id's (those
I mentioned are the PK), and the join is explicitly on the PK (so,
indexed).
Indexed doesn't mean indexed if the
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
I will gather the other data tonight. Thank you.
In the meantime, I guess I wasn't clear about some other particulars
The query's where clause is only an "IN", with a list of id's (those I
mentioned are the PK), and the join is explicitly on the PK (so, indexed).
Thus, there should be only th
On 06/25/2014 03:10 PM, AJ Weber wrote:
I have a relatively sizable postgresql 9.0.2 DB with a few large tables
(keep in mind "large" is relative, I'm sure there are plenty larger out
there).
Regardless of any help we might offer regarding this, you need to
upgrade your installation to 9.0.17
Sorry for the semi-newbie question...
I have a relatively sizable postgresql 9.0.2 DB with a few large tables
(keep in mind "large" is relative, I'm sure there are plenty larger out
there).
One of my queries that seems to be bogging-down performance is a join
between two tables on each of th
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
