Re: [HACKERS] DBT-2 pulls PostgreSQL from CVS for STP

2004-01-14 Thread Jan Wieck
Neil Conway wrote: Tom Lane <[EMAIL PROTECTED]> writes: This is a bug Jan introduced recently --- he forgot to modify the shared memory setup code to allow space for the new data structures used by ARC. Jan, would you mind fixing that soon? It's getting in people's way. Jan had asked that I incl

Re: [HACKERS] DBT-2 pulls PostgreSQL from CVS for STP

2004-01-14 Thread Neil Conway
Tom Lane <[EMAIL PROTECTED]> writes: > This is a bug Jan introduced recently --- he forgot to modify the > shared memory setup code to allow space for the new data structures > used by ARC. Jan, would you mind fixing that soon? It's getting in > people's way. Jan had asked that I include the fix

Re: [HACKERS] DBT-2 pulls PostgreSQL from CVS for STP

2004-01-14 Thread Tom Lane
[EMAIL PROTECTED] writes: > A test I ran the other day failed because the database ran out of shared > memory. This is a bug Jan introduced recently --- he forgot to modify the shared memory setup code to allow space for the new data structures used by ARC. Jan, would you mind fixing that soon?

[HACKERS] Strange COPY from problem (resent)

2004-01-14 Thread ohp
Hi all, I resend this mail because I didn't have any answer; I still did'nt find any solution, the same line is ALWAYS failing although I see no error. Of course, I can't post the dump 'cause it's over 200 Megs but if some one wants to make test (need to be postgres), I can arrange to put it on

[HACKERS] DBT-2 pulls PostgreSQL from CVS for STP

2004-01-14 Thread markw
I've added a new test parameter so that the test on STP can pull from CVS. When requesting a test, use the flag '-x 1' in the "Optimal Script Parameters" box and the test will pull from CVS. A test I ran the other day failed because the database ran out of shared memory. I was going to try to pa

Re: [HACKERS] failed to re-find parent key

2004-01-14 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > Ok, that seems to have fixed it, so my next question is how did it get > corrupt? The nearest culprit seems to be whatever you did in analyze.c ;-). It's not obvious to me how analyze.c would manage to mess up an index, since it's nowhere near the index-h

Re: VACUUM delay (was Re: [HACKERS] What's planned for 7.5?)

2004-01-14 Thread Jan Wieck
Tom Lane wrote: Christopher Browne <[EMAIL PROTECTED]> writes: "Stephen" <[EMAIL PROTECTED]> writes: Any chance we'll see the VACUUM delay patch (throttle) get into 7.5? The hope, in 7.5, is to have ARC, which is the "super-duper-duper" version, working. Actually, I'm not sure that ARC should be c

Re: [HACKERS] Encoding problems in PostgreSQL with XML data

2004-01-14 Thread Merlin Moncure
Hannu Krosing wrote: > I hope that real as-needed-column-by-column translation will be used > with bound argument queries. > > It also seems possible to delegate the encoding changes to after the > query is parsed, but this will never work for EBCDIC and other funny > encodings (like rot13 ;). >

Re: [HACKERS] failed to re-find parent key

2004-01-14 Thread Dave Cramer
Ok, that seems to have fixed it, so my next question is how did it get corrupt? Dave On Tue, 2004-01-13 at 23:07, Tom Lane wrote: > Dave Cramer <[EMAIL PROTECTED]> writes: > > Actually the hack checks for oids, and doesn't make the index, if there > > isn't an oid in the table, so I tried it with

Re: [HACKERS] Suggestions for analyze patch required...

2004-01-14 Thread Mark Cave-Ayland
Hi Tom, > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 18:08 > To: Mark Cave-Ayland > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Suggestions for analyze patch required... > > > "Mark Cave-Ayland" <[EMAIL PROTECTED]> writes: > > I agree that