On Mon, May 18, 2015 at 9:44 PM, Sachin Srivastava
wrote:
> Hi,
>
>
>
> I have done below changes in my postgresql.conf.
>
>
>
> *Checkpoint_segments= 200*
>
> and
>
> *checkpoint_timeout= 5min*
>
>
>
> I am also doing archiving and below changes in my postgresql.conf.
>
>
>
> *Wal_level=archive*
On Wed, May 20, 2015 at 8:47 AM, Ravi Krishna wrote:
> Essentially in one single sql call, we can do
> -- Add new rows
> -- Update a set of rows where each row is identified by a bookmark
> -- Delete a set of rows where each row is identified by a bookmark
> -- Fetch a set of rows where each row i
On 05/19/2015 05:27 PM, Ravi Krishna wrote:
Not sure whether I am understanding this. I checked embedded C and did
not find any section which describes what I have asked, that is the
ability to do multiple inserts, or updates or deletes in one sql call.
For example, if my application does the fo
Not sure whether I am understanding this. I checked embedded C and did not find any section which describes what I have asked, that is the ability to do multiple inserts, or updates or deletes in one sql call. For example, if my application does the following
BEGIN TRANSACTION
INSERT INTO TABL
On 05/19/2015 04:47 PM, Ravi Krishna wrote:
To explain pls refer to this for DB2
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html
Essentially in one single sql call, we can do
-- Add new rows
-- Update a set of rows where each row is i
To explain pls refer to this for DB2
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html
Essentially in one single sql call, we can do
-- Add new rows
-- Update a set of rows where each row is identified by a bookmark
-- Delete a set of rows
Maxim Boguk schrieb am 19.05.2015 um 13:33:
> Hello all,
>
> I just noticed that you can do something like this (using 9.4.1):
>
>select array[1,2,3] - 3
>
> which is doing the same thing as:
>
>select array_remove(array[1,2,3],3)
>
> but the minus is not docume
On Tue, May 19, 2015 at 7:39 PM, Thomas Kellerer wrote:
> Hello all,
>
> I just noticed that you can do something like this (using 9.4.1):
>
>select array[1,2,3] - 3
>
> which is doing the same thing as:
>
>select array_remove(array[1,2,3],3)
>
> but the minus is not documented as an arra
Thomas Kellerer wrote:
> I just noticed that you can do something like this (using 9.4.1):
>
>select array[1,2,3] - 3
>
> which is doing the same thing as:
>
>select array_remove(array[1,2,3],3)
I can't reproduce this on my PostgreSQL 9.4.1:
test=> select array[1,2,3] - 3;
ERROR: oper
Hello all,
I just noticed that you can do something like this (using 9.4.1):
select array[1,2,3] - 3
which is doing the same thing as:
select array_remove(array[1,2,3],3)
but the minus is not documented as an array operator:
http://www.postgresql.org/docs/current/static/functions-array.
François Battail writes:
> My bad, got it. May be interesting but as I have a lot of indexes it
> will be hard to test and to choose the best candidate. No idea of how
> it can affect EWKB data indexed by a GiST (PostGIS) index, but it's
> something to try just to know.
You could also raise the
11 matches
Mail list logo
