Re: [HACKERS] Delaying the planning of unnamed statements until Bind

2004-05-22 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: If the planner had the expected value as well as the variance of the cost distribution then it might realize that in this case for instance that the penalty for guessing wrong with an index scan is only going to be a

Re: [HACKERS] Delaying the planning of unnamed statements until Bind

2004-05-22 Thread Greg Stark
Greg Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: select * from mytable where entry_time = $1; The planner will take a seqscan when it sees this because it is worried about the downside if a large fraction of the table is being selected. I'll mention another

Re: [HACKERS] Database variables when copying a database

2004-05-22 Thread Christopher Kings-Lynne
Anyone thought about this at all yet? Is it possible to have per-database variables that refer to the current database in someway that would need to be altered to refer to the new db? Chris Christopher Kings-Lynne wrote: Hi, When you do this: CREATE DATABASE test TEMPLATE master; It doesn't

[HACKERS] pg_autovacuum fixes

2004-05-22 Thread Matthew T. O'Connor
This weekend I am trying to fix up all known the pg_autovacuum issues that should be resolved for 7.4.3. I am aware of only two issues: temp table issues, and unchecked send_query() calls, if I am forgetting something, please let me know. 1) temp table issue: I was not able to reproduce the

Re: [HACKERS] postgresql extension API proof of concept

2004-05-22 Thread Fabien COELHO
Dear Carl, What is the purpose of the extension api in simple terms; what is it FOR? What does it DO? Thanks for this perfectly legitimate question, as my mail was not very easy to understand without the context. The aim is to provide a compilation infrastructure to external modules (that is

Re: [HACKERS] add server include files to default installation?

2004-05-22 Thread Fabien COELHO
Dear Tom, Agreed. If we are pushing things out, it seems it is our duty to make it easy for outside things to integrate and build properly. It does not thereby follow that we should try to merge devel and base packages (to express it in RPM terms). They are not necessarily merged, and

[HACKERS] CVS HEAD: make install broken for vpath

2004-05-22 Thread Neil Conway
With current sources, it appears that vpath builds (i.e. separate source and build trees) are broken. make succeeds, but make install produces: [neilc:/Users/neilc/build-pgsql]% make install make -C doc install make[1]: Nothing to be done for `install'. make -C src install make -C port install

Re: [HACKERS] Call for 7.5 feature completion

2004-05-22 Thread David Garamond
Robert Treat wrote: Given that the cygwin version is currently labeled as not ready for production I would say you are right. The truth is that many will never declare win32 good for production simply because of the OS it runs on, but we still want to make it as solid as possible. People _do_ use