[HACKERS] pgxs regression

2004-11-13 Thread Joe Conway
I'm not sure exactly what has changed, nor at the moment how to fix it, but I'm finding that pgxs no longer works for PL/R or dblink. Error as follows: make: *** No rule to make target `/usr/local/pgsql-dev/lib/pgxs/src/makefiles/../../src/port/pg_config_paths.h', needed by `all-static-lib'.

Re: [HACKERS] [Pgsphere-dev] GIST index concurrency concern

2004-11-13 Thread Patrick Clery
Oleg, Daniel and I have both been collaborating on this structure for a while now. We are aware that GiST reads work very fast. But won't they be "paralyzed" when there are writes? Both of us are working on dating sites, and the main problem that concerns us is a very heavy traffic load. At thi

Re: [HACKERS] [Pgsphere-dev] GIST index concurrency concern

2004-11-13 Thread Chris Albertson
> > > I expect my site to sustain something around 1000-3000 new user > > > acquisitions per day, all of which will account for an insert > into 3 > > > GIST indices. Most people when they talk about a large load on a DBMS system talk about "transactins per second". As in "100 per second" Even

[HACKERS] IpcSemaphoreLock/Unlock and proc_exit on 7.2.6

2004-11-13 Thread Kris Jurka
I have an underpowered server running 7.2.6 that backs a website which occasionally gets hit by a bunch of traffic and starts firing off "FATAL 1: Sorry, too many clients already" messages. This is all as expected, but sometimes it just crashes. I had no clue what was going on until I checked t

Re: [HACKERS] CVS should die

2004-11-13 Thread Travis P
On Nov 13, 2004, at 6:20 PM, Thomas Hallgren wrote: "Question about rename" on [EMAIL PROTECTED] news://news.gmane.org:119/[EMAIL PROTECTED] Thomas (Hallgren): Unfortunately, my efforts to get Thunderbird to do something useful with that URL have been unsuccessful and I can't find the thread on

Re: [HACKERS] CVS should die

2004-11-13 Thread Andrew Dunstan
Thomas Hallgren wrote: GNU-Arch seems promising in some respects. It really can rename files and track them using an id, but it doesn't run on Windows without Cygwin (and even then not too well it seems). Personally I dislike the fact that the author seems somewhat religious about free software

Re: [HACKERS] CVS should die

2004-11-13 Thread Thomas Hallgren
Tom Lane wrote: ... There aren't any alternatives that are enough better than CVS to be worth the changeover effort. I've done some research over the last couple of days for a fairly big project where we face the challenges of breaking up a monolith into modules and consequently will be forced to

Re: [HACKERS] Relation does not exist

2004-11-13 Thread Tom Lane
"Brusser, Michael" <[EMAIL PROTECTED]> writes: > Our customer reported a problem with Postgres v.7.3.2 server on Solaris 8 > I asked them to run a quick query and it looks like the database is > corrupted: > select count (1) from t_revisioncontrol > ERROR: Relation 17236 does not exist If you are

Re: [HACKERS] [PATCHES] CVS should die

2004-11-13 Thread Anand Kumria
On Sat, 06 Nov 2004 11:53:13 +0100, Thomas Hallgren wrote: > Andrew McMillan wrote: >> Switching to Arch is more work, but it also offers a lot more benefits - >> including the opportunity for individuals to maintain their own trees, >> and be able to work out which patchsets from someone else's t

Re: [HACKERS] Romanian translation

2004-11-13 Thread Alin Vaida
On Mon, 08 Nov 2004 11:45:34 +0800, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > I'd like to translate postgres in Romanian, if nobody's doing this already. > > If you like, we'd love it if you translate phpPgAdmin as well :) > Where do I start? :) Alin Vaida

[HACKERS] src/tools/make_keywords

2004-11-13 Thread Gavin Sherry
Does this 'script' belong in the tree anymore? It relies on the existence of src/tools/SQL_keywords -- which no longer exists. gavin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Relation does not exist

2004-11-13 Thread Brusser, Michael
Title: Relation does not exist Our customer reported a problem with Postgres v.7.3.2 server on Solaris 8 I asked them to run a quick query and it looks like the database is corrupted: select count (1) from t_revisioncontrol ERROR: Relation 17236 does not exist   What can I do next? Thanks, M

Re: [HACKERS] A modest proposal: get rid of GUC's USERLIMIT

2004-11-13 Thread Bruce Momjian
Andrew McMillan wrote: > > > That sounds excellent - I hadn't realised that this workaround would be > > > possible, and indeed with this in place that will provide even better > > > control over the facility. > > > > OK, here is one vote for the ALTER USER/remove USERLIMIT croud, and you > > were

Re: [HACKERS] A modest proposal: get rid of GUC's USERLIMIT

2004-11-13 Thread Andrew McMillan
On Thu, 2004-11-11 at 23:05 -0500, Bruce Momjian wrote: > Andrew McMillan wrote: > -- Start of PGP signed section. > > On Wed, 2004-11-10 at 11:45 -0500, Tom Lane wrote: > > > Andrew McMillan <[EMAIL PROTECTED]> writes: > > > > When tracking down gnarly problems in heavily multi-user applications >