Postgres Pro
Downloads
Home   >   mailing lists

Re: Lot'sa joins - performance tip-up, please? - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Lot'sa joins - performance tip-up, please?
Date
Msg-id 446C41A9.9080600@logix-tt.com
Whole thread Raw
In response to Re: Lot'sa joins - performance tip-up, please?  (Mario Splivalo <msplival@jagor.srce.hr>)
List pgsql-performance
Tree view 
Hi, Mario,

Mario Splivalo wrote:

> This helps also. I don't get sequential scans any more. I'd like a tip
> on how to set 'enable_nestloop = off' trough JDBC?

statement.execute("SET enable_nestloop TO off"); should do.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: "Olivier Andreotti"
Date:
Subject: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Next
From: Chris Mair
Date:
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle