Re: [HACKERS] Including Snapshot Info with Indexes

2007-10-13 Thread Gokulakannan Somasundaram
On 10/12/07, Tom Lane [EMAIL PROTECTED] wrote: Andreas Joseph Krogh [EMAIL PROTECTED] writes: Will $SUBJECT make it possible for count(*) to use index? This is a much wanted feature. If you mean count(*) will become instantaneous, no it won't. It would get faster, but probably not by

Re: [HACKERS] Another Idea: Try Including snapshot with TOAS (was: Including Snapshot Info with Indexes)

2007-10-13 Thread Simon Riggs
On Sat, 2007-10-13 at 11:12 +0530, Gokulakannan Somasundaram wrote: b) But i don't understand how storing the visibility info in TOAST table would help you. In that case you may need to update it for every delete/ update happening in the main table. Only thing, it would help is if someone

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 IDs to

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 lot,

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

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 come

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 of our

[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

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 = constant) is stated explicitly. This much already exists

[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 I'd

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

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

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 stuff