Re: [HACKERS] Seems we need a post-beta1 initdb already

2007-10-13 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Might be worthwhile to try to get beta2 out as quickly as we can after the > changes are in, to minimize the number of people who will need it? I'd like to get the locale/encoding issues straightened out, and also get the contrib-tsearch-examples st

Re: [HACKERS] 8.3 full text search docs

2007-10-13 Thread Albert Cervera i Areny
Andy, note that documentation is discussed in the pgsql-docs list and patches usually are submitted to the pgsql-patches list. Nice to see both new sections, by the way. A Diumenge 14 Octubre 2007, andy va escriure: > I have two doc updates I'd like to offer. I see we have two example > section

[HACKERS] ABIs are hard

2007-10-13 Thread Gregory Stark
Hm, I suppose this is expected. I always hated the idea that libraries could introduce new symbols without an soname bump but obviously nobody's going to be interested in an soname bump today... ! /home/stark/src/local-HEAD/pgsql/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql: s

[HACKERS] 8.3 full text search docs

2007-10-13 Thread andy
I have two doc updates I'd like to offer. I see we have two example sections: creating rule-based dict's and creating parsers. When I was starting I would have liked to see an example usage. I'd like to offer: "example usage" and "Upgrading". This is my first draft, if anyone has suggestions

Re: [HACKERS] Postgresql partitioning problems & suggested solutions

2007-10-13 Thread Gregory Stark
"SHARMILA JOTHIRAJAH" <[EMAIL PROTECTED]> writes: > Now for > SELECT * FROM Foo WHERE b='2' > > it should know to access only Foo_2, I suppose it could be done > with a rule, but that should work even if b='2' is implicitly > given (not just if b = ) is stated explicitly. This much already exists

[HACKERS] Postgresql partitioning problems & suggested solutions

2007-10-13 Thread SHARMILA JOTHIRAJAH
We are presently investigating to migrate large (>10 TB) databases from Oracle to PostgreSQL. We find the need for table partitioning and the support of that is not good in PgSQL. We think the problem might be important enough to reach out to someone who might help us. Our idea is that a dedica

Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-13 Thread Jonah H. Harris
On 10/13/07, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > Hi, > I went through this article and it was good. Please have a look at it. > > http://www.databasecolumn.com/2007/09/one-size-fits-all.html > > This article was written by Michael Stonebraker, considered to be the > founder

Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-13 Thread Jonah H. Harris
On 10/13/07, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > I accept that the indexes will be bigger in size for this approach. You > might need more disk-space and you might need more memory to accomodate the > same amount of information. But i think disk costs and memory costs have > com

Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-13 Thread Gokulakannan Somasundaram
Hi, I went through this article and it was good. Please have a look at it. http://www.databasecolumn.com/2007/09/one-size-fits-all.html This article was written by Michael Stonebraker, considered to be the founder of our database. He has mentioned that the DBMS designed in 1970s haven't cha

Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-13 Thread Gregory Stark
"Gokulakannan Somasundaram" <[EMAIL PROTECTED]> writes: > I accept that the indexes will be bigger in size for this approach. You > might need more disk-space and you might need more memory to accomodate the > same amount of information. But i think disk costs and memory costs have > come down a

Re: [HACKERS] Seems we need a post-beta1 initdb already

2007-10-13 Thread Magnus Hagander
> It seems that we are faced with a choice of two evils: > > 1. Accept that there's an ABI break and increment libpq.so's major > version number for 8.3. This will be a PITA for packagers, who will > have to carry a compatibility package to provide 8.2 libpq.so. > > 2. Renumber 8.3's encoding