Re: [HACKERS] Instructions for adding new catalog

2008-08-03 Thread Gustavo Tonini
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

2008-08-01 Thread Gustavo Tonini
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

2007-08-08 Thread Gustavo Tonini
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

2007-08-05 Thread Gustavo Tonini
Does pgCluster have a own CVS repository?

Gustavo.


pgppHPBB12Fhp.pgp
Description: PGP signature


Re: [HACKERS] Fragmentation project

2007-04-25 Thread Gustavo Tonini

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

2007-04-25 Thread Gustavo Tonini

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

2007-04-23 Thread Gustavo Tonini

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

2007-04-21 Thread Gustavo Tonini

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

2007-04-19 Thread Gustavo Tonini

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

2006-04-02 Thread Gustavo Tonini
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

2006-04-01 Thread Gustavo Tonini
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

2006-02-10 Thread Gustavo Tonini
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

2006-02-08 Thread Gustavo Tonini
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

2006-01-24 Thread Gustavo Tonini
pgd?

Gustavo.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] Replication on the backend

2005-12-08 Thread Gustavo Tonini
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

2005-12-06 Thread Gustavo Tonini
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

2005-12-06 Thread Gustavo Tonini
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

2005-12-05 Thread Gustavo Tonini
What about replication or data distribution inside the backend. This is a valid issue?

Thanks,
Gustavo.


[HACKERS] Doubt

2005-11-25 Thread Gustavo Tonini
What is ISTM?

Sorry,
Gustavo.


[HACKERS] Obtaining a source tree from CVS

2005-11-10 Thread Gustavo Tonini
Hello,
how can i make a checkout from CVS server ? What is the address?

Thanks,
Gustavo