Josh Berkus wrote:
Mark, Tim,
select
pav1.person_id
from
person_attributes_vertical pav1
where
(pav1.attribute_id = 1
and pav1.value_id in (2,3))
or (pav1.attribute_id = 2
and pav1.value_id in (2,3))
Not the same query, sorry. Daniel's query yields all the person_
in total logical volume, so 4Gb of RAM should be
easily sufficient.
Best Regards, Simon Riggs
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Daniel
> Ceregatti
> Sent: 19 August 2004 19:03
> To: [EMAIL PROTECTED]
> Subject: [PERFORM]
Mark, Tim,
> select
> pav1.person_id
> from
> person_attributes_vertical pav1
> where
> (pav1.attribute_id = 1
> and pav1.value_id in (2,3))
> or (pav1.attribute_id = 2
> and pav1.value_id in (2,3))
Not the same query, sorry. Daniel's query
Hi,
On Aug 25, 2004, at 4:22 AM, Mark Kirkwood wrote:
> select
> pav1.person_id
> from
> person_attributes_vertical pav1
> where
> (pav1.attribute_id = 1
> and pav1.value_id in (2,3))
> or (pav1.attribute_id = 2
> and pav1.value_id in (2,3))
On Aug 25, 2004, at 4:22 AM, Mark Kirkwood wrote:
select
pav1.person_id
from
person_attributes_vertical pav1
where
(pav1.attribute_id = 1
and pav1.value_id in (2,3))
or (pav1.attribute_id = 2
and pav1.value_id in (2,3))
You know..
I
Josh Berkus wrote:
Things we've already tried to avoid going over old ground:
1) increasing statistics;
2) increasing sort_mem (to 256MB, which is overkill)
3) testing on 8.0 beta, which does not affect the issue.
At this point I'm looking for ideas. Suggestions, anyone?
with respect to query
Daniel Ceregatti wrote:
Hi list,
I have a database with 1M "people" in it. Each person has about 20
attributes, such as height, weight, eye color, etc. I need to be able to
search for people based on these attributes. A search can be conducted
on one attribute, all attributes, or any number in betw
Folks,
> I've discussed these attempts with people in #postgresql on
> irc.freenode.net. Agliodbs (I presume you know who this is) was very
> helpful, but in end was at a loss. I find myself in the same postition
> at this time. He suggested I contact this list.
There's a couple of issues here to
Hi list,
I have a database with 1M "people" in it. Each person has about 20
attributes, such as height, weight, eye color, etc. I need to be able to
search for people based on these attributes. A search can be conducted
on one attribute, all attributes, or any number in between. How would
_you_ do