[GENERAL] WAL segments size

2007-11-12 Thread Bruno Almeida do Lago
Hi, One of our PostgreSQL databases is generating archive logs too frequently, since the number of transactions/s (inserts & updates) is very high. I was looking for a parameter on postgresql.conf to increase the WAL segments size, but according to documentation this can only be changed while bui

[GENERAL] FKs Lock Contention

2006-06-26 Thread Bruno Almeida do Lago
order of my PKs and FKs would influence that? I know this is not a simple question, but hope that someone could show me the light. :-) Best Regards, Bruno Almeida do Lago ---(end of broadcast)--- TIP 4: Have you searched our list

[GENERAL] Friendly catalog views

2006-05-10 Thread Bruno Almeida do Lago
Sometime ago I saw a project with the purpose of creating Oracle views over the PostgreSQL catalog.   I can’t remember/find it anymore. Do you know if it’s still available?   Is there any other project aiming to create friendly catalog views?     Best Regards, Bruno    

[GENERAL] More atomic online backup

2006-01-06 Thread Bruno Almeida do Lago
Hi, 1) I've a pg cluster with 5 databases here. I was wondering if it's possible to make an online backup of 1 database only, not the entire cluster. 2) Online backups at Oracle are done per tablespace. Do you see any advantage on this? Best Regards, Bruno Almei

[GENERAL] Strange behavior

2006-01-06 Thread Bruno Almeida do Lago
ase $BANCO" done [EMAIL PROTECTED] backup_psql8]$ ./backup.sh psql: could not send startup packet: Broken pipe Any clues???? Best Regards, Bruno Almeida do Lago ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] OCFS released as GPL

2005-08-22 Thread Bruno Almeida do Lago
I haven’t found any message on archives talking about this, so I’m posting it.   The OCFS (Oracle Cluster File System) is now GPL – see more on http://oss.oracle.com/projects/ocfs/   What do you think?     C ya, Bruno  

[GENERAL] PostgreSQL Features

2005-02-11 Thread Bruno Almeida do Lago
Hi,   I’d like to know if there is something like “insert /*+ append */ into” and materialized views (from Oracle) on PostgreSQL.   How can I pass hints to postgre and what hints are available?     Regards, Bruno

Re: [GENERAL] Oracle and PostgreSQL

2005-01-27 Thread Bruno Almeida do Lago
can I find how to do it?? I'm very happy with the good news! Thank you, Teolupus -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 4:32 PM To: Bruno Almeida do Lago Subject: Oracle and PostgreSQL > 1^st : Is there somebod

[GENERAL] Oracle and PostgreSQL

2005-01-27 Thread Bruno Almeida do Lago
Hello my friends,     We are going to change some Oracle 8i and 9i databases to PostgreSQL 8 at my company.     1st: Is there somebody who knows how to do it (had the same experience)? What are the limitations of this process (eg: incompatible data types and objects).   2nd: Which t

Re: [GENERAL] Best Linux Distribution

2005-01-21 Thread Bruno Almeida do Lago
am learning a lot from my experience with PostgreSQL. MS SQL Server is too easy. - Ian >>> Geoffrey <[EMAIL PROTECTED]> 01/21/05 10:15 AM >>> Patrick Welche wrote: > On Fri, Jan 21, 2005 at 03:23:47PM -0200, Bruno Almeida do Lago wrote: > >>Any info about NetBSD? &g

Re: [GENERAL] Best Linux Distribution

2005-01-21 Thread Bruno Almeida do Lago
I'm very interested in testing FreeBSD + PostgreSQL! Is it truth that the PostgreSQL project was born over BSD? Does the project still being developed over it? Atenciosamente, Bruno Almeida do Lago -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beha

Re: [GENERAL] Best Linux Distribution

2005-01-21 Thread Bruno Almeida do Lago
Any info about NetBSD? Bruno -Original Message- From: Matthew Story [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 3:16 PM To: Bruno Almeida do Lago Subject: Re: [GENERAL] Best Linux Distribution for the stability of BSD you should look into their development categories

Re: [GENERAL] Best Linux Distribution

2005-01-20 Thread Bruno Almeida do Lago
I still opt for Slackware simplicity and stability. Nothing better than a well configured Slackware box with XFS file system and PostgreSQL! =) C Ya, Bruno -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Mayer Sent: Wednesday, January 19, 2005 3:3

Re: [GENERAL] Best Linux Distribution

2005-01-19 Thread Bruno Almeida do Lago
You should look www.linuxiso.org. There you may find the ISO of a great variety of distros. C ya, Bruno Almeida do Lago -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Sent: Wednesday, January 19, 2005 1:01 PM To: pgsql-general@postgresql.org