| From: | Satyajeet Seth <csa98016(at)cse(dot)iitd(dot)ernet(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Except operation |
| Date: | 1999-12-01 18:51:34 |
| Message-ID: | Pine.LNX.4.10.9912020021060.3476-100000@vibhas.cse.iitd.ernet.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
The query:
select * from webdata except select * from webdata1;
takes abysmally long .How can I optimise it?
The particulars are:
tracedb=> \d webdata
Table = webdata
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| tid | int4 |
4 |
| itemid | int4 |
4 |
| ordering | int4 |
4 |
+----------------------------------+----------------------------------+-------+
tracedb=> \d webdata1
Table = webdata1
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| tid | int4 |
4 |
| itemid | int4 |
4 |
| ordering | int4 |
4 |
+----------------------------------+----------------------------------+-------+
tracedb=> select count(*) from webdata;
count
-----
91155
(1 row)
tracedb=> select count(*) from webdata1;
count
-----
9550
(1 row)
Regards
Satya
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-12-01 19:50:25 | Re: [GENERAL] Date & Time |
| Previous Message | kaiq | 1999-12-01 16:13:36 | book's pdf link |