Re: [GENERAL] delete is getting hung when there is a huge data in table

This delete runs in a single transaction. That means the entire transaction has to complete before you will see anything deleted. Interrupting the transaction simply rolls it back, so nothing is deleted. Tom already pointed out the potential foreign key slowdown, another slowdown may simply be

Re: [GENERAL] delete is getting hung when there is a huge data in table

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

[GENERAL] Errors using JDBC batchUpdate with plpgsql function

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

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

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

Re: [GENERAL] Removing and readding bdr nodes

On 1 May 2015 at 12:40, Mathew Moon mathew.m...@vipaar.com 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

[GENERAL] Standby problem after restore_command Implementation

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

Re: [GENERAL] [HACKERS] optimization join on random value

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(

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

On Sun, May 3, 2015 at 2:33 PM, Nanker Phelge n.phelg...@gmail.com 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

Re: [GENERAL] schedulers

2015-05-03 16:55 GMT+02:00 Pavel Stehule pavel.steh...@gmail.com: 2015-05-03 16:40 GMT+02:00 Guillaume Lelarge guilla...@lelarge.info: 2015-05-03 16:10 GMT+02:00 Yves Dorfsman y...@zioup.com: I just want to confirm that currently there is no scheduler that isn't dependent on a crontab

Re: [GENERAL] plpgsql functions organisation

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,

Re: [GENERAL] plpgsql functions organisation

On 03 May 2015, at 2:56, Melvin Davidson melvin6...@gmail.com 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

Re: [GENERAL] schedulers

2015-05-03 16:10 GMT+02:00 Yves Dorfsman y...@zioup.com: 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.

[GENERAL] schedulers

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

Re: [GENERAL] schedulers

2015-05-03 16:40 GMT+02:00 Guillaume Lelarge guilla...@lelarge.info: 2015-05-03 16:10 GMT+02:00 Yves Dorfsman y...@zioup.com: 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

Re: [GENERAL] plpgsql functions organisation

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