On Mon, May 04, 2015 at 12:15:54AM +0300, 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.
>
> soe=# explain
> soe-# SELECT ADDRESS_ID,
> soe-# CUSTOMER_ID,
> soe-#
Yahooo !
Many thanks !
soe=# explain EXECUTE test( random()*45000 );
QUERY PLAN
-
Index Scan using addresses_cust_ix on addresses (cost=0.43..16.48
rows=3 width=84)
Inde
Hi,
> String sql = "select test_user_result_insert_func(?, ?, ?);";
You can't call functions via JDBC like that. You need to use:
CallableStatement cs = connection.prepareCall("{call func(?,?,?)}");
// Loop starts...
cs.clearParameters();
cs.setString(1, "foo");
cs.setString(2, "bar"
Hannes Erven schrieb am 04.05.2015 um 12:31:
> Hi,
>
>
>> String sql = "select test_user_result_insert_func(?, ?, ?);";
>
> You can't call functions via JDBC like that.
That's perfectly valid - unless the function uses out parameters or ref
cursors.
I am however unsure about batche
The logs from the server would be useful
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 07:05, Thomas Kellerer wrote:
> Hannes Erven schrieb am 04.05.2015 um 12:31:
> > Hi,
> >
> >
> >> String sql = "select test_user_result_insert_func(?, ?, ?);";
>
Hello,
Please let me know how The database server is started with max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is installed.
Sanjeet
--
View this message in context:
http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-us
On 05/04/2015 02:02 AM, sanjeetkamble wrote:
Hello,
Please let me know how The database server is started with max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is installed.
Sanjeet
No doubt that would be a problem. Its bad idea. set max_connecti
I suggest pg_bouncer as opposed to pg_pool. My testing showed it handled
connections better. Ultimately the choice is yours, but with 1
connections, you absolutely need a connection manger.
On Mon, May 4, 2015 at 10:08 AM, Andy Colson wrote:
> On 05/04/2015 02:02 AM, sanjeetkamble wrote:
>
>
On 05/04/2015 02:02 AM, sanjeetkamble wrote:
Hello,
Please let me know how The database server is started with
max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is
installed.
Sanjeet
On Mon, May 4, 2015 a
Hi Craig,
Thank you for your reply. Below you will see the entire process that I have
used along with relevant log output. Something else that I have noticed is
that the status of nodes in bdr.bdr_nodes stays 'i' on the first server
that I initialize (lets call it primary and the others backups fo
I just realized this also. The node that was removed and recreated shows
only one replication slot once it is recreated. That slot has its own id in
it too. That appears to be the problem. I have no idea why when creating it
the first time the slots for the other two nodes are created correctly, bu
On 4/30/15 1:23 PM, Greg Sabino Mullane wrote:
Bucardo and pg_pool are both based on the idea of replaying SQL
statements instead of replicating actual data. They have their uses, but
I personally distrust that idea, especially for DR.
Actually, Bucardo is very data-based, not statement at all.
On 5/2/15 2:32 PM, Adrian Klaver wrote:
On 05/02/2015 09:53 AM, Yves Dorfsman wrote:
I find my plpgsql functions becomes unreadable very quickly. I want to
break
them up in smaller functions.
What is the best way to organised them?
Is there any way to define functions inside functions?
When I
>
> As for performance concerns, in 99% of cases code maintainability is going to
> be way more important than performance microoptimization. If you're *that*
> concerned about performance than plpgsql probably isn't the right answer
> anyway.
Isn't one of the advantage of running on the server
The database function does not use out parameters or a ref cursor, which
was why I was confused. The Java sample I provided is a simplification of
the built-in default logic of the Spring Batch ItemWriter - I put it into
my own implementation class to help with debugging. The root cause seems to
b
Did this every go any further?
I wrote some data transformation script at work, and after seeing "with
count -2017657667" (and similar) in my scripts log I got a bit worried.
seeing else where were folks just run a full on count(*) later to check
counts but that is even MORE time and I was think
On May 4, 2015 02:32:14 PM Yves Dorfsman wrote:
> > As for performance concerns, in 99% of cases code maintainability is going
> > to be way more important than performance microoptimization. If you're
> > *that* concerned about performance than plpgsql probably isn't the right
> > answer anyway.
>
Sorry about the long silence on this.
On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar
> wrote:
>
>> On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby
>> wrote:
>>
>
>>> No. I suspect the community would support at l
On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar
wrote:
> Sorry about the long silence on this.
>
> On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar
>> wrote:
>>
>>> On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby
On Tue, May 5, 2015 at 1:44 PM David G. Johnston
wrote:
> On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar
> wrote:
>
>> Sorry about the long silence on this.
>>
>> On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston <
>> david.g.johns...@gmail.com> wrote:
>>
>>> On Sun, Apr 12, 2015 at 10:23 PM, Sam
PGFoundry's own link to their Sample databases gives me a 404 error.
http://pgfoundry.org/projects/dbsamples/
Does anyone know of an alternative source for the sample databases? And what is
going on at pgfoundry?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
21 matches
Mail list logo
