Re: [HACKERS] pg_restore stuck in a loop?

2005-04-28 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: On Tue, 2005-04-26 at 23:22 -0400, Tom Lane wrote: You tell us ;-). You've got the test case, attach to it with a debugger and find out what it's doing. I wasn't entirely sure how to catch it in action so I just used CTRL+C to interrupt the pg_restore

Re: [HACKERS] Increased company involvement

2005-04-28 Thread Thomas Hallgren
Joshua D. Drake wrote: However, there was a lot of coordination that happened with Fujitsu that I don't see happening with the current companies involved. Companies are already duplicating work that is also done by community members or by other companies. That is bound to happen no matter what.

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Hannu Krosing
On K, 2005-04-27 at 22:21 -0700, Joshua D. Drake wrote: However, there was a lot of coordination that happened with Fujitsu that I don't see happening with the current companies involved. Companies are already duplicating work that is also done by community members or by other companies.

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Bruce Momjian
Hannu Krosing wrote: Which is why (hate to beat a dead horse) many OSS projects have moved to 6 month release cycles. Well, it is a two-sided thing. On one hand, businesses usually need new features yesterday, but on the other hand, business would loose most of the benefit of getting the

[HACKERS] Feature freeze date for 8.1

2005-04-28 Thread Bruce Momjian
You might remember that when we released 8.0, the plan was to have a 12-month development cycle for 8.1, unless there were Win32 problems that required complex fixes, in which case we would have a shorter 8.1 cycle. Well the good news is that there have been almost no Win32 problems, but the

Re: [HACKERS] [proposal] protocol extension to support loadable stream filters

2005-04-28 Thread Tom Lane
Brent Verner [EMAIL PROTECTED] writes: Would it be sane to recognize a specific PG_PROTOCOL_MAJOR to enter the filter-negotiation process? PG_PROTOCOL_MINOR would then be used to lookup and call a ptr to the filter's create() in CreateStreamFilter... Looks reasonable enough to me ...

Re: [HACKERS] Feature freeze date for 8.1

2005-04-28 Thread Bruno Wolff III
On Thu, Apr 28, 2005 at 09:02:40 -0400, Bruce Momjian pgman@candle.pha.pa.us wrote: Well the good news is that there have been almost no Win32 problems, but the other good news is that we are getting a lot of powerful features for 8.1 already: You forgot to list the indexed aggregate feature

Re: [HACKERS] Feature freeze date for 8.1

2005-04-28 Thread Rob Butler
As a user, I would definetly prefer to see 8.1 released sooner with the feature set listed below, than wait another 6+ months for a few other features. Additionally, the beta may go smoother/faster if you don't have too many huge features going in at once. Just my opinion. Later Rob --- Bruce

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Robert Treat
On Thursday 28 April 2005 01:48, Joshua D. Drake wrote: Do companies want to write for Blue Hat PostgreSQL and Suza PostgreSQL because that might be what happens if we don't stay organized? In fact, it might have be happening already. Well that depends... If the companies are writing for

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

2005-04-28 Thread Mischa Sandberg
Quoting Josh Berkus josh@agliodbs.com: Perhaps I can save you some time (yes, I have a degree in Math). If I understand correctly, you're trying extrapolate from the correlation between a tiny sample and a larger sample. Introducing the tiny sample into any decision can only produce a

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Magnus Hagander
However, there was a lot of coordination that happened with Fujitsu that I don't see happening with the current companies involved. Companies are already duplicating work that is also done by community members or by other companies. That is why we have 80 Linux distributions

Re: [HACKERS] [JDBC] Statement Timeout and Locking

2005-04-28 Thread Tom Lane
Kris Jurka [EMAIL PROTECTED] writes: This actually is the problem. It works as three separate statements, but fails as one. The server doesn't seem to recognize the SET when other commands come in before Sync. [ reads some code... ] The problem is that postgres.c only inspects

Re: [HACKERS] Feature freeze date for 8.1

2005-04-28 Thread Andreas Pflug
Bruce Momjian wrote: You might remember that when we released 8.0, the plan was to have a 12-month development cycle for 8.1, unless there were Win32 problems that required complex fixes, in which case we would have a shorter 8.1 cycle. Well the good news is that there have been almost no Win32

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Andy Astor
However, there was a lot of coordination that happened with Fujitsu that I don't see happening with the current companies involved. Companies are already duplicating work that is also done by community members or by other companies. That is bound to happen no matter what. Look at plJava

Re: [HACKERS] [JDBC] Statement Timeout and Locking

2005-04-28 Thread Markus Schaber
Hi, Tom, Tom Lane schrieb: Anyway the short-term answer for Markus is don't do it that way. We ought to think about making the backend's behavior more consistent, though. I'll split the query into three. Having it in one query just was a convenience here. Thanks, Markus

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

2005-04-28 Thread Marko Ristola
First I will comment my original idea. Second I will give another improved suggestion (an idea). I hope, that they will be useful for you. (I don't know, wether the first one was useful at all because it showed, that I and some others of us are not very good with statistics :( ) I haven't looked

Re: [HACKERS] [COMMITTERS] pgsql: Implement sharable row-level locks, and use them for foreign key

2005-04-28 Thread Alvaro Herrera
On Thu, Apr 28, 2005 at 06:47:18PM -0300, Tom Lane wrote: Implement sharable row-level locks, and use them for foreign key references to eliminate unnecessary deadlocks. This commit adds SELECT ... FOR SHARE paralleling SELECT ... FOR UPDATE. The implementation uses a new SLRU data

Re: [HACKERS] [proposal] protocol extension to support loadable stream filters

2005-04-28 Thread Brent Verner
[2005-04-28 10:00] Tom Lane said: | Brent Verner [EMAIL PROTECTED] writes: |Would it be sane to recognize a specific PG_PROTOCOL_MAJOR | to enter the filter-negotiation process? PG_PROTOCOL_MINOR | would then be used to lookup and call a ptr to the filter's | create() in

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Josh Berkus
Hannu, But I too expected the discussion to take place on pgsql-hackers, not some half-hidden mailinglist on pgfoundry. Or at least an announcement of that mailinglist to be made on pgsql-hachers. Yeah, we should announce the mailing list. Actually, I did direct e-mail a bunch of people

Re: [HACKERS] [COMMITTERS] pgsql: Implement sharable row-level locks, and use them for foreign key

2005-04-28 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: One point I didn't quite understand was the business about XLogging heap_lock_tuple. I had to reread your mail to -hackers on this issue several times to get it (as you can see I don't fully grok the WAL rules). Now, I believe that heap_mark4update

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

2005-04-28 Thread Bruce Momjian
Robert Treat wrote: ISTM the allure of differentiation and branding is going to be too strong for us to prevent such things. An easy way to differentiate is to add some proprietary/unique extension to the main code and then package that up. If you have to have all your extensions be put

Re: [HACKERS] [PERFORM] Distinct-Sampling (Gibbons paper) for Postgres

2005-04-28 Thread Josh Berkus
Now, if we can come up with something better than the ARC algorithm ... Tom already did. His clock-sweep patch is already in the 8.1 source. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to