Re: [HACKERS] Instructions for adding new catalog
Thanks for reply, Tom. Well, just for documenting the process... Adding new postgres catalog in 2 little steps: 1)Write catalog header file and save it into src/include/catalog directory. Hint: copy format from other catalog headers. 2)Add your header file name to variable POSTGRES_BKI_SRCS in file src/backend/catalog/Makefile Make, make install, then initdb will create new system catalogs for you. Gustavo. On Fri, Aug 1, 2008 at 11:28 AM, Tom Lane [EMAIL PROTECTED] wrote: Gustavo Tonini [EMAIL PROTECTED] writes: I read the archives, but I can't find the instructions for adding new catalogs to the system. That's probably because there aren't any. Look at recent patches that added a new catalog to get an idea of what you need to do. The enum patch might be a good choice. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Instructions for adding new catalog
Hello, I read the archives, but I can't find the instructions for adding new catalogs to the system. Where can I find those instructions? Is there a document about this? Thanks, Gustavo. P.S: Please CC to me on reply -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] comunication protocol
Em Quarta 08 Agosto 2007 12:02, Omar Bettin escreveu: Hi, I have installed postgresql to my client as a server for a progam (libpq.dll/VCL based) that I wrote for them. Borland VCL? What component are you using? Gustavo. pgp81qX9X4CeQ.pgp Description: PGP signature
[HACKERS] pgCluster CVS repository
Does pgCluster have a own CVS repository? Gustavo. pgppHPBB12Fhp.pgp Description: PGP signature
Re: [HACKERS] Fragmentation project
Josh, On 4/23/07, Josh Berkus [EMAIL PROTECTED] wrote: Gustavo, Oh, you're talking about distributing partitions across different nodes and parallelizing queries. No, we don't do that today. Yes.This is the goal. Well, I will try it. I'll send the project reports to this list. Comments will be valuable. Desire me good luck... You might join/look at the PgPoolII project, which is working on parallel query amoung other things. The pgpool is an interesting approach to this, but I think that the funcionality of inserting a record at a backend which will be redirectioned to other and verifying deadlocks under network demands in acquiring locks on the referenced records/tables in several hosts. Then, IMO, this may be implemented inside dbms. How Marko wrote, this is a non-trivial solution... Really, It could be improved on pgpool to be a process coordinator, but will need some changes in backend too. This is a non trivial implementation, but there are several users waiting for an effective solution for data distributing in a cluster. These users actually buy commercial solutions or build themselves one. Gustavo. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Fragmentation project
Marko, On 4/24/07, Marko Kreen [EMAIL PROTECTED] wrote: On 4/23/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: Oh, you're talking about distributing partitions across different nodes and parallelizing queries. No, we don't do that today. PL/Proxy actually works like that, only in smaller scope - for function calls only. I think that proposed funcionalities cannot be implemented in a PL scope... Gustavo. General solution that partitions free-form SQL will be non-trivial... ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Fragmentation project
On 4/23/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: Gustavo Tonini wrote: Well, I'm thinking in define (maybe via SQL) a set of servers as a cluster and make the fragmentation rules based on select clauses, storing this configuration in a specific catalog in global schema. For example: when a record is inserted in a server which not store this fragment (no rule matches), it will be automatically moved do the correct server (the server who matches that record), transparently to the user. This process involves transaction management and a lot more validations. A propose is: create partition name on site as select clause This create a replication in this site with the rules of the select clause. We can provide, for example, users create a foreign key in a site referencing a table who stored in other(s). In this case, the foreign key will be created in global schema but the validations of the local schema's would be managed by DRDBMS. These are my ideas. Is this supported today? Oh, you're talking about distributing partitions across different nodes and parallelizing queries. No, we don't do that today. Yes.This is the goal. Well, I will try it. I'll send the project reports to this list. Comments will be valuable. Desire me good luck... Thanks, Gustavo. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Fragmentation project
Well, I'm thinking in define (maybe via SQL) a set of servers as a cluster and make the fragmentation rules based on select clauses, storing this configuration in a specific catalog in global schema. For example: when a record is inserted in a server which not store this fragment (no rule matches), it will be automatically moved do the correct server (the server who matches that record), transparently to the user. This process involves transaction management and a lot more validations. A propose is: create partition name on site as select clause This create a replication in this site with the rules of the select clause. We can provide, for example, users create a foreign key in a site referencing a table who stored in other(s). In this case, the foreign key will be created in global schema but the validations of the local schema's would be managed by DRDBMS. These are my ideas. Is this supported today? Gustavo. P.S.: sorry by the English mistakes... On 4/19/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: Gustavo Tonini wrote: I'm thinking in project and implement data fragmentation based on catalogs inside pgcluster as my university final project. I would like suggestions and would be happy if anyone help me to define it. Sorry if this is the incorrect list...I had no answer on pgcluster-general... This is the correct list. I'm not sure what you mean by data fragmentation, but we do support horizontal partitioning by table constraints. And toasting is like vertical partitioning. What exactly are you thinking of implementing? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] Fragmentation project
Hello people, I'm thinking in project and implement data fragmentation based on catalogs inside pgcluster as my university final project. I would like suggestions and would be happy if anyone help me to define it. Sorry if this is the incorrect list...I had no answer on pgcluster-general... Thanks, Gustavo. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Slony-I for circular replication
The isbn is 0-13-659707-6. I'm very interesting in study (and implement) a generic framework for replication in a project of the university. Gustavo. On 4/1/06, Guido Barosio [EMAIL PROTECTED] wrote: Heya, Do you have the isbn of the book? Would be great. Cheers, G.- On 4/1/06, Gustavo Tonini [EMAIL PROTECTED] wrote: Ozsu show us some solution for the problem in the book Principles of distributed database systems. On 4/1/06, D'Arcy J.M. Cain darcy@druid.net wrote: On Fri, 31 Mar 2006 17:57:25 -0300 Gustavo Tonini [EMAIL PROTECTED] wrote: why there's no way to make multi-master replication generic? Well, that's the material for a paper but the simplest example I can suggest is serial. How do multiple machines insert into a database table with a sequential primary key? -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Guido Barosio --- ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Slony-I for circular replication
Ozsu show us some solution for the problem in the book Principles of distributed database systems. On 4/1/06, D'Arcy J.M. Cain darcy@druid.net wrote: On Fri, 31 Mar 2006 17:57:25 -0300 Gustavo Tonini [EMAIL PROTECTED] wrote: why there's no way to make multi-master replication generic? Well, that's the material for a paper but the simplest example I can suggest is serial. How do multiple machines insert into a database table with a sequential primary key? -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] how is that possible
IMHO null values shouldn't verify foreign keys constraints... Gustavo. 2006/2/10, ohp@pyrenet.fr ohp@pyrenet.fr: Many thanks for explaining. I learned something today... On Fri, 10 Feb 2006, Stephan Szabo wrote: Date: Fri, 10 Feb 2006 08:59:51 -0800 (PST) From: Stephan Szabo [EMAIL PROTECTED] To: ohp@pyrenet.fr Cc: pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] how is that possible On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote: My understanding is that null or not, there should have been a foreign key violation. Not as far as I can tell. MATCH (without partial or full) returns true if any column in the row value constructor is NULL. MATCH FULL returns true if all columns in the row value constructor are NULL and returns false if it's a mix of NULLs and non-NULLs. -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges+33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Situation with delphi7 x postgresql 8.1.2
zeos was better than dbexpress with postgresql and mysql in my test applications...connections were several seconds faster with zeos Gustavo. 2006/2/8, Merlin Moncure [EMAIL PROTECTED]: Hi, I develop under Delphi7(Build 8.1) pgexpress 4.01 and postgreSQL 8.1.2 OS is windows XP Professional or Windows 2003 Server. In my project i use dbexpress components TSQLConnection, TSQLQuery - TDataSetProvider - TClientDataSet. In some situations when the TClientDataSet excute action TClientDataSet.Open this freeze the aplication and CPU Usage is over 95%. This situation happen only when the server is native windows. If necessary i have one project and database for example. this is more appropriate in pgsql-general. anyways, turn on your query logging and find if the problem is begin generated from your app or the dbexpress middleware. sounds to me like the ususal tcp problem which is usually configuration related. also check out zeos database components for a fantastic set of components for delphi. Merlin ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] postmaster/postgres merge for testing
pgd? Gustavo. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Replication on the backend
Are you sure that no way to implement a generic aproach on the backend? What does specification say? Does Oracle 10g have a core implementation of replication (cluster)? Gustavo. 2005/12/7, Andrew Sullivan [EMAIL PROTECTED]: On Tue, Dec 06, 2005 at 12:35:43AM -0500, Jan Wieck wrote: We do not plan to implement replication inside the backend. Replication needs are so diverse that pluggable replication support makes a lot more sense. To me it even makes more sense than keeping transaction support outside of the database itself and add it via pluggable storage add-on.And, as I say every single time this comes up, Oracle's and IBM's and MS's and everybody else's replication systems are _also_ add ons.Ifyou don't believe me, look at the license costs.You can get asystem without it enabled, which means (by definition) it's a modularextension. A--Andrew Sullivan| [EMAIL PROTECTED]In the future this spectacle of the middle classes shocking the avant-garde will probably become the textbook definition of Postmodernism. --Brad Holland---(end of broadcast)---TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Replication on the backend
But, wouldn't the performance be better? And wouldn't asynchronous messages be better processed? Thanks for replies, Gustavo.2005/12/6, Jan Wieck [EMAIL PROTECTED]: On 12/5/2005 8:18 PM, Gustavo Tonini wrote: replication (master/slave, multi-master, etc) implemented inside postgres...I would like to know what has been make in this area.We do not plan to implement replication inside the backend. Replication needs are so diverse that pluggable replication support makes a lot moresense. To me it even makes more sense than keeping transaction supportoutside of the database itself and add it via pluggable storage add-on. Jan Gustavo. P.S. Sorry for my bad English. 2005/12/5, Chris Browne [EMAIL PROTECTED]: [EMAIL PROTECTED] (Gustavo Tonini) writes: What about replication or data distribution inside the backend.This is a valid issue? I'm not sure what your question is... -- (reverse (concatenate 'string gro.gultn @ enworbbc)) http://www.ntlug.org/~cbbrowne/x.html Love is like a snowmobile flying over the frozen tundra that suddenly flips, pinning you underneath.At night, the ice weasels come. -- Matt Groening ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriatesubscribe-nomail command to [EMAIL PROTECTED] so that yourmessage can get through to the mailing list cleanly--#==# # It's easier to get forgiveness for being wrong than for being right. ## Let's break this rule - forgive me.##== [EMAIL PROTECTED] #
Re: [HACKERS] Replication on the backend
I don't see anything in the TODO list. I'm very interesting in work that. If is possible... Gustavo.
[HACKERS] Replication on the backend
What about replication or data distribution inside the backend. This is a valid issue? Thanks, Gustavo.
[HACKERS] Doubt
What is ISTM? Sorry, Gustavo.
[HACKERS] Obtaining a source tree from CVS
Hello, how can i make a checkout from CVS server ? What is the address? Thanks, Gustavo