Postgres Pro
Downloads
Home   >   mailing lists

Re: Join query on 1M row table slow - Mailing list pgsql-general

From CSN
Subject Re: Join query on 1M row table slow
Date
Msg-id 20040210212526.78153.qmail@web40611.mail.yahoo.com
Whole thread Raw
In response to Re: Join query on 1M row table slow  (Richard Huxton <dev@archonet.com>)
Responses Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
> 2. Vacuum analyze the tables concerned and post the
> output of EXPLAIN ANALYSE
> with your query.

=> explain analyze;

results in:

ERROR:  syntax error at or near ";" at character 16



__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Duplicate oid and primary key values
Next
From: "scott.marlowe"
Date:
Subject: Re: Join query on 1M row table slow