Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Gavin Sherry
On Mon, 4 Sep 2006, Joshua D. Drake wrote: I don't have a concrete proposal to make, but I do think that the current patch-queue process is not suited to the project as it stands today. Maybe if this issue-tracking stuff gets off the ground, we could let developers place ACK or NAK

Re: [HACKERS] [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`

2006-09-04 Thread Tom Lane
Greg Sabino Mullane [EMAIL PROTECTED] writes: SELECT *,has_schema_privilege(oid,'USAGE') FROM pg_namespace; Well, if you test it as a superuser, it's going to return TRUE every time. Exactly. So I'm not seeing how we can use USAGE as a reliable test for the case where a temporary table was

[HACKERS] Stressful time

2006-09-04 Thread Bruce Momjian
I realize this is a very stressful period for the community. We are pushing toward beta, I am pushing in patches, and I am one of the few people who know all the open items. We will get through this, folks. In two days, things will look much clearer. For those who are curious, here is the

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Joshua D. Drake
Gavin Sherry wrote: On Mon, 4 Sep 2006, Joshua D. Drake wrote: I don't have a concrete proposal to make, but I do think that the current patch-queue process is not suited to the project as it stands today. Maybe if this issue-tracking stuff gets off the ground, we could let developers place

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Hannu Krosing
Ühel kenal päeval, E, 2006-09-04 kell 16:51, kirjutas Joshua D. Drake: I don't have a concrete proposal to make, but I do think that the current patch-queue process is not suited to the project as it stands today. Maybe if this issue-tracking stuff gets off the ground, we could let

[HACKERS] Open items for 8.2

2006-09-04 Thread Bruce Momjian
Here are the open items for 8.2: http://momjian.postgresql.org/cgi-bin/pgopenitems This list will be continually updated until we release 8.2. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your

Re: [HACKERS] Sorry about the GIN docs :(

2006-09-04 Thread Christopher Kings-Lynne
Waaah! Don't apply that it's completely unfinished!!! And not to mention still has parts copied and pasted from GiST docs without modification. I believe Oleg or Teodor plans to finish it up On 9/5/06, Bruce Momjian [EMAIL PROTECTED] wrote: Patch applied. Thanks.

Re: [HACKERS] Optimizing prepared statements

2006-09-04 Thread Jeroen T. Vermeulen
On Mon, September 4, 2006 23:03, Tom Lane wrote: Ah. I think you're confusing the spectators by using predict when you should say match. You're looking for previously generated plans that have assumed parameter values matching the current query --- saying that the plan predicts a parameter

Re: [HACKERS] Sorry about the GIN docs :(

2006-09-04 Thread Bruce Momjian
Christopher Kings-Lynne wrote: Waaah! Don't apply that it's completely unfinished!!! And not to mention still has parts copied and pasted from GiST docs without modification. I believe Oleg or Teodor plans to finish it up On 9/5/06, Bruce Momjian [EMAIL PROTECTED] wrote: Patch

[HACKERS] stats collector is stuck on Windows

2006-09-04 Thread ITAGAKI Takahiro
Hi Hackers, I saw stats information was not updated sometimes when I tested HEAD on Windows. Once it happens, stats are not collected until server restarts. The condition seems to happen on high-CPU load. I can reproduce it in a few seconds using pgbench on the machine with one Pentium 4 with

Re: [HACKERS] Open items for 8.2

2006-09-04 Thread Alvaro Herrera
Bruce Momjian wrote: Here are the open items for 8.2: http://momjian.postgresql.org/cgi-bin/pgopenitems This list will be continually updated until we release 8.2. Thanks for the effort. A quickie: this item Store only active XIDs in subtransaction cache was already done:

Re: [HACKERS] Open items for 8.2

2006-09-04 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Here are the open items for 8.2: http://momjian.postgresql.org/cgi-bin/pgopenitems Had a bitmap-index patch arrived in my inbox this morning, as had been promised to me for three weekends running, I might have been willing to drop all else and

Re: [HACKERS] Open items for 8.2

2006-09-04 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: A quickie: this item Store only active XIDs in subtransaction cache was already done: I think Bruce is referring to the idea that you and I each arrived at recently, ie removing subcommitted subxact XIDs from the PGPROC cache if they hadn't stored any

Re: [HACKERS] Optimizing prepared statements

2006-09-04 Thread Josh Berkus
Jeroen, So with that out of the way, can anyone think of some good real-life examples of prepared statement usage that I can test against? Suggestions I've had include TPC, DBT2 (based on TPC-C), and pgbench, but what I'm really looking for is traces of invocations by real applications.

[HACKERS] Ding-dong, contrib is dead ...

2006-09-04 Thread Josh Berkus
Bruce, After some delay with server issues, I've loaded these contrib modules. Since I'm not hip to the magic required to remove a directory safely in CVS, please do it for me? Migrated to pgFoundry: adddepends (Greg) dbmirror (Steve Singer) dbase -- dbf2pg

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-04 Thread Andrew - Supernews
On 2006-09-05, Josh Berkus josh@agliodbs.com wrote: Migrated to pgFoundry: [...] userlock (Merlin) Userlock needs to go into core, not get removed; this was discussed in a previous let's clean up contrib/ thread. If it's not going into core in 8.2 then it needs to stay in contrib.

<    1   2