Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread Curt Sampson
On 23 Jun 2002, J. R. Nield wrote: > So since we have all this buffering designed especially to meet our > needs, and since the OS buffering is in the way, can someone explain to > me why postgresql would ever open a file without the O_DSYNC flag if the > platform supports it? It's more code, if

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread J. R. Nield
On Sun, 2002-06-23 at 12:10, Curt Sampson wrote: > > So what we would really need to implement, if we wanted to be more > efficient with trusted disk subsystems, would be the option of writing > to the log only the changed row or changed part of the row, or writing > the entire changed page. I do

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread J. R. Nield
On Sun, 2002-06-23 at 11:19, Tom Lane wrote: > Curt Sampson <[EMAIL PROTECTED]> writes: > > This should also allow us to disable completely the ping-pong writes > > if we have a disk subsystem that we trust. > > If we have a disk subsystem we trust, we just disable fsync on the > WAL and the per

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread Curt Sampson
On Sun, 23 Jun 2002, Tom Lane wrote: > Curt Sampson <[EMAIL PROTECTED]> writes: > > This should also allow us to disable completely the ping-pong writes > > if we have a disk subsystem that we trust. > > If we have a disk subsystem we trust, we just disable fsync on the > WAL and the performance

Re: [HACKERS] Suggestions for implementing IS DISTINCT FROM?

2002-06-23 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > I'm looking at implementing IS DISTINCT FROM, among other things. > ... > I was thinking to implement this by simply expanding these rules within > gram.y to be a tree of comparison tests. Please, please, do not do that. Make a new expression node tr

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread Tom Lane
Curt Sampson <[EMAIL PROTECTED]> writes: > This should also allow us to disable completely the ping-pong writes > if we have a disk subsystem that we trust. If we have a disk subsystem we trust, we just disable fsync on the WAL and the performance issue largely goes away. I concur with Bruce: th

Re: [HACKERS] ecpg and bison again

2002-06-23 Thread Thomas Lockhart
A couple of notes: ... > Then, update *only* the ecpg source directory to the branch: > cd pgsql/src/interfaces > cvs update -r ecpg_big_bison ecpg cvs will respect any changes you have made to the sources in your directory and the changes will be preserved in the move to the branch. Here is wh

Re: [HACKERS] ecpg and bison again

2002-06-23 Thread Thomas Lockhart
> > I'm happy setting up the branch if that would be helpful. Let me know if > > this is the way you want to proceed, and if so what you would like the > That would be nice. I do not really knwo cvs myself. Done. And here is how you would use it... > > branch to be called. > No idea. "new-bison"

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread Curt Sampson
On 23 Jun 2002, J. R. Nield wrote: > On Sat, 2002-06-22 at 19:17, Bruce Momjian wrote: > > J. R. Nield wrote: > > > One other point: > > > > > > Page pre-image logging is fundamentally the same as what Jim Grey's > > > book[1] would call "careful writes". I don't believe they should be in > > > t

Re: [HACKERS] ecpg and bison again

2002-06-23 Thread Michael Meskes
On Wed, Jun 19, 2002 at 06:23:24PM -0700, Thomas Lockhart wrote: > Michael, is this acceptable to you? If you use remote cvs, then you Yes, it is. > I'm happy setting up the branch if that would be helpful. Let me know if > this is the way you want to proceed, and if so what you would like the

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-23 Thread J. R. Nield
On Sat, 2002-06-22 at 19:17, Bruce Momjian wrote: > J. R. Nield wrote: > > One other point: > > > > Page pre-image logging is fundamentally the same as what Jim Grey's > > book[1] would call "careful writes". I don't believe they should be in > > the XLOG, because we never need to keep the pre-im

Re: [HACKERS] Code questions

2002-06-23 Thread Gavin Sherry
On Sun, 23 Jun 2002, Christopher Kings-Lynne wrote: > Hi All, > > Whereabouts in the code is the '*' expanded into the list of valid columns See the rule 'target_el' in gram.y. The SelectStmt node is processed further down the parser in analyze.c: see transformStmt(), transformSelectStmt() and

[HACKERS] Code questions

2002-06-23 Thread Christopher Kings-Lynne
Hi All,   Whereabouts in the code is the '*' expanded into the list of valid columns and also where are the columns specified in the select arguments (or whereever) checked for validity?   Chris