I have a question related to this issue:
Now that the locale has changed, it seems that the planner no longer
wants to use the indexes for running LIKE queries on varchar columns
unless I specify varchar_pattern_ops when creating the index. And if I
create the index with varchar_pattern_ops, then
Seems that the optimizer should catch this...
C
-Original Message-
From: Craig Ringer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 01:20
To: Christopher Condit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] initdb in 8.3
Christopher Condit wrote:
> I have a qu
I have two tables that are georeferenced (although in this case I'm not using
PostGIS) that I need to join.
A ( lat | lon | depth | value)
|A| = 1,100,000
B ( lat | lon | attributes)
|B| = 14,000,000
A is a special case because the lat / lon values are all at half degree
intervals (ie 33.5, -12
> > I have two tables that are georeferenced (although in this case I'm
> not using PostGIS) that I need to join.
> > A ( lat | lon | depth | value)
> > |A| = 1,100,000
> >
> > B ( lat | lon | attributes)
> > |B| = 14,000,000
> >
> > A is a special case because the lat / lon values are all at half
> > > > I have two tables that are georeferenced (although in this case
> I'm
> > > not using PostGIS) that I need to join.
> > > > A ( lat | lon | depth | value)
> > > > |A| = 1,100,000
> > > >
> > > > B ( lat | lon | attributes)
> > > > |B| = 14,000,000
> > > >
> > > > A is a special case because
Hi Alban-
> > I have two tables that are georeferenced (although in this case I'm
> > not using PostGIS) that I need to join.
> > A ( lat | lon | depth | value)
> > |A| = 1,100,000
> >
> > B ( lat | lon | attributes)
> > |B| = 14,000,000
> >
> > A is a special case because the lat / lon values are
Hi All-
I'm new to Postgres and have a question about bulk loading from streams.
I know that I can bulk load from a file using COPY. Is it possible to
use a stream instead of a file? If so, and I limited to stdin? I'm
attempting to stream data from a remote database into my Postgres
instance. I
?
From: Josh Rovero
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 4:34
PM
To: Christopher Condit;
pgsql-general
Subject: Re: [GENERAL] pgsql and
streams
Chris Condit wrote:
I'm new to Postgres and have a question about bulk loading
from streams.
I know that
the server? Using psql I
can stream data after the call. Is there anyway to accomplish the same
thing with JDBC?
Thanks!
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher
Condit
Sent: Tuesday, March 14, 2006 4:10 PM
To: pgsql-general
Subjec
Sent: Thursday, March 30, 2006 1:07 AM
To: Christopher Condit
Cc: pgsql-general
Subject: Re: [GENERAL] pgsql and streams
Christopher Condit schrieb:
> Back to this thread - I realize that in the "COPY TO" documentation,
it
> states the CSV file used for loading must be on the
Tino Wildenhain [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006 1:07 AM
To: Christopher Condit
Cc: pgsql-general
Subject: Re: [GENERAL] pgsql and streams
Christopher Condit schrieb:
> Back to this thread - I realize that in the "COPY TO" documentation,
it
> states the CSV file
11 matches
Mail list logo
