Re: [HACKERS] Nasty problem in hash indexes

2003-08-29 Thread scott.marlowe
On Fri, 29 Aug 2003, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > On Thu, 28 Aug 2003, Neil Conway wrote: > >> On Thu, Aug 28, 2003 at 05:37:39PM -0400, Tom Lane wrote: > >>> Who's to say? We've found bugs in the btre

Re: [HACKERS] Nasty problem in hash indexes

2003-08-29 Thread scott.marlowe
On Thu, 28 Aug 2003, Neil Conway wrote: > On Thu, Aug 28, 2003 at 05:37:39PM -0400, Tom Lane wrote: > > > If so, then how many other bugs are lurking in the hash index code > > > waiting to bite? > > > > Who's to say? We've found bugs in the btree logic recently, > > too. > > I'd rather print

Re: [HACKERS] Bumping block size to 16K on FreeBSD...

2003-08-28 Thread scott.marlowe
On Thu, 28 Aug 2003, Marc G. Fournier wrote: > > > On Thu, 28 Aug 2003, Thomas Swan wrote: > > > Has anyone looked at changing the default block size across the board > > and what the performance improvements/penalties might be? Hardware has > > changed quite a bit over the years. > > I *thin

Re: [HACKERS] Nasty problem in hash indexes

2003-08-28 Thread scott.marlowe
On Thu, 28 Aug 2003, Tom Lane wrote: > I've traced through the failure reported here by Markus Kräutner: > http://archives.postgresql.org/pgsql-hackers/2003-08/msg01132.php > > What is happening is that as the UPDATE adds tuples (all with the same > hash key value) to the table, the hash bucket b

Re: [HACKERS] Oversight?

2003-08-14 Thread scott.marlowe
On Tue, 12 Aug 2003, Christopher Kings-Lynne wrote: > > > rbt=3D# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED; > > > ERROR: syntax error at or near "ALL" at character 32 > > > rbt=3D# ALTER USER rbt SET CONSTRAINTS =3D DEFERRED; > > > ERROR: "constraints" is not a recognized option > > > > "SET

Re: [HACKERS] logging stuff

2003-08-06 Thread scott.marlowe
On Tue, 5 Aug 2003, Andrew Dunstan wrote: > > (Responding to the deafening silence regarding my posts a couple of days > ago about logging dbnames and disconnections) ;-) > > The dbname patch is now done. If nobody objects to the format > ("[db:yourdbname]") I'll submit it - I did it that way

Re: [HACKERS] logging stuff

2003-08-05 Thread scott.marlowe
If we're looking at this, we might want to look at how apache does it with it's customlog feature. This allows you to first define custom log types, then set them according to which virtual server you're setting up. I could see that being nice so you could create a couple of different custom l

Re: [HACKERS] Thread-safe configuration option appears to

2003-08-04 Thread scott.marlowe
On Mon, 4 Aug 2003, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > SCO is thinking SERIOUSLY about shipping PG on the Platform as > > part of their extensions offering. > > Why, how nice of them. I don't intend to lift a finger to help. I don't know, I can think of ONE

Re: [HACKERS] "truncate all"?

2003-08-04 Thread scott.marlowe
I agree, a plain truncate blasting a whole database is a very bad thing. however, "truncate with cascade" would be quite useful. On Mon, 4 Aug 2003, Bruce Momjian wrote: > > This this a TODO? Keep in mind if we follow the syntax of VACUUM and > (7.4) CLUSTER, that the all-database truncate wou

Re: [HACKERS] ACCESSING POST GRESQL DATABASE THRU MFCOBOL

2003-08-01 Thread scott.marlowe
On Tue, 29 Jul 2003, vajjhala chakravarthi wrote: > HI > > I am running MFcobol on a linux machine which is > having Postgresql. can I access pgsql database thru > mfcobol. > If it is possible where can I get odbc drivers and > what is the procedure help me ODBC driver is available here: http:/

Re: [HACKERS] Really odd corruption problem: cannot open pg_aggregate:

2003-07-24 Thread scott.marlowe
On Thu, 24 Jul 2003, Adam Haberlach wrote: > So, one of the many machines that I support seems to have developed > an incredibly odd and specific corruption that I've never seen before. > > Whenever a query requiring an aggregate is attempted, it spits out: > cannot open pg_aggregate: No su

Re: [HACKERS]

2003-07-23 Thread scott.marlowe
On Wed, 23 Jul 2003, Jenny - wrote: > Iam trying to acquire rowlevel locks in postgresql. I try doing this: >  'select * from students where name='Larry' for update; > But by looking at the holding array of proclock , I've noticed that by doing this > only > AccessShareLock gets acquired which is

Re: [HACKERS] php with postgres

2003-07-22 Thread scott.marlowe
On Mon, 21 Jul 2003, Bruce Momjian wrote: > Jan Wieck wrote: > > Bruce Momjian wrote: > > > Marcus B?rger wrote: > > >> BM> Marcus, would you check if PHP is using RESET ALL when passing > > >> BM> persistent connection to new clients? We added that capability a few > > >> BM> releases ago, speci

Re: [HACKERS] Archives

2003-07-17 Thread scott.marlowe
On Wed, 16 Jul 2003, Alvaro Herrera wrote: > On Wed, Jul 16, 2003 at 03:35:51PM -0500, Larry Rosenman wrote: > > > --On Wednesday, July 16, 2003 16:31:24 -0400 Alvaro Herrera > > <[EMAIL PROTECTED]> wrote: > > > > >On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote: > > >>Does anyone h

Re: [HACKERS] Hyperthreading or not?

2003-07-16 Thread scott.marlowe
On Wed, 16 Jul 2003, Mendola Gaetano wrote: > Hi all, > we are going to move our production postgres box ( on Linux ) > in a new machine, I'm wondering if I shall leave the Hyperthreading > feature on or disable it. The newer kernels are hyper-threading aware. No idea how much faster that migh

Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread scott.marlowe
On Wed, 16 Jul 2003, Andrew Sullivan wrote: > On Tue, Jul 15, 2003 at 06:35:38PM -0400, Robert Treat wrote: > > is this code really a "replacement" for rserv? There has been work on > > rserv in contrib that I'm guessing was not used in the commercial > > version. are we better off calling this rs

Re: [HACKERS] initcap incompatibility issue

2003-07-09 Thread scott.marlowe
On Wed, 9 Jul 2003 [EMAIL PROTECTED] wrote: > > As far as I can tell, not capitalizing the first letter after a dash > > is the only inconsistency with Oracle's implementation of this function. > > Wrong again. Oracle also capitalizes the first letter after a comma, > semicolon, colon, period,

Re: [HACKERS] Are we backwards on the sign of timezones?

2003-07-03 Thread scott.marlowe
The date / time of your message at the top of my email client was: Thu, 03 Jul 2003 13:18:09 -0400 And most of my stuff is -0600 or -0700 and I live in Colorado. Every instance I've seen that shows the correction for me has been a -0600/-0700 depending on daylight savings. So, it looks like t

Re: [HACKERS] dblink for Oracle - question ...

2003-07-01 Thread scott.marlowe
On Mon, 23 Jun 2003, Hans-Jürgen Schönig wrote: > A few days ago I have posted a pre-beta version of dblink_ora which is > supposed to solve some problems we had here at Cybertec (getting data > from an Oracle DB and merge it with PostgreSQL). I have implemented a > simple piece of code (more p

Re: [HACKERS] When will table partitioning be available..

2003-06-30 Thread scott.marlowe
On Fri, 27 Jun 2003, Bruno Wolff III wrote: > On Thu, Jun 26, 2003 at 09:27:23 -0700, > Shirish Reddy <[EMAIL PROTECTED]> wrote: > > Hi, > > > > One of the issues that is preventing us from migrating > > from an Oracle DB to Postgres is that Table > > Partitioning is not available in Postgres y

Re: Tablespaces (was Re: [HACKERS] [GENERAL] Physical Database

2003-06-27 Thread scott.marlowe
No, they're not. There are some folks who have hacked on them in the past, but nothing's been committed. On 27 Jun 2003, Austin Gonyou wrote: > I thought Tablespaces were already implemented. Are they not? > > > On Thu, 2003-06-26 at 22:10, Christopher Kings-Lynne wrote: > > > ROTFL... the an

Re: [HACKERS] Two weeks to feature freeze

2003-06-25 Thread scott.marlowe
On Tue, 24 Jun 2003, Dann Corbit wrote: > > -Original Message- > > From: The Hermit Hacker [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, June 24, 2003 6:10 PM > > To: Dann Corbit > > Cc: The Hermit Hacker; Jan Wieck; scott.marlowe; Bruce > > Momji

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Mon, 23 Jun 2003, Dann Corbit wrote: > > -Original Message- > > From: scott.marlowe [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 23, 2003 12:25 PM > > To: Dann Corbit > > Cc: Bruce Momjian; Tom Lane; Jason Earl; PostgreSQL-development > >

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Mon, 23 Jun 2003, Bruce Momjian wrote: > Peter Eisentraut wrote: > > Bruce Momjian writes: > > > > > Well, it is a nice test template for people who aren't shell script > > > experts, and I have been in the habit of pushing stuff I use into /tools > > > so it is available for others. > > > >

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Mon, 23 Jun 2003, Dann Corbit wrote: > Vendor A: "We think our tool is pretty solid and our end users hardly > ever turn up any bugs." > > Vendor B:" We think our tool is pretty solid and our 8500 tests > currently show only 3 defects with the released version, and these are > low impact issue

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Mon, 23 Jun 2003, Bruce Momjian wrote: > Peter Eisentraut wrote: > > The Hermit Hacker writes: > > > > > Ya, the script looked like it did a bit more then just a 'make clean; make > > > check' ... doesn't it? > > > > No. > > Well, it is a nice test template for people who aren't shell script

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Sat, 21 Jun 2003, Bruce Momjian wrote: > Andrew Dunstan wrote: > > > > Maybe a better strategy would be to get a release out soon but not wait 6 > > months for another release which would contain the Win32 port and the PITR > > stuff (assuming those aren't done in time for this release). > >

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread scott.marlowe
On Sat, 21 Jun 2003, Christopher Kings-Lynne wrote: > Crash-me has nothing to do with testing, it jsut checks to see what > features a db supports: An interesting point is that until recently, crashme said that the postgresql backend crashed on very large queries. The actual problem was that p

Re: [HACKERS] security flaw

2003-06-10 Thread scott.marlowe
On Sat, 7 Jun 2003 [EMAIL PROTECTED] wrote: > Hi all, > > I wonder if it's a security problem: One of my customer noticed that he > could see all databases on the system with phppgadmin. not only he sees > databases but tables, views, fonctions... Fortunatly he can't see any row. > > This custom

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-09 Thread scott.marlowe
On Fri, 6 Jun 2003, Bruce Momjian wrote: > scott.marlowe wrote: > > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > > > scott.marlowe writes: > > > > > > > If indexes on text worked right in other locales it would be no big deal. > > >

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-08 Thread scott.marlowe
On Thu, 5 Jun 2003, Peter Eisentraut wrote: > scott.marlowe writes: > > > If it comes down to it, we could always require a --locale setting and > > refuse to initdb without it. That way, whether it's in an RPM or from > > source, somebody somewhere along the

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-07 Thread scott.marlowe
On Thu, 5 Jun 2003, Alvaro Herrera Munoz wrote: > On Thu, Jun 05, 2003 at 09:44:21AM -0600, scott.marlowe wrote: > > On Thu, 5 Jun 2003, Nigel J. Andrews wrote: > > > Everything Nigel just wrote plus one thing. > > > > If it comes down to it, we could always

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-06 Thread scott.marlowe
On Fri, 6 Jun 2003, Peter Eisentraut wrote: > scott.marlowe writes: > > > If indexes on text worked right in other locales it would be no big deal. > > They will in version 7.4, so all these concerns about trading off locale > use vs. performance will become obsolete. Oh!

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-06 Thread scott.marlowe
On Thu, 5 Jun 2003, Nigel J. Andrews wrote: > On Wed, 4 Jun 2003, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > That is one thing I liked about the initdb mention --- it clearly told > > > them to watch out for something they might not have been looking for. > > > > Only

Re: [HACKERS] Broken RR?

2003-06-05 Thread scott.marlowe
I'm moving this to GENERAL. Whomsoever replies there please delete the pgsql-hackers cc entry. On Thu, 5 Jun 2003, Rasmus Resen Amossen wrote: > Does Postgres garantee repeatable-read (RR) during transactions? And does it > implement ARIES/KVL? > > If so, why is the following possible? > > T

Re: [HACKERS] RBLs ... I'm tired of spam ...

2003-05-27 Thread scott.marlowe
Another vote for SpamAssassin. We use it at work here and it's quite nice. It puts all the "borderline" spam in a holding area and sends you a daily email with all the topics / names listed and you can request those out of the spam bucket. It's configurable to the extreme. On Tue, 27 May 200

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > Hey, do you guys think that a setting of silent_mode = false might affect > > no log files getting created? > > No, but setting it to true would be bad news. That's

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Ed L. wrote: > On Friday April 4 2003 2:17, scott.marlowe wrote: > > > > OK, So I tried putting the 2>&1 before the | and all. No matter what I > > try, every from the | on is ignored. ps doesn't show it, and neither > > does pg_c

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Ed L. wrote: > On Friday April 4 2003 11:58, Tom Lane wrote: > > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > > rotatelogs is in my path and all, it just never sees it. > > > > You mean the command fails? Or just that it do

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > rotatelogs is in my path and all, it just never sees it. > > You mean the command fails? Or just that it doesn't capture output? The database starts, but rotatelogs d

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Ed L. wrote: > On Friday April 4 2003 10:19, Tom Lane wrote: > > > > I feel we really ought to have *some* rotator included in the standard > > distro, just so that the Admin Guide can point to a concrete solution > > instead of having to arm-wave about what you can get off the

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Andrew Sullivan wrote: > On Fri, Apr 04, 2003 at 09:16:39AM -0700, scott.marlowe wrote: > > where -r is the rotation period in seconds. If it's an external program > > Ours rotates based on size rather than time. I can see some > advantages to the t

Re: [HACKERS] more contrib: log rotator

2003-04-04 Thread scott.marlowe
On Fri, 4 Apr 2003, Peter Eisentraut wrote: > Andrew Sullivan writes: > > > Is anyone interested in having pglog-rotator? > > What would get me a whole lot more excited is if the server could write > directly to a file and do its own rotating (or at least reopening of > files). > > Considering

Re: [HACKERS] contrib and licensing

2003-04-02 Thread scott.marlowe
On Wed, 2 Apr 2003, Marc G. Fournier wrote: > On Wed, 2 Apr 2003, mlw wrote: > > > > > > > Tom Lane wrote: > > > > >mlw <[EMAIL PROTECTED]> writes: > > > > > > > > >>I know nothing in contrib should be GPL, I have no problem with that. > > >>The question is the requirement of a GPL library to bui

Re: [HACKERS] contrib and licensing

2003-04-02 Thread scott.marlowe
On Wed, 2 Apr 2003, mlw wrote: > > > Tom Lane wrote: > > >mlw <[EMAIL PROTECTED]> writes: > > > > > >>I know nothing in contrib should be GPL, I have no problem with that. > >>The question is the requirement of a GPL library to build a contrib project. > >> > >> > > > > > > > >>My SOAP

Re: [HACKERS] optimizer cost calculation problem

2003-04-01 Thread scott.marlowe
On Mon, 31 Mar 2003, Tom Lane wrote: > Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > BTW it does not 2 gig, but 1 gig (remember that we do sortmembytes * > > 2) . > > Good point. Probably that particular calculation should be > "sortmembytes * 2.0" to force it to double before it can overflow. >

Re: [HACKERS] index corruption?

2003-03-31 Thread scott.marlowe
On Mon, 31 Mar 2003, Ed L. wrote: > On Feb 13, 2003, Tom Lane wrote: > > > > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > > This is the error in the pgsql log: > > > 2003-02-13 16:21:42 [8843] ERROR: Index external_signstops_pkey is > > > not a btree > > > > This says that one of two field

Re: [HACKERS] Changing behavior of BEGIN...sleep...do something...COMMIT

2003-03-31 Thread scott.marlowe
On Fri, 28 Mar 2003, Tom Lane wrote: > It seems to me that it'd be fairly easy to make BEGIN cause only > a local state change in the backend; the actual transaction need not > start until the first subsequent command is received. It's already > true that the transaction snapshot is not frozen at

Re: [HACKERS] IO scheduler vs PostgreSQL performance measurement

2003-03-24 Thread scott.marlowe
On Mon, 17 Mar 2003, Nick Piggin wrote: > Dear PostgreSQL hackers, > I am developing a disk IO scheduler for Linux and am aiming to > have it included in the stable 2.6 release. Due to its design, > performance regressions do appear, and are often more specific > to the workload in question than w

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-24 Thread scott.marlowe
On Sun, 23 Mar 2003, Kevin Brown wrote: > Joe Conway wrote: > > Jason Earl wrote: > > >>Actually, I think it was someone else (Joe???) that is doing the leg > > >>work, and he was the one choosing explode / implode and getting > > >>gruff for it, so I was just stepping in and defending his decisio

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On 14 Mar 2003, Jason Earl wrote: > It's all good Scott. Anyone wanting to use PostgreSQL arrays would > undoubtedly open up the corresponding part of the manual that covers > array functions. Since there is likely to be less than a page full of > function definitions you could probably call the

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On Fri, 14 Mar 2003, D'Arcy J.M. Cain wrote: > On Friday 14 March 2003 13:24, scott.marlowe wrote: > > I vote for explode / implode as easier to type and remember than join_str. > > Also, in the SQL world, it's very likely that a back ground in > > ADA/LISP/REX/P

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On Fri, 14 Mar 2003, Þórhallur Hálfdánarson wrote: > -*- Greg Stark <[EMAIL PROTECTED]> [ 2003-03-14 17:43 ]: > > Do you really think someone looking for a function to break up a string into a > > list of strings would ever think of looking up "explode" in an index if he > > hadn't already used PH

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On Fri, 14 Mar 2003, Christopher Browne wrote: > > Do you really think someone looking for a function to break up a > > string into a list of strings would ever think of looking up "explode" > > in an index if he hadn't already used PHP or (shudder) VBScript? > > It's also one of the classic exam

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On 14 Mar 2003, Greg Stark wrote: > > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > > You're quick to throw out a trollish barb against PHP without any > > real discussion as to why it's such a horrible language. > > No need to be s

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread scott.marlowe
On 13 Mar 2003, Greg Stark wrote: > > Joe Conway <[EMAIL PROTECTED]> writes: > > > I'm leaning toward implode() and explode() now anyway because split() uses a > > regex for the delimiter in PHP (and probably Perl), and I was not planning to > > get that fancy. > > PHP isn't exactly an exemplar

Re: [HACKERS] Win32 Powerfail testing

2003-03-05 Thread scott.marlowe
On Wed, 5 Mar 2003, Dave Page wrote: > > > > -Original Message- > > From: Tatsuo Ishii [mailto:[EMAIL PROTECTED] > > Sent: 05 March 2003 02:23 > > To: [EMAIL PROTECTED] > > Subject: [HACKERS] Win32 Powerfail testing > > > > So far we found interesting facts. Our Win32 port passes his >

Re: [HACKERS] Yet another open-source benchmark

2003-03-03 Thread scott.marlowe
On Mon, 3 Mar 2003, Tommi Maekitalo wrote: > On the results page they list kernels like linux-2.4.18-1tier or > linux-2.4.19-rc2 or redhat-stock-2.4.7-10cmp. This sounds really like > linux-kernel-versions. > > Am Montag, 3. März 2003 13:41 schrieb [EMAIL PROTECTED]: > > > OSDL has just come ou

Re: [HACKERS] ILIKE

2003-02-24 Thread scott.marlowe
On Sat, 22 Feb 2003, Peter Eisentraut wrote: > AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when > lower(expr) LIKE 'foo' provides a solution that can use an index and is > more standard, too? I would guess because for lower(expr) to work you need to make an index on it. Si

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-21 Thread scott.marlowe
On Thu, 20 Feb 2003, Kevin Brown wrote: > Tom Lane wrote: > > UPDATE totals SET > > xmax = ss.xmax, xmin = ss.xmin, ... > > FROM > > (SELECT groupid, max(x) AS xmax, ... FROM details GROUP BY groupid) ss > > WHERE groupid = ss.groupid; > > As long as any individual item th

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread scott.marlowe
e, I think the actual document is > > ftp://ftp.sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-01-Framework-2002-01.pdf > > and it is in section 14.12 > > > on or about page 839 > > Dave > On Thu, 2003-02-20 at 11:20, scott.marlowe wrote: > > On

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread scott.marlowe
g/SC32/WG3/Progression_Documents/FCD/4FCD1-01-Framework-2002-01.pdf > > Dave > On Thu, 2003-02-20 at 11:20, scott.marlowe wrote: > > On Thu, 20 Feb 2003, Tom Lane wrote: > > > > > Hannu Krosing <[EMAIL PROTECTED]> writes: > > > > Are you against it ju

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread scott.marlowe
On Thu, 20 Feb 2003, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Are you against it just on grounds of cleanliness and ANSI compliance, > > or do you see more serious problems in letting it in ? > > At this point it seems there are two different things being tossed > about. I

Re: [HACKERS] location of the configuration files

2003-02-18 Thread scott.marlowe
On Sat, 15 Feb 2003, Curt Sampson wrote: > On Fri, 14 Feb 2003, scott.marlowe wrote: > > > Asking for everything in a directory with the name local in it to be > > shared is kind of counter intuitive to me. > > Not really. If you install a particular program that doesn

Re: [HACKERS] location of the configuration files

2003-02-14 Thread scott.marlowe
On Fri, 14 Feb 2003, Curt Sampson wrote: > On Thu, 13 Feb 2003, scott.marlowe wrote: > > > If I do a .tar.gz install of apache, I get /usr/local/apache/conf, which > > is not the standard way you're listing. > > I'm going to stay out of this argument from now

Re: [HACKERS] location of the configuration files

2003-02-14 Thread scott.marlowe
On Thu, 13 Feb 2003, mlw wrote: > > > scott.marlowe wrote: > > >>These are not issues at all. You could put the configuration file > >>anywhere, just as you can for any UNIX service. > >> > >>postmaster --config=/home/myhome/mydb.conf > >

Re: [HACKERS] location of the configuration files

2003-02-13 Thread scott.marlowe
On Thu, 13 Feb 2003, mlw wrote: > > > Christopher Browne wrote: > > >In the last exciting episode, [EMAIL PROTECTED] (Curt Sampson) wrote: > > > >>On Wed, 12 Feb 2003, Peter Bierman wrote: > >> > >>>What do you gain by having the postmaster config and the database > >>>data live in different lo

Re: [HACKERS] location of the configuration files

2003-02-13 Thread scott.marlowe
On 13 Feb 2003, Martin Coxall wrote: > > > Well, to the extent that you're serious, you understand that > > a lot of people feel that /usr/local should be reserved for > > stuff that's installed by the local sysadmin, and your > > vendor/distro isn't supposed to be messing with it. > > > > Wh

Re: [HACKERS] Changing the default configuration

2003-02-12 Thread scott.marlowe
Oh, another setting that should be a "default" for most users is to initdb automatically with locale of C. If they need a different locale, they should have to pick it. The performance of Postgresql with a locale other than C when doing like and such is a serious ding. I'd much rather have th

Re: [HACKERS] Changing the default configuration (was Re:

2003-02-12 Thread scott.marlowe
On Tue, 11 Feb 2003, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > ... If he starts running out of semaphores, that's a > > problem he can address while his database is still up and running in most > > operating systems, at least in

Re: [HACKERS] Options for growth

2003-02-12 Thread scott.marlowe
On Wed, 12 Feb 2003, GB Clark wrote: > On Thu, 23 Jan 2003 11:19:36 -0700 (MST) > "scott.marlowe" <[EMAIL PROTECTED]> wrote: > > > On 23 Jan 2003, Hannu Krosing wrote: > > > > > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > > >

Re: [HACKERS] Changing the default configuration

2003-02-11 Thread scott.marlowe
On Wed, 12 Feb 2003, Tatsuo Ishii wrote: > > My other pet peeve is the default max connections setting. This should be > > higher if possible, but of course, there's always the possibility of > > running out of file descriptors. > > > > Apache has a default max children of 150, and if using PH

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

2003-02-11 Thread scott.marlowe
On Wed, 12 Feb 2003, Curt Sampson wrote: > On Tue, 11 Feb 2003, Tom Lane wrote: > > > It's a lot too conservative. I've been thinking for awhile that we > > should adjust the defaults. > > Some of these issues could be made to Just Go Away with some code > changes. For example, using mmap rathe

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

2003-02-11 Thread scott.marlowe
On Tue, 11 Feb 2003, Rick Gigger wrote: > The type of person who can't configure it or doesnt' think to try is > probably not doing a project that requires any serious performance. As long > as you are running it on decent hardware postgres will run fantastic for > anything but a very heavy load.

Re: [HACKERS] Changing the default configuration (was Re:

2003-02-11 Thread scott.marlowe
On Tue, 11 Feb 2003, Merlin Moncure wrote: > Here's the comment I was referring to: > > /* > * InitProcGlobal - > * initializes the global process table. We put it here so that > * the postmaster can do this initialization. > * > * We also create all the per-process semaphores

Re: [HACKERS] Changing the default configuration (was Re:

2003-02-11 Thread scott.marlowe
On 11 Feb 2003, Greg Copeland wrote: > On Tue, 2003-02-11 at 12:55, Tom Lane wrote: > > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > > Is setting the max connections to something like 200 reasonable, or likely > > > to cause too many problems? &g

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

2003-02-11 Thread scott.marlowe
On Tue, 11 Feb 2003, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > Is setting the max connections to something like 200 reasonable, or likely > > to cause too many problems? > > That would likely run into number-of-semaphores limitation

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

2003-02-11 Thread scott.marlowe
My other pet peeve is the default max connections setting. This should be higher if possible, but of course, there's always the possibility of running out of file descriptors. Apache has a default max children of 150, and if using PHP or another language that runs as an apache module, it is qu

Re: [HACKERS] Options for growth

2003-01-23 Thread scott.marlowe
On 23 Jan 2003, Hannu Krosing wrote: > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > If the OS can handle the scheduling (which, last I checked, Linux couldn't, > > When did you do your checking ? > (just curious, not to start a flame war ;) > > > at least not without patches), eight or

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing

2003-01-08 Thread scott.marlowe
> No analyze for 7.1.3. > Just ran vacuum a few minutes before the query. No boost at all. Even > with SET enable_seqscan = 0 it still does a table scan. Dann, I can attest to 7.2 having a much better planner and performance than 7.1 did. Can you upgrade? ---(end of

Re: [HACKERS] Next platform query: Alphaservers under VMS?

2003-01-07 Thread scott.marlowe
Yeah, it's called cygwin. Oh, you probably meant that miserable excuse for a posix layer MS included when they shipped it. :-) On Tue, 7 Jan 2003, Dave Page wrote: > So does NT iirc ;-) > > > -Original Message- > > From: Greg Copeland [mailto:[EMAIL PROTECTED]] > > Sent: 07 January 2

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread scott.marlowe
On Thu, 19 Dec 2002, Philip Warner wrote: > At 10:49 PM 18/12/2002 -0500, Bruce Momjian wrote: > >I don't think we can bump that up in a minor. > > Why not? It's a relatively serious problem with the default config. > > > >Should we? > > Yes. I concur. The problems of a too-low fsm setting a

Re: [HACKERS] 7.3.1 stamped

2002-12-18 Thread scott.marlowe
On Wed, 18 Dec 2002, Bruce Momjian wrote: > Marc G. Fournier wrote: > > > My question is whether it is safe to be making this change in a minor > > > release? Does it work with 7.3 to 7.3.1 combinations? My other > > > question is, if SSLv2 isn't secure, couldn't a client say they only > > > sup

Re: [HACKERS] 7.3.1 stamped

2002-12-18 Thread scott.marlowe
On Wed, 18 Dec 2002, Marc G. Fournier wrote: > On Wed, 18 Dec 2002, Bruce Momjian wrote: > > > OK, I see from your commit message: > > > > From the SSL_CTX_new man page: > > > > "SSLv23_method(void), SSLv23_server_method(void), SSLv23_client_method(void) > > > > A TLS/SSL connection establishe

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-18 Thread scott.marlowe
On Wed, 18 Dec 2002, Marc G. Fournier wrote: > The problem is that there is nothing to announce ... "Hi, we fixed some > bugs"? :) minor releases don't have any features added to them, so isn't > really news worthy ... :( I don't know, if you're a postgresql user and you don't read these lists,

Re: [HACKERS] Suggestion; "WITH VACUUM" option

2002-12-16 Thread scott.marlowe
On Mon, 16 Dec 2002, Marc G. Fournier wrote: > On Mon, 16 Dec 2002, scott.marlowe wrote: > > > On Mon, 16 Dec 2002, Tom Lane wrote: > > > > > Josh Berkus <[EMAIL PROTECTED]> writes: > > > > How hard would it be to add a "WITH (VACUUM)" opt

Re: [HACKERS] Suggestion; "WITH VACUUM" option

2002-12-16 Thread scott.marlowe
On Mon, 16 Dec 2002, Tom Lane wrote: > Josh Berkus <[EMAIL PROTECTED]> writes: > > How hard would it be to add a "WITH (VACUUM)" option to UPDATE and DELETE > > queries? This option would cause the regular vacuum activity -- purging the > > dead tuple and its index references -- to be done imme

Re: [HACKERS] Auto Vacuum Daemon (again...)

2002-12-10 Thread scott.marlowe
On 10 Dec 2002, Rod Taylor wrote: > > > Not sure what you mean by that, but it sounds like the behaviour of my AVD > > > (having it block until the vacuum command completes) is fine, and perhaps > > > preferrable. > > > > I can easily imagine larger systems with multiple CPUs and multiple disk

Re: [HACKERS] How to compile postgres source code in VC++

2002-12-03 Thread scott.marlowe
On Fri, 29 Nov 2002, Prasanna Phadke wrote: > > Can anybody explain me, how to compile postgres source code in VC++. > > Catch all the cricket action. Download Yahoo! Score tracker Step 1: Get VC++ to run under unix... Just kidding. :-) Right now you can't. pgsql 7.4 should support native W

Re: [spam] Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-27 Thread scott.marlowe
On Wed, 27 Nov 2002, Al Sutton wrote: > Hannu, > > Using a Win32 platform will allow them to perform relative metrics. I'm not > looking for a statement saying things are x per cent faster than production, > I'm looking for reproducable evidence that an improvement offers y per cent > faster perf

Re: [PERFORM] [HACKERS] Realtime VACUUM, was: performance of

2002-11-27 Thread scott.marlowe
In a similar vein, setting the way back machine to the mid 80s when I was in the USAF and teaching the computer subsystem of the A-10 INS test station, we had old reclaimed Sperry 1650 computers (the precursor to the 1750) that had come out of the 1960 era fire control systems on battleships li

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: > scott.marlowe kirjutas K, 27.11.2002 kell 01:40: > > On 27 Nov 2002, Hannu Krosing wrote: > > > > > You could try out VMWare and run a linux virtual machine under Windows, > > > You could set it up once with all ne

Re: [HACKERS] possible obvious bug?

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: > Merlin Moncure kirjutas T, 26.11.2002 kell 08:00: > > I was playing with the Japanese win32 7.2.1 port and I noticed that "select > > 0 / 0" caused the server to crash and restart. I understand that it is a > > totally unsupported version, but it should be e

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On Tue, 26 Nov 2002, bpalmer wrote: > > > D'Arcy, > > > > > > In production the database servers are seperate multi-processor machines > > > with mirrored disks linked via Gigabit ethernet to the app server. > > > > > > In development I have people extremely familiar with MS, but not very hot > >

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On 27 Nov 2002, Hannu Krosing wrote: > Al Sutton kirjutas T, 26.11.2002 kell 20:37: > > D'Arcy, > > > > In production the database servers are seperate multi-processor machines > > with mirrored disks linked via Gigabit ethernet to the app server. > > > > In development I have people extremely f

Re: [mail] Re: [HACKERS] Native Win32 sources

2002-11-26 Thread scott.marlowe
On Tue, 26 Nov 2002, Al Sutton wrote: > D'Arcy, > > In production the database servers are seperate multi-processor machines > with mirrored disks linked via Gigabit ethernet to the app server. > > In development I have people extremely familiar with MS, but not very hot > with Unix in any flavo

Re: [HACKERS] Postgres Security Expert???

2002-11-26 Thread scott.marlowe
On Tue, 26 Nov 2002, Justin Clift wrote: > Dear Clift, > > > As a side thought, would you please be able to correct the spelling of > PostgreSQL on the same page. Presently it's spelt "PostGreSQL", which > is > incorrect. > > Better way, i'v remove postgresql name in the site, as i think you wa

Re: [HACKERS] Solaris still failing RC2

2002-11-25 Thread scott.marlowe
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote: > Can you send in the regression.diffs file? > OK, after a bit of hair pulling, and figuring out I was running out of space because of quotas, I've gotten it to run with only one failure, which was because of having too many files open, and t

Re: [HACKERS] Solaris still failing RC2

2002-11-25 Thread scott.marlowe
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote: > Can you send in the regression.diffs file? > > Chris > > - Original Message - > From: "scott.marlowe" <[EMAIL PROTECTED]> > To: "Tom Lane" <[EMAIL PROTECTED]> > Cc: &qu

Re: [HACKERS] Solaris still failing RC2

2002-11-25 Thread scott.marlowe
On Mon, 25 Nov 2002, Bruce Momjian wrote: > > Please try RC2; this is fixed there. U. That was with rc2 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

<    1   2   3   >