Re: [HACKERS] Changes to Contributor List

2003-11-05 Thread Bruce Momjian
. Marc? Remember? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-05 Thread Bruce Momjian
Emeritus or some such. Please make sure that Tom Lockhart and Vadim get listed that way, at least. I think the Emeritus word might be too hard for non-native English speakers, and even for less educated English speakers. -- Bruce Momjian| http://candle.pha.pa.us

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-05 Thread Bruce Momjian
Josh Berkus wrote: Guys, Oh, and how about we kill the Image Map of major developers? It's about 4 years out of date, and makes developers.postgresql.org load like molasses in January. Agreed. I think Jan is the only one who knows how to updated it. Jan? -- Bruce Momjian

Re: [HACKERS] Experimental ARC implementation

2003-11-06 Thread Bruce Momjian
many tuples the background write added to the freespace map, so it doesn't vacuum a table that doesn't need it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road

Re: [HACKERS] Experimental ARC implementation

2003-11-06 Thread Bruce Momjian
, or something like that, and the checkpoint process can read from there. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [HACKERS] Experimental ARC implementation

2003-11-06 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Have you considered having the background writer check the pages it is about to write to see if they can be added to the FSM, thereby reducing the need for vacuum? The 7.4 rewrite of FSM depends on the assumption that all the free

Re: [HACKERS] CVS open for development?

2003-11-06 Thread Bruce Momjian
Christopher Kings-Lynne wrote: Hey - now that we have a branch, is Bruce going to start committed the pgpatches2 list? Yes, once my email backlog is cleared --- probably early next week. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

Re: [HACKERS] Experimental ARC implementation

2003-11-07 Thread Bruce Momjian
Greg Stark wrote: Bruce Momjian [EMAIL PROTECTED] writes: Have you considered having the background writer check the pages it is about to write to see if they can be added to the FSM, thereby reducing the need for vacuum? Seems we would need to add a statistics parameter so

Re: [HACKERS] Performance features the 4th

2003-11-07 Thread Bruce Momjian
available that people can test, and he can improve it during the 7.5 development cycle with feedback from users. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ

Re: [HACKERS] Changes to Contributor List

2003-11-07 Thread Bruce Momjian
development team. We can help these companies also by providing speaking and trade show opportunities. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-07 Thread Bruce Momjian
not ? : is confusing use them a lot a.out is your program there's no U in foobar and, char (*(*x())[])() is a function returning a pointer to an array of pointers to functions returning char -- Jon S. Stumpf -- Bruce Momjian

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-07 Thread Bruce Momjian
=# create table foo (f1 int check (f1 0) check (f1 10)); ERROR: check constraint foo_f1 already exists Is this a TODO to fix? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Bruce Momjian
] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Bruce Momjian
use it. (I guess the idea is that all those Windows users can't be wrong. Oh, wait. . .) You have heard the term first adopters. These people want to be second adopters. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Bruce Momjian
dunno, I keep trying to keep the points off my hair. Maybe a developer of the month feature. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [HACKERS] Performance features the 4th

2003-11-07 Thread Bruce Momjian
Christopher Browne wrote: A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote: Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: As a matter of fact, people who have performance problems are likely to be the same who have upgrade problems

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: regression=# create table foo (f1 int check (f1 0) check (f1 10)); ERROR: check constraint foo_f1 already exists Is this a TODO to fix? Probably should be. I'd be inclined to try to fix it by generating

Re: [HACKERS] Experimental ARC implementation

2003-11-07 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: If the system is write-bound, the checkpointer will find that many dirty blocks that he has no time to nap and will burst them out as fast as possible anyway. Well, at least that's the theory. PostgreSQL with the non

Re: [HACKERS] Experimental ARC implementation

2003-11-07 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: What doing frequent fdatasync/fsync during a constant ongoing checkpoint will cause is to significantly lower the physical write storm happening at the sync(), which is causing huge problems right now. I don't see

[HACKERS] release timing

2003-11-07 Thread Bruce Momjian
What is the current schedule for RC2/final? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania

Re: [HACKERS] Foreign Key bug -- 7.4b4

2003-11-07 Thread Bruce Momjian
This this a new TODO? --- Jan Wieck wrote: Gaetano Mendola wrote: Bruce Momjian wrote: I can confirm this bug in CVS. Dropping the pkey from table b in fact drops the unique index from it. The SPI plan cached

[HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
Source code cleanup o Features/fixes -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
Marc G. Fournier wrote: On Fri, 7 Nov 2003, Bruce Momjian wrote: Here are the major things I do for the PostgreSQL project. Are there some items I should be doing more/less of? o Patches o TODO/FAQ o Email discussion, coordination o Win32 o Talks

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: o TODO/FAQ The FAQ might as well be maintained just like the rest of the documentation, i.e., by the development group as a whole. I encourage others to commit to the FAQ.html file in CVS. The only unique thing I do is to generate

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
Christopher Browne wrote: [EMAIL PROTECTED] (Bruce Momjian) writes: The worst was my upstairs hallway that had no light fixtures, so late at night if no other lights were on in the house, you had to walk down the hallway with your hands out in front of you so you didn't bump into anything

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-07 Thread Bruce Momjian
is a sequence generated unique value. So in Oracle system generated names are very opaque. I never saw this as a problem, since if you wanted a non-opaque name you could always assign one yourself. What, no dollar signs? :-) -- Bruce Momjian| http

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
developer (possibly two) to work on it for 320 hours. I am on it! I will talk to Joshua's guys every day if I can. I am going over the emails now that need attention. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Bruce Momjian
. I could do it, but I am not looking for additional work. I will continue to maintain the ordinary TODO list until we decide the bug system is going to work. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life

Re: [HACKERS] Call for port reports

2003-11-08 Thread Bruce Momjian
at 11:37:32AM -0400, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. I need this small patch so it properly detects I have unix domain sockets. Otherwise no problems. Kurt [ Attachment

Re: [HACKERS] Question for the developers.

2003-11-08 Thread Bruce Momjian
, without messing up with the postgres code. e.g. force the PostgreSQL to write to stable storage after an INSERT command. For stable storage, you mean disk storage? You need fsync for that, probably, but we already fsync our write-ahead log (WAL) on every commit. -- Bruce Momjian

Re: [HACKERS] Call for port reports

2003-11-08 Thread Bruce Momjian
I just tested gcc 2.95.3 on BSD/OS i386 and didn't see any change when using -g3 vs -g in the size of the binaries. --- Neil Conway wrote: On Sat, 2003-10-25 at 21:29, Bruce Momjian wrote: configure --enable-debug

Re: [HACKERS] Question about Threads

2003-11-08 Thread Bruce Momjian
on exit of the thread the postmaster blows up. Before we get into details is there any obvious reason postgres doesn't like to deal with threads? Yes, the backend code is not thread-safe. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610

Re: [HACKERS] Coding help

2003-11-08 Thread Bruce Momjian
---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [HACKERS] Bug fix for 7.4?

2003-11-08 Thread Bruce Momjian
/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us

[HACKERS] Annotated release notes

2003-10-30 Thread Bruce Momjian
? -- Tatsuo Ishii -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [HACKERS] Annotated release notes

2003-10-31 Thread Bruce Momjian
Kurt Roeckx wrote: On Thu, Oct 30, 2003 at 11:59:05PM -0500, Bruce Momjian wrote: OK, I have committed changes to release.sgml so most complex entries have a paragraph describing the change. You can see the result at: * Full support for IPv6 connections and IPv6 address data types

Re: [HACKERS] [DOCS] Annotated release notes

2003-10-31 Thread Bruce Momjian
Joe Conway wrote: Bruce Momjian wrote: http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-7-4 I need people to check this and help me with the items marked 'bjm'. I am confused about the proper text for those sections. Allow polymorphic SQL functions (Joe

Re: [HACKERS] How to tell if SQL function gets inlined?

2003-11-08 Thread Bruce Momjian
tree doesn't do the inlining, only the optimizer. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [HACKERS] Coding help

2003-11-09 Thread Bruce Momjian
); break; case T_String: default: n = makeStringConst(v-val.str, NULL); break; } return n; } which uses makeStringConst(). -- Bruce Momjian

Re: [HACKERS] [BUGS] PostgreSQL client has problems when libbind is

2003-11-07 Thread Bruce Momjian
)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] [BUGS] postgresql-7.4RC1 - unrecognized privilege type

2003-11-08 Thread Bruce Momjian
it can't hurt --- it changes failed queries for those that do initdb. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [HACKERS] [BUGS] postgresql-7.4RC1 - unrecognized privilege type

2003-11-08 Thread Bruce Momjian
: RERERENCES I now see the question Tom had was wether we force an initdb. Seems this query select * from information_schema.tables; is broken without it. I think we should fix it but not force an initdb --- information_schema is new and I am not sure how many people are using it. -- Bruce

Re: [HACKERS] Erroneous PPC spinlock code

2003-11-09 Thread Bruce Momjian
reviewed the documentation again (at: http://www-1.ibm.com/servers/esdd/articles/powerpc.html ) and it seems to agree with your opinion. I retract my comment, leave your code as-is. Cool. Thanks for checking. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
could pass it a list of our files and it would do all of them optimally. From what I have heard so far, sync() still seems like the most efficient method. I know it only schedules write, but with a sleep after it, it seems like maybe the best bet. -- Bruce Momjian| http

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
what big benefit do we get by having someone else write into the kernel buffer cache, except allowing a central place to fsync, and is it worth it considering that it might be impossible to configure a system where the writer process can keep up with all the backends? -- Bruce Momjian

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
file. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
. # #== [EMAIL PROTECTED] # ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
tuning here. I know the BSD's have trickle sync --- if we write the dirty buffers to kernel buffers many seconds before our checkpoint, the kernel might right them to disk for use and sync() will not need to do it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-09 Thread Bruce Momjian
do control our own buffer cache replacement strategy. Looking at the advantages/disadvantages, a large shared buffer cache looks pretty good to me. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Now, O_SYNC is going to force every write to the disk. If we have a transaction that has to write lots of buffers (has to write them to reuse the shared buffer) So make the background writer/checkpointer keeping the LRU head clean. I explained

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: I would be interested to know if you have the background write process writing old dirty buffers to kernel buffers continually if the sync() load is diminished. What this does is to push more dirty buffers into the kernel cache in hopes the OS

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
the only question was whether _flushall() fsync file descriptors that have been closed. Perhaps SRA keeps the file descriptors open until after the checkpoint, or does it fsync closed files with dirty buffers. Tatsuo? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Now, if we are sure that writes will happen only in the checkpoint process, O_SYNC would be OK, I guess, but will we ever be sure of that? This is a performance issue, not a correctness issue. It's okay for backends to wait

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Tom Lane wrote: Andrew Sullivan [EMAIL PROTECTED] writes: On Sun, Nov 02, 2003 at 01:00:35PM -0500, Tom Lane wrote: real traction we'd have to go back to the take over most of RAM for shared buffers approach, which we already know to have

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
. This is good, no question. The bigger question is removing sync() and using fsync() or O_SYNC for every write --- if we do that, the backends doing private write will have to fsync their writes too, meaning if the checkpointer can't keep up, we now have backends doing slow writes too. -- Bruce

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: Bruce Momjian wrote: Now, O_SYNC is going to force every write to the disk. If we have a transaction that has to write lots of buffers (has to write them to reuse the shared buffer) So make the background writer

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: Bruce Momjian wrote: I would be interested to know if you have the background write process writing old dirty buffers to kernel buffers continually if the sync() load is diminished. What this does is to push more dirty buffers

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
goffy idea would be if the OS does sync every 30 seconds to just write() the buffers and wait 30 seconds for the OS to issue the sync, then recycle the WAL buffers --- again, just a crazy thought. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
really has completely random access, then there is nothing to group. Agreed. This might force enough stuff out to disk the checkpoint/sync() would be OK. Jan, have you tested this? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Another idea --- if fsync() is slow because it can't find the dirty buffers, use write() to write the buffers, copy the buffer to local memory, mark it as clean, then open the file with O_SYNC and write it again. Yuck. Do we

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
update(4). Adding fsync might correct that. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Another idea --- if fsync() is slow because it can't find the dirty buffers, use write() to write the buffers, copy the buffer to local memory, mark it as clean, then open the file with O_SYNC and write it again. Yuck

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: If the background cleaner has to not just write() but write/fsync or write/O_SYNC, it isn't going to be able to clean them fast enough. It creates a bottleneck where we didn't have one before. We are trying

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: Zeugswetter Andreas SB SD wrote: One problem with O_SYNC would be, that the OS does not group writes any more. So the code would need to eighter do it's own sorting and grouping (256k) or use aio, or you won't be able

Re: [HACKERS] Proposal: psql force prompting on notty

2003-11-10 Thread Bruce Momjian
---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610

Re: [HACKERS] pgsql CVS build failure on Debian GNU/Linux 3.0

2003-11-10 Thread Bruce Momjian
Bison version: bison (GNU Bison) 1.35 TIA .strk; -- pallamondo.net -- take a look ! ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] Proposal: psql force prompting on notty

2003-11-10 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Are there further concerns with this patch? No, just getting to it now. Sorry. Peter didn't agree with this patch, and I have to concur with him that the need for it is unproven. Given that it is certainly not going into 7.4

Re: [HACKERS] [DOCS] Annotated release notes

2003-11-10 Thread Bruce Momjian
--- Joe Conway wrote: Bruce Momjian wrote: http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-7-4 I need people to check this and help me with the items marked 'bjm'. I am confused about the proper text

Re: [HACKERS] bufmgr code question

2003-11-11 Thread Bruce Momjian
-hackers/2002-11/msg00679.php http://archives.postgresql.org/pgsql-hackers/2002-11/msg00512.php regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian

Re: [HACKERS] Darwin Startup Script Patch

2003-11-11 Thread Bruce Momjian
-- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast

Re: [HACKERS] Successful proting report for 7.4beta4 on Irix and Altix

2003-11-12 Thread Bruce Momjian
for reporting successful ports? --Bob Right here. I just need uname -a from both machines. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [HACKERS] Background writer process

2003-11-13 Thread Bruce Momjian
the buffers to disk fast enough. I think the final solution will be to use fsync or O_SYNC. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [HACKERS] Background writer process

2003-11-13 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Kurt Roeckx wrote: On Thu, Nov 13, 2003 at 04:35:31PM -0500, Jan Wieck wrote: For sure the sync() needs to be replaced by the discussed fsync() of recently written files. And I think the algorithm how much and how often to flush can

Re: [HACKERS] Background writer process

2003-11-13 Thread Bruce Momjian
Kurt Roeckx wrote: On Thu, Nov 13, 2003 at 05:39:32PM -0500, Bruce Momjian wrote: Jan Wieck wrote: Bruce Momjian wrote: He found that write() itself didn't encourage the kernel to write the buffers to disk fast enough. I think the final solution will be to use fsync or O_SYNC

Re: [HACKERS] Background writer process

2003-11-13 Thread Bruce Momjian
outline? Or do we have any better proposals? Agreed. Background write() is a win on all all OS's. It is just the kernel to disk part we will have to have configurable, I think. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [HACKERS] Any more must fix issues for 7.4?

2003-11-13 Thread Bruce Momjian
will not be using initdb. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [HACKERS] Any more must fix issues for 7.4?

2003-11-13 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: Oh, I forgot about that. This leaves datetime.h and decimal.h in /pgsql/include. I don't see how 7.4.1 can fix that because people will not be using initdb. This has nothing to do with initdb. Right. I mean install isn't going to remove

Re: [HACKERS] conversion dumping patch

2003-11-13 Thread Bruce Momjian
pretty safe to apply, and I'm not 100% sure I still have a local copy of the patch, so I can't let it drift too much :( Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian

Re: [HACKERS] cvs head? initdb?

2003-11-13 Thread Bruce Momjian
It is not on by default? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [HACKERS] Background writer process

2003-11-14 Thread Bruce Momjian
writes for data files, I think this could work. fsync() doesn't return until the data is on the disk. It doesn't schedule the write then return, as far as I know. sync() does schedule the writes, I think, which can be bad, but we delay a little to wait for it to complete. -- Bruce Momjian

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Bruce Momjian
value to this and would encourage people to play with something that probably is is of little value. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Jan Wieck wrote: Yeah, there was a problem with *extreme* sharing ... the code tried to use the same buffer for multiple disk blocks at the same time, and somehow the backends did not agree on the correct content. But it's fixed and back

Re: [HACKERS] Background writer process

2003-11-14 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Shridhar Daithankar wrote: Having fsync for regular data files and sync for WAL segment a comfortable compramise? Or this is going to use fsync for all of them. I think we still need sync() for WAL because sometimes backends

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector

2003-11-14 Thread Bruce Momjian
fix, or hold this for 7.4.1? Must fix, I believe, especially if it is the same function call sequence used by the postmaster so we have a high probability it will work on all platforms. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610

Re: [HACKERS] oh dear ...

2003-11-14 Thread Bruce Momjian
this to 7.4? I guess the question is whether we would fix this in a minor release, and I think the answer it yes, so we can fix it now. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Bruce Momjian
comparisons) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [HACKERS] cvs head? initdb?

2003-11-15 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: Our philosophy has never been to give people configuration options just in case they might be valuable to them. If we did that, we would be like Oracle. We give config options only if we can't decide the best default. For testing, you can

Re: [CORE] [HACKERS] 7.4RC2 regression failur and not running stats

2003-11-15 Thread Bruce Momjian
please check CVS HEAD. Tom has just applied the patch fix this and we could use more testers. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [HACKERS] Proposal for a cascaded master-slave replication system

2003-11-12 Thread Bruce Momjian
licensing has made it abundantly clear. MySQL just isn't in the same league, and probably will never be. What people want is Informix/Oracle/MS-SQL = PostgreSQL. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life

Re: [HACKERS] Proposal for a cascaded master-slave replication system

2003-11-13 Thread Bruce Momjian
projects. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [HACKERS] heads up -- subtle change of behavior of new initdb

2003-11-14 Thread Bruce Momjian
(); + } /* Create required subdirectories */ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life

Re: [PATCHES] [HACKERS] heads up -- subtle change of behavior of new

2003-11-14 Thread Bruce Momjian
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: darnit! patch attached. Applied with correction (you got the return-value check backwards) and further work to deal reasonably with error conditions occurring in check_data_dir. Tom applied it before I could. -- Bruce Momjian

Re: [HACKERS] cvs head? initdb?

2003-11-16 Thread Bruce Momjian
for the buck in creating the background writer. Better Journalistic Manipulator == BJM. :-) _B_ruce _J_. _M_omjian. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ

Re: [HACKERS] start of transaction (was: Re: [PERFORM] Help with count(*))

2003-11-16 Thread Bruce Momjian
pretty arbitrary to me. I can't think of any time-based interface that has that API. And what if a trigger called now() in an earlier query and you didn't even know about it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [HACKERS] [pgsql-hackers-win32] [PATCHES] SRA Win32 sync() code

2003-11-17 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Where am I wrong? I don't think any of this is relevant. There are a certain number of blocks we have to get down to disk before we can declare a transaction committed, and there are a certain number that we have to get down to disk

Re: [HACKERS] Background writer process

2003-11-17 Thread Bruce Momjian
or just the buffers it wrote. I think this is these are the basics of the current discussion. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [HACKERS] start of transaction (was: Re: [PERFORM] Help with count(*))

2003-11-17 Thread Bruce Momjian
Hannu Krosing wrote: Bruce Momjian kirjutas E, 17.11.2003 kell 02:31: Defining now() as the first call seems pretty arbitrary to me. I can't think of any time-based interface that has that API. And what if a trigger called now() in an earlier query and you didn't even know about

Re: [HACKERS] Release now live ...

2003-11-17 Thread Bruce Momjian
Tommi Maekitalo wrote: Hi, in doc/man1/psql.1 there is a line: Welcome to psql 7.4beta5, the PostgreSQL interactive terminal. Yea, sorry. It pulls the version number from the time those man pages were built. Not sure how we could have prevented it. -- Bruce Momjian

Re: [HACKERS] logical column position

2003-11-17 Thread Bruce Momjian
. If we don't get that working you might want to use the 1000 gap idea because it doesn't cause this problem, and we don't support 1600 columns, so a 1000 gap shouldn't cause a problem and can be modified later. If they hit 999 updates, just tell them to dump/reload the table. -- Bruce Momjian

Re: [HACKERS] logical column position

2003-11-17 Thread Bruce Momjian
a nifty feature. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

  1   2   3   4   5   6   7   8   9   10   >