Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-30 Thread Kim Bisgaard
On 2011-05-30 04:26, Greg Stark wrote: My biggest gripe about bugzilla was that it sent you an email with updates to the bug but you couldn't respond to that email. Just checked bugzilla's list of features and they *now* lists that as supported: File/Modify Bugs By Email In addition to the

Re: [HACKERS] ALTER TABLE ... ALTER COLUMN ... SET DISTINCT

2009-08-03 Thread Kim Bisgaard
Are there plans to make a small follow-up patch to make CREATE UNIQUE INDEX on one column (and variants in CREATE TABLE ... PRIMARY KEY) automatically do SET STATISTICS DISTINCT? It might not be as perfect a solution as teaching the planner to know about unique indexes, but it is better than not

Re: [HACKERS] Table clustering idea

2006-06-27 Thread Kim Bisgaard
Jim C. Nasby wrote: On Sun, Jun 25, 2006 at 08:04:18PM -0400, Luke Lonergan wrote: Other DBMS have index organized tables that can use either hash or btree organizations, both of which have their uses. We are planning to implement btree organized tables sometime - anyone else interested in t

Re: [HACKERS] Question about ALTER TABLE SET TABLESPACE locing

2006-02-02 Thread Kim Bisgaard
Hannu Krosing wrote: Ühel kenal päeval, K, 2006-02-01 kell 18:08, kirjutas Tom Lane: Hannu Krosing <[EMAIL PROTECTED]> writes: Does ALTER TABLE SET TABLESPACE lock the table It had better ... see nearby discussion about relaxing locking for TRUNCATE. Is it some recent

Re: [HACKERS] source documentation tool doxygen

2006-01-16 Thread Kim Bisgaard
Try following the link (the Doxygen icon) - it has both a tutorial and extensive doc. Regards, Kim Bisgaard Thomas Hallgren wrote: I wish I've had this when I started working with PostgreSQL. This looks really good. Very useful indeed, even without the comments. What kind of change

Re: [HACKERS] Project proposal/comments please - query optimization

2005-08-12 Thread Kim Bisgaard
Tom Lane wrote: Kim Bisgaard <[EMAIL PROTECTED]> writes: I have noticed a deficiency in the current query optimizer related to "full outer joins". Tom Lane has confirmed to me that it will not be 8.1 material. ... There are related issues involving

[HACKERS] Project proposal/comments please - query optimization

2005-08-11 Thread Kim Bisgaard
-selects, and is thus able to use indices. Looking forward for any comments. I am aware that there are workarounds (like query2, union of two left-joins, hand coding the join from a series of simple selects, ...) but I do not feel they are practical for my use. Regards, -- Kim Bisgaard