I am running a PostgreSQL 7.1.3 on a Intel Pentium III
My operating system is SuSE Linux 7.1 with Kernel 2.4.4 (ELF)
I compiled postgresql with gcc 2.95.2
My problem:
when using "vacuum analyze " on very large tables (I have one
with about 30GB) the memory usage increases continues until no memo
Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> I am aware of the performance drawbacks because of indices and
> triggers. In fact I have a trigger and an index on the most populated
> table. It is not possible in my case to remove the primary keys
> during insert, because the database structure
I am aware of the performance drawbacks because of indices and triggers. In fact I
have a trigger and an index on the most populated table.
It is not possible in my case to remove the primary keys during insert, because the
database structure and foreign keys validate my data during import.
Th
Left/Outer joins are supported, but not until version 7.1. Most Linux
distros are shipping still with 7.0.3. Upgrade. Your problem will be
fixed.
__
Your mouse has moved.
You must rest
Are you running version 7.1 or higher?
On Tue, Aug 21, 2001 at 09:25:58AM -0400,
[EMAIL PROTECTED] wrote:
> Martijn Beelen ([EMAIL PROTECTED]) reports a bug with a severity of 2
>
> Long Description
> When using left join, I get the errormessage
> "ERROR: OUTER JOIN is not yet supported"
[EMAIL PROTECTED] writes:
> When using left join, I get the errormessage
> "ERROR: OUTER JOIN is not yet supported"
Try a more recent release.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list arc
Martijn Beelen ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Left Join/Outer Join
Long Description
When using left join, I get the errormessage
"ERROR: OUTER JOIN is not yet supported"
I hope left-joins are supported, if not
