Re: [HACKERS] Optimizer Question/Suggestion

2002-11-03 Thread Hannu Krosing
Philip Warner kirjutas P, 03.11.2002 kell 06:30: At 09:36 AM 2/11/2002 -0500, Tom Lane wrote: Why not do frequent non-full vacuums on only that table, perhaps every five minutes or so? That's certainly the direction that development is headed in (we just haven't automated the vacuuming

Re: [HACKERS] Optimizer Question/Suggestion

2002-11-03 Thread Philip Warner
At 03:25 PM 3/11/2002 +0500, Hannu Krosing wrote: a separate backend in a loop that kept doing VACUUM TABLE with only 5 seconds sleep between Good grief! I thought 5 minutes was bad enough. Can't wait for b/g vacuum. Thanks for the input; I'll wait for a day or so to get some figures as you

Re: [HACKERS] Optimizer Question/Suggestion

2002-11-03 Thread Hannu Krosing
Philip Warner kirjutas P, 03.11.2002 kell 15:41: At 03:25 PM 3/11/2002 +0500, Hannu Krosing wrote: a separate backend in a loop that kept doing VACUUM TABLE with only 5 seconds sleep between Good grief! I thought 5 minutes was bad enough. Can't wait for b/g vacuum. Thanks for the input;

[HACKERS] my application

2002-11-03 Thread Kafka
Hello, sorry, if this question must be in another group. I use Visual C++ and driver, connect to PostgeSQL. Application works fine, but some time I have problem. My application read data from another SQL server and tranfers to PostgreSQL server. But sometime, my client hangs up, when it makes new

[HACKERS] Compile problem on FreeBSD/Alpha

2002-11-03 Thread Christopher Kings-Lynne
CVS Tip: gmake[3]: Entering directory `/home/chriskl/pgsql-head/src/backend/bootstrap' gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -I. -I../../../src/include -c -o bootparse.o bootparse.c -MMD In file included from bootscanner.l:43, from bootparse.y:339:

Re: [HACKERS] Compile problem on FreeBSD/Alpha

2002-11-03 Thread Doug McNaught
Christopher Kings-Lynne [EMAIL PROTECTED] writes: chriskl@alpha:~/pgsql-head$ bison --version GNU Bison version 1.28 Upgrade Bison to 1.50 or later. Earlier versions can't handle the size of the current grammar. -Doug ---(end of broadcast)---

Re: [HACKERS] missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3

2002-11-03 Thread Tommi Mäkitalo
Hi, not really. I can cast it away. Ugly, but it works. But I think it isn't that big, that it cant go into 7.3? It is really very local. It doesn't change anything. It should be very save. I just write another C++-interface and c++ is more strict in checking. By the way: I think there are

Re: [HACKERS] missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3

2002-11-03 Thread Bruce Momjian
Tommi Mäkitalo wrote: Hi, not really. I can cast it away. Ugly, but it works. But I think it isn't that big, that it cant go into 7.3? It is really very local. It doesn't change anything. It should be very save. We are sort of in a code freeze so though it is little, I will keep it for

Re: [HACKERS] missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3

2002-11-03 Thread Bruce Momjian
This has been saved for the 7.4 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- Tommi Mäkitalo wrote: Hi, I just discovered, that there is missing a const when passing a buffer to PQescapeBytea

[HACKERS] Is my Internet connection slow

2002-11-03 Thread Bruce Momjian
I have been serving my email/web/ftp using a 56k modem for the past two months at candle.pha.pa.us (which is also momjian.postgresql.org). Are people finding it slow? I am going to be getting a higher speed connection and I need to know so I can choose the proper upgrade speed. -- Bruce

Re: [HACKERS] Is my Internet connection slow

2002-11-03 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I have been serving my email/web/ftp using a 56k modem for the past two months at candle.pha.pa.us (which is also momjian.postgresql.org). Are people finding it slow? Yeah. I don't use your docs build anymore unless I really have to... the one at

[HACKERS] Spanish version of the PostgreSQL Advocacy and Marketing site is ready

2002-11-03 Thread Justin Clift
Hi everyone, Thanks to Alvaro Herrera [EMAIL PROTECTED], the Spanish translation of the PostgreSQL Advocacy and Marketing site is now completed and ready for public use: http://advocacy.postgresql.org/?lang=es :-) Anyone else want to translate it for other languages? :) Regards and best

Re: [HACKERS] Is my Internet connection slow

2002-11-03 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I have been serving my email/web/ftp using a 56k modem for the past two months at candle.pha.pa.us (which is also momjian.postgresql.org). Are people finding it slow? Yeah. I don't use your docs build anymore unless I really have

[HACKERS] SQL99 compatibility list

2002-11-03 Thread Christopher Kings-Lynne
Hi, Seems there's a few errors in the SQL99 compatibility list. For one, it says we support WITH CHECK OPTION on views which I'm pretty sure we don't. Also Referential MATCH types? We don't do partial I think. I think someone might have to give the list a once-over...? Chris

Re: [HACKERS] missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3

2002-11-03 Thread Tommi Maekitalo
Hi, my other problems in PQescapeBytea disappeared. I can't find them any more. I did some testing and all is fine. Tommi Am Sonntag, 3. November 2002 15:50 schrieb Bruce Momjian: Tommi Mäkitalo wrote: Hi, not really. I can cast it away. Ugly, but it works. But I think it isn't