Re: [PERFORM] Trouble with plan statistics for behaviour for query.

2012-06-04 Thread Trevor Campbell
Actually, I'm rather surprised to see 'real' there: if you're using setObject with a Long, I would imagine that turns into a bigint (which I believe the server knows how to coerce to numeric). The (real) is just my fault in testing. I just copy/pasted from elsewhere and it is not what is coming f

Re: [PERFORM] Trouble with plan statistics for behaviour for query.

2012-06-04 Thread Trevor Campbell
Thanks for all your help so far. I have been away for a couple of days so my apologies for not replying earlier. We are using a third party library to run our SQL via JDBC (not one of the common ones like Hibernate etc), but I have been able to dig out the exact statements run in the scenario

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Kevin Grittner
Alejandro Carrillo wrote: > How I can compile in Windows using Visual Studio and Mingw? http://www.postgresql.org/docs/current/interactive/install-windows.html -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Alejandro Carrillo
ok, How I can compile in Windows using Visual Studio and Mingw? > > De: Merlin Moncure >Para: Alejandro Carrillo >CC: "stho...@optionshouse.com" ; >"pgsql-performance@postgresql.org" >Enviado: Lunes 4 de junio de 2012 13:23 >Asunto: Re: [PERFORM] Recover row

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Merlin Moncure
On Mon, Jun 4, 2012 at 12:46 PM, Alejandro Carrillo wrote: > How I can compile in Windows? I tried to compile using Dev-C++ 4.9 and show It's probably going to take some extra effort to compile backend libraries with that compiler. The two supported compiling environments on windows are mingw an

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Alejandro Carrillo
How I can compile in Windows? I tried to compile using Dev-C++ 4.9 and show a warning: Compilador: Default compiler Building Makefile: "C:\Documents and Settings\Administrador\Escritorio\pg_dirtyread\Makefile.win" Ejecutando  make clean rm -f pg_dirtyread.o  pg_dirtyread.a gcc.exe -c pg_dirtyrea

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Merlin Moncure
On Mon, Jun 4, 2012 at 11:47 AM, Alejandro Carrillo wrote: > In linux exists > (https://github.com/omniti-labs/pgtreats/blob/master/contrib/pg_dirtyread/pg_dirtyread.c) > But I can't compile in Windows :( > Anybody could compile in Windows? There are no linux specific calls in there that I can s

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Alejandro Carrillo
In linux exists (https://github.com/omniti-labs/pgtreats/blob/master/contrib/pg_dirtyread/pg_dirtyread.c) But I can't compile in Windows :( Anybody could compile in Windows? > > De: Shaun Thomas >Para: Alejandro Carrillo >CC: "pgsql-performance@postgresql.org

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Shaun Thomas
On 06/04/2012 11:14 AM, Alejandro Carrillo wrote: Anybody knows a function that let's recover a record (row) deleted in Windows? Sorry Alejandro, I'm pretty sure no database anywhere has a function like that. If there were, I'd certainly like to see it! Generally you avoid situations like th

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Alejandro Carrillo
Anybody knows a function that let's recover a record (row) deleted in Windows? Thanks > > De: Jeff Davis >Para: Alejandro Carrillo >CC: "pgsql-performance@postgresql.org" >Enviado: Martes 29 de Mayo de 2012 15:53 >Asunto: Re: [PERFORM] Recover rows deleted