Title: Message
Hi
all,
I've got what
should be a relatively simple join between two tables that is taking forever and
I can't work out why.
Version
7.3.4RH.
It can't be
upgraded because the system is kept in sync with RedHat Enterprise (using
up2date). Not my system otherwise I'd do
: Steven Butler
[mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 6:12
PMTo: Chris Smith;
[EMAIL PROTECTED]Subject: Re: [PERFORM] simple query
join
Looks to me like it's because your assetid is
varchar in one table and an integer in the other table. AFAIK, PG is
unable to use
On 4/1/06, Brendan Duddridge [EMAIL PROTECTED] wrote:
Hi Jim,
I'm not quite sure what you mean by the correlation of category_id?
It means how many distinct values does it have (at least that's my
understanding of it ;) ).
select category_id, count(*) from category_product group by
On 4/2/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Sat, Apr 01, 2006 at 11:23:37AM +1000, chris smith wrote:
On 4/1/06, Brendan Duddridge [EMAIL PROTECTED] wrote:
Hi Jim,
I'm not quite sure what you mean by the correlation of category_id?
It means how many distinct values does
On 4/2/06, chris smith [EMAIL PROTECTED] wrote:
On 4/2/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Sat, Apr 01, 2006 at 11:23:37AM +1000, chris smith wrote:
On 4/1/06, Brendan Duddridge [EMAIL PROTECTED] wrote:
Hi Jim,
I'm not quite sure what you mean by the correlation
On 4/13/06, Gavin Hamill [EMAIL PROTECTED] wrote:
laterooms=# explain analyze select allocation0_.ID as y1_,
allocation0_.RoomID as y2_, allocation0_.StatusID as y4_,
allocation0_.Price as y3_, allocation0_.Number as y5_,
allocation0_.Date as y6_ from Allocation allocation0_ where
On 4/25/06, Arnau [EMAIL PROTECTED] wrote:
Hi all,
I have the following running on postgresql version 7.4.2:
CREATE SEQUENCE agenda_user_group_id_seq
MINVALUE 1
MAXVALUE 9223372036854775807
CYCLE
INCREMENT 1
START 1;
CREATE TABLE AGENDA_USERS_GROUPS
(
AGENDA_USER_GROUP_ID INT8
OK. Stop and think about what you're telling postgresql to do here.
You're telling it to cast the field group_id to int8, then compare it to
9. How can it cast the group_id to int8 without fetching it? That's
right, you're ensuring a seq scan. You need to put the int8 cast on the
other
On 4/29/06, Greg Stumph [EMAIL PROTECTED] wrote:
Well, since I got no response at all to this message, I can only assume that
I've asked the question in an insufficient way, or else that no one has
anything to offer on our problem.
This was my first post to the list, so if there's a better way
On 5/29/06, Anton Maksimenkov [EMAIL PROTECTED] wrote:
Hi.
I have 2 tables - one with calls numbers and another with calls codes.
The structure almost like this:
...
How long does this query take?
SELECT code FROM a_voip_codes c, a_voip v where v.called_station_id
like c.code ||
'%' order by
10 matches
Mail list logo