[GENERAL] array_agg + limit

now why it happens an how avoid it, but it's ok? Must work like this? --               Emanuel Calvo Franco         DBA | www.emanuelcalvofranco.com.ar Curso a distancia Nivel 1 Admin Postgres:     http://www.postgresql-es.org/node/525 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] array_agg + limit

2010/11/27 Lew no...@lewscanon.com: Emanuel Calvo Franco wrote: I'm having this 'issue': coches=# select array_agg(patente order by fecha desc) from dia4.infraccion limit 6;                                array_agg

Re: [GENERAL] postgre on virtual machine

. You can not spare RAM or CORES. What will tell you, the exact amount of each other, is 'how' the application will use the base. If you share more details, maybe we could help a little more. --               Emanuel Calvo Franco         DBA | www.emanuelcalvofranco.com.ar Curso a distancia

Re: [GENERAL] PANIC: corrupted item pointer: 32766

this happened?! Do you have fsync turned off? -- Emanuel Calvo Franco www.emanuelcalvofranco.com.ar Join: http://www.thevenusproject.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Constraint exclusion issue

. Or something like this: select ('(' || quote_literal('b') || ',0)')::y shs-dev=# select ('(b,,0)'::y).c; ERROR:  value too long for type character(1) LINE 1: select ('(b,,0)'::y).c; -- -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar

Re: [GENERAL] Innotop for postgresl

at all) here: http://desarrollos.siu.edu.ar/trac/postgresql/attachment/wiki/Desarrollos/pgstat -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] re-using RETURNING

; entero 13 (1 row) Obviusly, you can automatize these steps in a shell script. Hope you enjoy it. -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] How to reduce WAL file Size

--with-wal-segsize=SEGSIZE set WAL segment size in MB [16] when you compile postgresql allow you to change the size of these files (but you can't do it only restarting :S ) -- Emanuel Calvo Franco DBA at: www.siu.edu.ar

Re: [GENERAL] Query inside RTF

? :) -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Query inside RTF

2009/10/8 Leonardo M. l.r...@griensu.com: On jue, 2009-10-08 at 17:01 -0300, Emanuel Calvo Franco wrote: select  * from my_table where  cast(rtf_field as varchar) like '%condition%' This works ok when the condition doesn't include accented chars. RTF escapes accented characters

Re: [GENERAL] citext like query and index usage

where hashtext(i) = hashtext('all the field here'); It is useful? -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Snow Leopard and plpython problem

-perl, libperl-dev, python-all-dev (for perl and python). For 8.3 i didn't need it (seems). But in my case i use 2.5. Hope it helps :S -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released

, in a /var/www and when the livecd starts, firefox displays the links for each doc (all the docs are in the cd, thats is the better) - has a postgres wall paper Could be great add-ons, what do you think about it? if i can help let me know. Regards! -- Emanuel Calvo Franco

Re: [GENERAL] Index utilization

for me. If i can offer some code let me know :) -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Proxy for postgres

interference the performance and is not really what you want. -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Simulate count result are distinct between 8.3 and 8.4

and not look for another way :) -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] plperl function

:) The error is telling you that could not return an array into integer. -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] Simulate count result are distinct between 8.3 and 8.4

filas) synchronize_seqscan are on in both engines. I only want to know why is this difference... -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Problems compiling contribs in Open Solaris

/xmlerror.h xpath.c, line 22: cannot find include file: libxml/parserInternals.h You need to tell configure where to find libxml's headers (--with-includes). Ok, sounds good :) I will try to take a woraround on this shortly. Thkx Alvaro! -- Emanuel Calvo Franco

[GENERAL] Problems compiling contribs in Open Solaris

contribs. Someone had the same problems. I'm using gmake and sunstudio 12 for compiling. Thkx! -- Emanuel Calvo Franco www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] uuid contrib don't compile in OpenSolaris

will continue my workaround on this and try to propose something to fix it. -- Emanuel Calvo Franco www.emanuelcalvofranco.com.ar ArPug.com.ar / aosug.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] just curious

/?searchterm=logo It's no bad... -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Replication

and administration. -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] drawback of array vs join

, the improvement in terms of performance will be negligible. -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Query optimizer prepared statements

   select ...    from T    where x $1 prepare testy_prepare(int) as select * from T where x = $1; execute testy_prepare(4); Follow the docs :) http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member

Re: [GENERAL] How to store text files in the postgresql?

? Thank you for your time. Dimitry You can use the function pg_read_file(text,bigint,bigint)? like: inser into table foo values(1,2,3 [...], pg_read_file(filename,1,[?]); The problem is to write it on the disc, there is not a function for that AFAIK. -- Emanuel Calvo Franco ArPUG

Re: [GENERAL] [HACKERS] PostgreSQL installation

for Solaris are in the site #1, you will find since installation until complex trace rutines. Enjoy it! #1[http://www.sun.com/software/products/postgresql/index.jsp] Regards, -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar -- Sent via

Re: [GENERAL] Pl/java in 8.4 bet1 sources compilation failed

2009/5/28 Kris Jurka bo...@ejurka.com: On Wed, 27 May 2009, Emanuel Calvo Franco wrote: Hi community, I'm trying to compile pl/java sources for 8.4 beta1 (for a test) but it gives me 20 errors at the end: To build against 8.4 you need pljava from CVS.  Also pljava can only be built

Re: [GENERAL] Pl/java in 8.4 bet1 sources compilation failed

2009/5/29 David Fetter da...@fetter.org: On Fri, May 29, 2009 at 09:48:42AM -0300, Emanuel Calvo Franco wrote: 2009/5/28 Kris Jurka bo...@ejurka.com: On Wed, 27 May 2009, Emanuel Calvo Franco wrote: Hi community, I'm trying to compile pl/java sources for 8.4 beta1 (for a test

Re: [GENERAL] How to Install Postgres 8.3 in Solaris 10 as a service

that in Solaris you have SMF to initialize Postgresql with more 'intelligence'. Is a perfect document that describes the complete installation of Pgsql on this platform: http://dlc.sun.com/pdf/819-5578/819-5578.pdf -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG

Re: [GENERAL] How to Install Postgres 8.3 in Solaris 10 as a service

2009/5/27 Emanuel Calvo Franco postgres@gmail.com: 2009/5/27 Anirban Pal anirban@newgen.co.in: Dear all members, I have been working on postgres (windows), for last 8 months. Recently, a client requrement requires me to install postgres in solaris 10. What I did is this. Untar

[GENERAL] Pl/java in 8.4 bet1 sources compilation failed

... I have 8.3 jar compild pljava, exists a way to create a function and the server 'ignore' the lib version? Regards, -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Good PG Books ?

. The Peter Einsertraut book is in Deustch language, but if you have intuition you can read it :P -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Good PG Books ?

a good point XD But i must say is not so handly ;P http://www.postgresql.org/docs/books/ If you look for well, you will find the book i recommended. -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG / AOSUG Member -- Sent via pgsql-general

Re: [GENERAL] limit-offset different result sets with same query

tables ...                        regards, tom lane Yeap. If you see one of the test i made, you'll see this switch over the ~100 regs. -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] limit-offset different result sets with same query

2009/5/8 David Fetter da...@fetter.org: On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote: I test it in the first time :) With the 'order by' it works well, but in 'theory' The theory under which you should operate is that the underlying implementation only gives you

[GENERAL] limit-offset different result sets with same query

is sequential in the physical table returns differents data? I test it on 8.4 beta1 and 8.3.5 and 8.3.7 with the same results. Thanks in advance. -- Emanuel Calvo Franco Sumate al ARPUG ! ( www.arpug.com.ar) ArPUG / AOSUG Member -- Sent via pgsql-general mailing list

Re: [GENERAL] limit-offset different result sets with same query

2009/5/8 Tom Lane t...@sss.pgh.pa.us: Emanuel Calvo Franco postgres@gmail.com writes: Executing 'select * from datos limit 1 offset 15' two times i have different result sets. The synchronous scan logic is probably responsible.  Turn off synchronize_seqscans if this behavior

Re: [GENERAL] limit-offset different result sets with same query

2009/5/8 David Fetter da...@fetter.org: On Fri, May 08, 2009 at 06:10:18PM -0300, Emanuel Calvo Franco wrote: Hi all. I'll make this faster. I hace this table and this function: You should only ever assume that your SELECT's output will have a particular ordering when you include an ORDER

Re: [GENERAL] In memory Database for postgres

table on ram: 22836.532 standard table on disk: 16902.042 temp table on ram: 12773.371 temp table on disk: 13716.049 -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar) ArPUG / AOSUG Member Postgresql Support Admin -- Sent

Re: [GENERAL] In memory Database for postgres

in memory :) -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar) ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] [COMMITTERS]

-general. Thanks. -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar) ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Last question

for detail the path of the includes. I think there must be inside a folder called 'server' in the same path. Yes, i was who said to you that committers is not the right place :) -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar

Re: [GENERAL] [COMMITTERS]

the option -I (include) REPLY TO pgsql-gene...@portgresql.org,please... Comitters is not a list to make questions :) And please, when you post a question put a description in the subject of the mail. Thanks. -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org

[GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 235 4 of relation…

generally on 7.x versions or if you are using fsync =off and you have a surprised system down. Try to do a pg_dump of the database or clean (no delete) del wal files (this is not recommendable for new users). What can I do to fix that problem? Thank you, -- Emanuel Calvo Franco

[GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 235 4 of relation…

, i declare a var in postgresql.conf (zero_damaged_pages = on ) and make the dump with this option. I don't know if this var is in newly versions. Did you try to make a reindex? -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar

[GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 235 4 of relation…

2009/4/1 Emanuel Calvo Franco postgres@gmail.com: 2009/4/1 Patrick Desjardins mrdesjard...@gmail.com: Did you try to make a reindex? If you get an error with that, try to drop indexes and create again. --      Emanuel Calvo Franco        Sumate al ARPUG !      (www.postgres-arg.org

Re: [GENERAL] [GENEAL] dynamically changing table

-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar) ArPUG / AOSUG Member Postgresql Support Admin -- Sent via

Re: [GENERAL] running two clusters on one machine

ports. I'm running v 8.3 on a Mac running 10.5. What's the secret step I'm missing here? Thanks, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo

Re: [GENERAL] postgresql and LDAP

about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org

Re: [GENERAL] PostgreSQL CE?

Certification, like in Japanese. Thank you for your time, Steve, -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Sumate al ARPUG

[GENERAL] VDI of pglive distro

/pgsql.vid.gz [1] http://www.pglive.info -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [ADMIN] Problem with pg_dump

/ 1180635517879 3001C:/System Volume Information/ Is this something that is perhaps fixed in postgresql 8.3? Any assistance in resolving this problem would be appreciated. Thanks, Ed -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support Admin -- Sent

Re: [GENERAL] inconsistency in aliasing

pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] simple limit of decimals

: 0160/7141639 (mehr: - Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco

Re: [GENERAL] Trying to create implicit casts to text in PG 8.3

with a text '13') for example. Regards, Aleksander -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support

Re: [GENERAL] Polymorphic setof record function?

://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco ArPUG / AOSUG

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

that rely on those casts http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284 here are the functions -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

precision ); Regards, Aleksander -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general I forgive to tell you that you must add operators...d'oh! -- Emanuel Calvo Franco ArPUG

Re: [GENERAL] dblink between oracle and postgres?

Ora-link In the opposite direction, you can use Oracle's feature described here: http://lists.mysql.com/mysql/189287 (change to psqlodbc driver should be easy). -- Filip Rembiałkowski -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support Admin -- Sent via pgsql

Re: [GENERAL] Replication on windows

://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] H2 database

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] This is a limit-offset bug?

limitsdfsdfaerfgsafqaweawe; - shows all rows select * from foo limit; - this shows error ok select * from foo limitt; All the chars inmediatly continue the limit or offset commands are ignored. If this kind of problems there isn't a bug, sorry. -- Emanuel Calvo Franco Syscope Postgresql

Re: [GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008/12/24 Tom Lane t...@sss.pgh.pa.us: Emanuel Calvo Franco postgres@gmail.com writes: But when i want to make, i recieved an error (make and /opt/SunStudioExpress/bin/dmake ): ... eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make You must use GNU make to build PostgreSQL

Re: [GENERAL] This is a limit-offset bug?

2008/12/26 Martijn van Oosterhout klep...@svana.org: On Fri, Dec 26, 2008 at 09:52:59AM -0200, Emanuel Calvo Franco wrote: Hi people, Yesterday when i was making some commands on 8.3.5 (on Centos) i found a rare behavior of limit offset. Try in psql: select * from foo limit 3; - shows ok

[GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

20081005) Java: 1.6.0_10; Java HotSpot(TM) Client VM 11.0-b15 System: SunOS version 5.11 running on x86; UTF-8; es_AR (sunstudio) Userdir: /export/home/ecalvo/.sunstudio/ceres-dev4-SunOS-i386 Thanks in advance, -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member

[GENERAL] Donwload 8.4

Hi ! There isn't another way to download 8.4devel that isn't cvs and the last rpm binary? I mean, i need source code, but in my work i can't access with cvs because proxy policies. Sorry for my bad english, -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member

Re: [GENERAL] Trigger/Rules Order of operations

with it? Ketema J. Harris www.ketema.net ket...@ketema.net ketemaj on iChat -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql Consultant

Re: [GENERAL] Schemas and Privileges

structure from db users. See that, that's because i make separates db's (because you really want is independency for each user) only the data is protected. this is not going to change soon, AFAIK. -- Filip Rembiałkowski -- Emanuel Calvo Franco Syscope Postgresql Consultant

Re: [GENERAL] Ubuntu for servers (was TurnKey PostgreSQL)

://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The future of Solaris?

://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql Consultant ArPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ayuda

-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql DBA BaPUG / AOSUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] PGDAY2008 (PostgreSQL)

/*-- Bienvenidos a: PGDay 2008 Rio de la Plata Organizado por la comunidad de PostgreSQL de Bs As (BaPUG) Web: www.postgres-arg.org

Re: [GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

://sun.com/postgresql -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Emanuel Calvo Franco Syscope Postgresql DBA BaPUG Member -- Sent via pgsql-general mailing

Re: [GENERAL] Replication with slony-I

http://slony.blogspot.com/ sorry is in spanish, but is an exelent resource, i hope it will be useful reggards 2008/10/27 Abdul Rahman [EMAIL PROTECTED]: May any one support step by step procedure for the replication with slony-I in windows xp. -- Emanuel Calvo Franco Syscope

Re: [GENERAL] How to free disk space

? It locks the database for several hours, and that is not a solution. I guess a backup-restore would do the work but, isn't there a better way to do this without shutting down postgres? Thanks in advandce. -- Emanuel Calvo Franco Syscope Postgresql DBA BaPUG Member

Re: [GENERAL] databases list to file

inside psql turn \o file then \l 2008/10/9 Jeff Ross [EMAIL PROTECTED]: Joao Ferreira gmail wrote: Hello all, I need to print to a file a simple list of all the databases on my postgresql. I need to do this from a shell script to be executed without human intervention I guess

Re: [GENERAL] Opteron vs. Xeon performance differences

How do you manage the wal in both servers? The version kernel is the same in both? Runs the same services? Do you make some test with Posgresql only in both servers? If the problem is the inter-CPU, i know you can specified the number of processors do you want to run dedicated to one process.

Re: [GENERAL] Opteron vs. Xeon performance differences

When i question about WAL, i mean if WAL is in other drive. You must run a benchmark more expensive to cpu for make a conclusion. Make a query that have more of 8 seconds, then you can see really if exists a diference in other way... i think you don't use the same image of the old server in the

Re: [GENERAL] [HACKERS] PostgreSQL future ideas

2008/9/27 Douglas McNaught [EMAIL PROTECTED]: On Sat, Sep 27, 2008 at 12:13 PM, Mark Mielke [EMAIL PROTECTED] wrote: If some parts of PostgreSQL are not performance bottlenecks, and they are extremely complicated to write in C, and very easy to write in something else common and simple (I've

Re: [GENERAL] Restoring a database from a file system snapshot

Sorry Alvaro, i sent to you the message ;P Is the same way (from snapshot) that use Mysql on ZFS. IF you don't change anything in the database, why it don't works? Then you restart the service with the same path. The problem it will be that you need to stop postgres BEFORE snapshot. -- Sent