On Sun, May 3, 2015 at 2:33 PM, Nanker Phelge wrote:
> inner ex 2 =A result was returned when none was expected.
>
>
I don't know what is or is not allowed by JDBC but it is reasonable to
assume that you cannot create batches of SELECT statements. The intent of
batching is to repeatedly execute
On 5/3/15 4:15 PM, Anton wrote:
Hello guru of postgres, it's possoble to tune query with join on random
string ?
i know that it is not real life example, but i need it for tests.
Moving to -general, which is the proper list for this. (BCC -hackers)
> soe-# WHERE customer_id = trunc( r
On 1 May 2015 at 12:40, Mathew Moon wrote:
> Hi,
>
> I have a group of 5 bdr nodes and before we can move to production with
> them we must demonstrate that we can remove a node from the group and add
> that node back later. When I remove a node it stays in the bdr.bdr_nodes
> view with status 'k
Hello,
I'm having trouble on Standby after the implementation of the
restore_command.
I performed all the settings and it worked normally and after restart
the slave server, started to generate errors in the log of the slave:
I'm using Debian 8 with PostgreSQL 9.4.1 on x86_64-unknown-linux-gn
On 05/03/2015 02:33 PM, Nanker Phelge wrote:
I am attempting to setup a Spring Batch ItemWriter to call a function in
PostgreSQL to insert the provided objects. I posted the details to
stackoverflow a month ago
(http://stackoverflow.com/questions/28971220/spring-batch-itemwriter-error-with-postg
I am attempting to setup a Spring Batch ItemWriter to call a function in
PostgreSQL to insert the provided objects. I posted the details to
stackoverflow a month ago (
http://stackoverflow.com/questions/28971220/spring-batch-itemwriter-error-with-postgresql-function)
with no answers, and I just fo
On 05/03/2015 07:14 AM, Melvin Davidson wrote:
The point was to show that yes, function calls take time, and using sub
functions take even more time. I am not about to write an additional
more detailed example just to show the same results. If you are in
doubt, I respectfully suggest you do your
2015-05-03 16:55 GMT+02:00 Pavel Stehule :
>
>
> 2015-05-03 16:40 GMT+02:00 Guillaume Lelarge :
>
>> 2015-05-03 16:10 GMT+02:00 Yves Dorfsman :
>>
>>>
>>> I just want to confirm that currently there is no scheduler that isn't
>>> dependent on a crontab (like PgAgent), that could be run entirely fr
2015-05-03 16:40 GMT+02:00 Guillaume Lelarge :
> 2015-05-03 16:10 GMT+02:00 Yves Dorfsman :
>
>>
>> I just want to confirm that currently there is no scheduler that isn't
>> dependent on a crontab (like PgAgent), that could be run entirely from
>> within
>> PostgreSQL only.
>>
>> Anybody knows of
2015-05-03 16:10 GMT+02:00 Yves Dorfsman :
>
> I just want to confirm that currently there is no scheduler that isn't
> dependent on a crontab (like PgAgent), that could be run entirely from
> within
> PostgreSQL only.
>
> Anybody knows of one?
>
>
There's none.
--
Guillaume.
http://blog.guil
The point was to show that yes, function calls take time, and using sub
functions take even more time. I am not about to write an additional more
detailed example just to show the same results. If you are in doubt, I
respectfully suggest you do your own testing.
On Sun, May 3, 2015 at 5:26 AM, Alb
I just want to confirm that currently there is no scheduler that isn't
dependent on a crontab (like PgAgent), that could be run entirely from within
PostgreSQL only.
Anybody knows of one?
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@post
> On 03 May 2015, at 2:56, Melvin Davidson wrote:
>
> OK, Here is a simple example that shows the difference between using a self
> contained function and
> one that calls sub functions.
>
> After loading all the functions below, repeat each of the EXPLAIN statements
> a few times and note
> Now issue is that when this script for the deletion of data is
launched , it is taking more than 7 days and doing nothing i.e not a
single row has been deleted.
Deleting a large number of rows can take a long time. Often it's
quicker to delete smaller chunks. The LIMIT clause is not suppor
14 matches
Mail list logo
