Scott you're right, it was a hardware problem.
Thanks for your help.
Nicolas VERGER
> -Message d'origine-
> De : [EMAIL PROTECTED] [mailto:pgsql-hackers-
> [EMAIL PROTECTED]] De la part de scott.marlowe
> Envoyé : mercredi 6 novembre 2002 21:38
> À : Nicolas
nux-gnu, compiled by GCC 2.96
Is it a lock problem? Is there a way to log it?
Thanks for all making such a good job.
Nicolas VERGER
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail co
> my database server has very high load in this morning.
> I've found the problem. One of my index was not used so far!
> it's interesting:
> ...
> addb=> CREATE INDEX banners_b_no_key ON banners (b_no);
> CREATE
> addb=> EXPLAIN SELECT b_link FROM banners WHERE b_no = 3;
> NOTICE: QUERY PLAN:
>
> De : Tom Lane
> Are you sure about that? Postgres supports ISO standard (ISO/IEC 9075,
> SQL 1992) outer joins. Oracle claims to be compliant with that
> standard. If they don't accept the standard syntax for outer joins,
> then their claim of compliance is faulty. But last I heard, they did
> Tom Lane writes :
> Oracle claims to be compliant with that
> standard. If they don't accept the standard syntax for outer joins,
> then their claim of compliance is faulty. But last I heard, they did.
Well, I can't find it into the documentation, and the postgres syntax does
not work so I th
Hello, I'm pretty new to PostgreSQL, (I'm a (young) oracle DBA)
We need to work with Oracle (some heavy client of our society want Oracle
for security or maintenance), but we want to work with PostgreSQL too, cause
it's more performant, less administration, ... in few words : It's the
future
But
