Re: [PERFORM] Read rows deleted

2012-12-12 Thread Alejandro Carrillo
delete rows of a table without writing of a table file? Thanks > > De: Sergey Konoplev >Para: Alejandro Carrillo >CC: "pgsql-performance@postgresql.org" >Enviado: Miércoles 12 de diciembre de 2012 15:13 >Asunto: Re: [PERFORM]

[PERFORM] Read rows deleted

2012-12-12 Thread Alejandro Carrillo
Hi, Anybody knows a JDBC or a multiplatform code that let read the delete rows of a table without writing of a table file? Anybody knows how to create a table using a table file? thanks

[PERFORM] Support Create package

2012-10-16 Thread Alejandro Carrillo
Hi, Why PostgreSQL, the EnterpriseBD supports create/alter/drop package and the opensource doesn't? Is a project or never will have support? Thanks

Re: [PERFORM] Postgres delete performance problem

2012-06-25 Thread Alejandro Carrillo
"It does so by removing all constraints, then it compares table contents row by row, inserts missing rows and deletes "extra" rows in the target database." If the delete's you do when the constraints and indexes are removed then you need to create the constraints and indexes before you delete the

Re: [PERFORM] Missing block Magic

2012-06-05 Thread Alejandro Carrillo
I restart and doesn't work. :( Please help me! > > De: Tom Lane >Para: Alejandro Carrillo >CC: "pgsql-performance@postgresql.org" >Enviado: Martes 5 de junio de 2012 12:00 >Asunto: Re: [PERFORM] Missing block Magi

[PERFORM] Missing block Magic

2012-06-05 Thread Alejandro Carrillo
Hi, I want to make a function in C for postgresql, this is the code: #define _USE_32BIT_TIME_T #define BUILDING_DLL 1 #include "postgres.h" #include "fmgr.h" #include "executor\spi.h" /* SPI - Server Programming Interface */ #if defined(_MSC_VER) || defined(__MINGW32__) #define PG_GETINF_EXPOR

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 201

Re: [PERFORM] Recover rows deleted

2012-06-04 Thread Alejandro Carrillo
.a Ejecución Terminada I use the sources of binary downloaded of http://www.enterprisedb.com/products-services-training/pgbindownload. What I doing bad? Thanks > > De: Merlin Moncure >Para: Alejandro Carrillo >CC: "stho...@optionshouse.com&q

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: &

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: R

Re: [PERFORM] Recover rows deleted

2012-05-29 Thread Alejandro Carrillo
zewski >Para: Alejandro Carrillo >Enviado: Martes 29 de Mayo de 2012 17:21 >Asunto: Re: [PERFORM] Recover rows deleted > >On Tue, May 29, 2012 at 11:16:56PM +0100, Alejandro Carrillo wrote: >> Hi friend, >> >> Your function doesn't compile in Windows. >&

Re: [PERFORM] Recover rows deleted

2012-05-29 Thread Alejandro Carrillo
Hi friend, Your function doesn't compile in Windows. Please change it. Thanks > > De: hubert depesz lubaczewski >Para: Alejandro Carrillo >CC: "pgsql-performance@postgresql.org" >Enviado: Martes 29 de Mayo de 2012 16:33 >A

[PERFORM] Recover rows deleted

2012-05-28 Thread Alejandro Carrillo
Hi, ¿How I can recover a row delete of a table that wasn't vacuummed? I have PostgreSQL 9.1 in Windows XP/7. Thanks

Re: [PERFORM] SSD selection

2012-05-16 Thread Alejandro Carrillo
¿Wizard Merlin? > > De: Merlin Moncure >Para: David Boreham >CC: pgsql-performance@postgresql.org >Enviado: Miércoles 16 de Mayo de 2012 13:53 >Asunto: Re: [PERFORM] SSD selection > >On Wed, May 16, 2012 at 12:45 PM, David Boreham wrote: >> On 5/16/2012 11: