Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Gavin Sherry
On Sat, 21 Dec 2002, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > ... The reason I've been thinking about it is some people I've been > > working with at universities have a problem with students effectively > > DoSing shared installations to affect assessment. This was something

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > ... The reason I've been thinking about it is some people I've been > working with at universities have a problem with students effectively > DoSing shared installations to affect assessment. This was something > they had control over when they used Oracle

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Gavin Sherry
On Sat, 21 Dec 2002, Sander Steffann wrote: > Hi, > > > On the other hand, in a shared hosting environment, I don't think > > anyone would really like to have resource limits. What does it help > > if your online shop stops working because too many people are > > ordering stuff? IMHO it would be

Re: [HACKERS] PostgreSQL-R

2002-12-21 Thread Darren Johnson
Next, pg-r was originally based on 6.4, so what was changed for current pg versions when MV is used for CC? It seems that locking tuples via LockTable at Phase 1 is not required anymore, right? We haven't put those hooks in yet, so the current version is master/slave. Upon receiving local

Re: [HACKERS] plpgsql and index usage

2002-12-21 Thread Ryan Mahoney
>> Are you suggesting that I: >> a. use a different datatype in plpgsql or >> b. cast the values or >> c. change the data type in the table > >Yes ;-). Presumably (b) would be the least painful route, but any of >these would do the trick. It turns out that the text and char(5) we

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > It would be nice if there was a way to renice a connection. When it > comes to reporting it would be nice to have a handle for slowing a > backend down. > A patch for Linux would be quite easy ("SELECT nice_backend(int)") No

[HACKERS] How to write make rules for shared library and loadable library

2002-12-21 Thread Kenji Sugita
A libpq library on Mac OS X is made as a loadable library (bundle). Since a shared library version (dylib) of libpq does not exist, all programs which use libpq are always linked with a static version of libpq. Psql made by a current make rule: $ ls -l /opt/pgsql/7.3/bin/psql psql -rwxr-

Re: [HACKERS] plpgsql and index usage

2002-12-21 Thread Tom Lane
Ryan Mahoney <[EMAIL PROTECTED]> writes: >> Hmm ... evidently zipcode is declared as type char(5) (note the "bpchar" >> coercion). Is the plpgsql variable it's being compared to declared the >> same way? This could be ye olde cross-datatype-coercion problem. > Interesting! I think in plpgsql th

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Michael Paesold
Tom Lane <[EMAIL PROTECTED]> wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I've been thinking about resource management and postgres. I want to > > develop a user profile system (a-la oracle) which allows a DBA to > > restrict/configure access to system resources. This would allow a DBA t

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Hans-Jürgen Schönig
Personally I think that configuring things like that is definitely beyond the scope of an average administrator. However, there is one thing which would be useful for many applications: It would be nice if there was a way to renice a connection. When it comes to reporting it would be nice to ha