[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

[GENERAL] FKs Lock Contention

2006-06-26 Thread Bruno Almeida do Lago
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 archives? http

[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 cant remember/find it anymore. Do you know if its still available? Is there any other project aiming to create friendly catalog views? Best Regards, Bruno

[GENERAL] Strange behavior

2006-01-06 Thread Bruno Almeida do Lago
] 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] 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 Almeida do Lago

[GENERAL] OCFS released as GPL

2005-08-22 Thread Bruno Almeida do Lago
I havent found any message on archives talking about this, so Im 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, Id 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

[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 tools

Re: [GENERAL] Oracle and PostgreSQL

2005-01-27 Thread Bruno Almeida do Lago
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 somebody who knows how to do it (had

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-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 Behalf

Re: [GENERAL] Best Linux Distribution

2005-01-21 Thread Bruno Almeida do Lago
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? That's all we use - no problems, so never had to do any comparisons

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

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