Em 07/10/2012 02:46, Andreas Kretschmer escreveu:
Edson Richter wrote:
Dear friends,
I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
64 and Linux 64.
Trying to use setQueryTimeout(int), I get the following stack trace:
Internal Exception: org.postgresql.util.PSQLExcepti
Edson Richter wrote:
> Dear friends,
>
> I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
> 64 and Linux 64.
> Trying to use setQueryTimeout(int), I get the following stack trace:
> Internal Exception: org.postgresql.util.PSQLException: Method
> org.postgresql.jdbc4.Jdbc
Dear friends,
I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
64 and Linux 64.
Trying to use setQueryTimeout(int), I get the following stack trace:
Internal Exception: org.postgresql.util.PSQLException: Method
org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(i
"Philip Hallstrom" <[EMAIL PROTECTED]> writes:
> I'm trying to add functional index support to Rails' Active Record and
> am getting stuck when it comes to a method Rails has to print out the
> indexes associated with a given table.
> The SQL being run is below:
> SELECT distinct i.relname, d.ind
Hi all -
I'm trying to add functional index support to Rails' Active Record and
am getting stuck when it comes to a method Rails has to print out the
indexes associated with a given table.
The SQL being run is below:
SELECT distinct i.relname, d.indisunique, a.attname
FROM pg_class t, pg_class i
marcelo Cortez <[EMAIL PROTECTED]> writes:
> I am confused ,
> way planer it does not use the partial index?
> query:
> SELECT cliente_base.* FROM cliente_base
> WHERE (cliente_base.inst_class_ = 'Cliente' ) ORDER
> BY cliente_base.nombre ASC
Because it thinks the seqscan is cheaper.
Folks
I am confused ,
way planer it does not use the partial index?
any help be appreciated
pd: sorry for my english.
data:
table definition:
-- Table: cliente_base
CREATE TABLE cliente_base
(
id_ integer NOT NULL,
activo boolean,
numero integer,
categ character vary
Folks
I am confused ,
way planer it does not use the partial index?
query:
SELECT cliente_base.* FROM cliente_base
WHERE (cliente_base.inst_class_ = 'Cliente' ) ORDER
BY cliente_base.nombre ASC
plan:
QUERY PLAN
Quoting Richard Huxton <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
> >
> > I have a table with with 1 million records in it. Here is the definition
> >
> > CREATE TABLE report
> > (
> > match int4,
> > action varchar(16),
> > stamp timestamptz,
> > account varchar(32),
> > ipaddress
Keith C. Perry wrote:
I have a table with with 1 million records in it. Here is the definition
CREATE TABLE report
(
match int4,
action varchar(16),
stamp timestamptz,
account varchar(32),
ipaddress inet,
profile varchar(16),
rating text,
url text
)
WITHOUT OIDS;
The is one index
Ok, I've tried a number of things here and I know I'm missing something but at
this point my head is spinning (i.e. lack of sleep, too much coffee, etc...)
My environment is PG 7.4.3 on Linux with 512Mb of ram and swap. This was just
upgraded from 7.4 (just to make sure I'm current). Some of my
On Thursday 12 February 2004 19:32, Jason Tesser wrote:
> Hi
>
> > Is there an index on:
> > testclass.classid
> I created the indexes and it speed up a little. Still a little slower
> than Access though. Which I think should not be. The testclass is a view
> not A query so I cannot make an ind
On Thu, 12 Feb 2004, Jason Tesser wrote:
> Hi
>
> > > I have the below query written. I have removed a lot from the
> select
> > > Statement for simplicity sake. The query takes way too long.
> > > I am moving from an Access backend to a Postgres back with
> > > Access in the front. The below
> -Original Message-
> From: Jason Tesser [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 12, 2004 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] help with query speed
>
>
> I have the below query written. I have removed a lot from the select
&g
> You didn't answer my question about whether they are the same types.
Are
> they?
Yes but testclass is a view. But the field it is referencing is of the
same type.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map set
On Thu, 12 Feb 2004, Jason Tesser wrote:
> I have the below query written. I have removed a lot from the select
> Statement for simplicity sake. The query takes way too long.
> I am moving from an Access backend to a Postgres back with
> Access in the front. The below query is taking like 14-20
Hi
> > I have the below query written. I have removed a lot from the
select
> > Statement for simplicity sake. The query takes way too long.
> > I am moving from an Access backend to a Postgres back with
> > Access in the front. The below query is taking like 14-20 seconds.
> > Is their a bette
I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20 seconds.
Is their a better way I can write the j
-- Forwarded message --
Date: Fri, 5 Nov 1999 09:35:25 -0400 (VET)
From: Vegeta <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Help with query
Dear list members:
I am new to the list and to SQL. I am using PostgreSQL 6.4.2 on Linux and
want to do the following query:
Give
19 matches
Mail list logo