ion/thread management, something like
> this might show up in production.
>
> - Sumit
>
>
> On 19 June 2012 18:28, Steve Crawford
> wrote:
> > On 06/19/2012 09:29 AM, Mark Rostron wrote:
> >>
> >> hi
> >>
> >> we are running out of databas
hi
we are running out of database connections.
we are using pg 9.0.6 on linux centos 5.7 64bit.
we are not using any go-between connection pools such as pgbouncer or
pgpool - connections occur directly from client to database.
the connection setup on the client (java) is default, only providing
(
hi
I want to install madlib into a postgresql9.1.3 installation.
i am trying to:
a) make python2.7
b) configure postgresql to point at the python2.7 working directory, and
c) install postgresql9.1.3 (using python2.7)
no success to date.
to date my steps have been:
1. configure/make python2.7 (
Hi
We are running a mixture of 8.3 and 8.4 server versions.
We are putting together a historical log of statement patterns of long running
statement output ( via log_min_duration_statement), extracted from csv files in
pg_log.
I would like to take a statement of form, say,
"select columns from m
This post is just to record an example of how to use the new window fn's in 8.4
to perform difference-between-row calculations.
To demonstrate, we create a table with 30 rows of data, two columns, one of
which contains the sequence 1..30, the other contains mod(c1,10).
So the table looks like th
Ok guys - there is something here that I am not seeing Can someone please
set me straight.
I am trying to create a cursor loop with an "update where current of "
statement, but my syntax is wrong.
Would one of you be able to tell me what I'm doing.
Also: adding "for update" to the curs1 curs
