[HACKERS] Need help in installing postgresql 8.1.2 on Windows

2006-01-21 Thread Sarvjot Kaur
Sir I am trying to install Globus Toolkit4 on Windows machine. Postgresql8.1.2 is required software for installing GT4. But i cant get installation steps from anywhere.. Please help me and do reply Thanks Sarvjot Yahoo! Photos – Showcase holiday pictures in hardcover Photo Books. You desig

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 22:30 +0100, Tino Wildenhain wrote: > Rod Taylor schrieb: > > On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > > > >>Rod Taylor wrote: > >> > >>>Is there any way of bumping this limit or am I stuck breaking up the > >>>transaction? > >> > >>Wow, I never heard of any

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tino Wildenhain
Rod Taylor schrieb: > On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > >>Rod Taylor wrote: >> >>>Is there any way of bumping this limit or am I stuck breaking up the >>>transaction? >> >>Wow, I never heard of anyone reaching the limit :-( Sorry, you are >>stuck (short of changing Comman

Re: [HACKERS] makesign() broken in tsearch2

2006-01-21 Thread Teodor Sigaev
Oh, good, that makes it easy. Do you want to apply the fix or shall I? I will have normal access to Internet only on Monday. It can easy wait for me :) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desir

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > Does a subtransaction receive an independent command counter? No such luck, and IIRC that would not be easy at all to change :-( regards, tom lane ---(end of broadcast)--- TIP 6: expl

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Would it be possible to increment the command counter only for commands > that do updates? Probably that would work, but I'm unsure whether we have infrastructure that would let you detect that reliably... regards, tom lane

Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Tom Lane
Rick Gigger <[EMAIL PROTECTED]> writes: >> By default, autovacuum isn't even turned on --- you have to enable it >> and also stats_row_level if you want to use autovac. I don't have >> enough experience with it to say whether the other settings are >> adequate. > Yes, I realized this not long aft

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > Rod Taylor wrote: > > Is there any way of bumping this limit or am I stuck breaking up the > > transaction? > > Wow, I never heard of anyone reaching the limit :-( Sorry, you are > stuck (short of changing CommandId to 64 bits, which woul

Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Rick Gigger
Rick Gigger <[EMAIL PROTECTED]> writes: 2) I didn't touch the Vacuum delay, background writer or autovacuum settings because I wasn't familiar enough with them. Are the default values very restricting? By default, autovacuum isn't even turned on --- you have to enable it and also stats_row_lev

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Heikki Linnakangas
On Sat, 21 Jan 2006, Alvaro Herrera wrote: Rod Taylor wrote: Is there any way of bumping this limit or am I stuck breaking up the transaction? Wow, I never heard of anyone reaching the limit :-( Sorry, you are stuck (short of changing CommandId to 64 bits, which would bloat your tables consi

Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Tom Lane
Rick Gigger <[EMAIL PROTECTED]> writes: > 2) I didn't touch the Vacuum delay, background writer or autovacuum > settings because I wasn't familiar enough with them. Are the default > values very restricting? By default, autovacuum isn't even turned on --- you have to enable it and also stats_

Re: [HACKERS] makesign() broken in tsearch2

2006-01-21 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: >> It looks to me like the values calculated by this routine end up on >> disk, and therefore we can't fix it without forcing an initdb, or >> at least REINDEX of all affected indexes. Is that correct? >> > No. query_gist.c exists only in HEAD branch. O

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Alvaro Herrera
Rod Taylor wrote: > Is there any way of bumping this limit or am I stuck breaking up the > transaction? Wow, I never heard of anyone reaching the limit :-( Sorry, you are stuck (short of changing CommandId to 64 bits, which would bloat your tables considerably ...) -- Alvaro Herrera

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > Rod Taylor wrote: > > Is there any way of bumping this limit or am I stuck breaking up the > > transaction? > > Wow, I never heard of anyone reaching the limit :-( Sorry, you are > stuck (short of changing CommandId to 64 bits, which woul

[HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
Is there any way of bumping this limit or am I stuck breaking up the transaction? ERROR: cannot have more than 2^32-1 commands in a transaction -- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] makesign() broken in tsearch2

2006-01-21 Thread Teodor Sigaev
the bottom half might be messed up too. So we are failing to exploit the full intended "sign" space, which presumably is costing something in index efficiency. You are absolutly right. My fault. It looks to me like the values calculated by this routine end up on disk, and therefore we ca

[HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Rick Gigger
While this little bug was a menace to me at a bad time my biggest problem was that I didn't have a good enough vacuum strategy and my reasonable sized database became the size of the world. At that point it couldn't be vacuumed without jamming up the whole server. So I have some questions