Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread D'Arcy J.M. Cain
On December 9, 2003 12:15 pm, Neil Conway wrote: P.S. While we're contemplating pies-in-the-sky, I'd personally love to rewrite PostgreSQL in Objective Caml. I vote for InterCal. :-) -- D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D'Arcy J.M. Cain
of pg_autovacuum would be to run 24/7 so that there is never big hit on the system. Perhaps it could be designed to throttle itself based on current system usage though. -- D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D'Arcy J.M. Cain
On Fri, 23 Apr 2004 13:08:30 -0400 (EDT) Bruce Momjian [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain wrote: It seems to me that the point of pg_autovacuum would be to run 24/7 so that there is never big hit on the system. Perhaps it could be designed to throttle itself based on current system

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

2002-11-26 Thread D'Arcy J.M. Cain
. They run whatever they want - we have people using NetBSD, Linux and Windows - but they work on one database which is tuned for the purpose. They can even create their own databases on that system if they want for local testing. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three

Re: [HACKERS] [SQL] SELECT FOR UPDATE locks whole table

2002-12-07 Thread D'Arcy J.M. Cain
couldn't find anything in the docs or web specifically about this. Does anyone have any ideas? Adding hackers as this may be an internal issue. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425

Re: [HACKERS] python interface

2003-01-03 Thread D'Arcy J.M. Cain
that I need to be logged in to create a new project. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end

Re: [HACKERS] python interface

2003-01-03 Thread D'Arcy J.M. Cain
On Friday 03 January 2003 15:24, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I would love to add PyGreSQL to gborg but no matter how often I log in it tells me that I need to be logged in to create a new project. Weird. Maybe you're blocking cookies, or something like

Re: [HACKERS] python interface

2003-01-08 Thread D'Arcy J.M. Cain
was just going to add a pointer to the PyGreSQL page but leave the code where it was. If we move it won't it make it harder to add it with just a config option like we do now? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

[HACKERS] Options for growth

2003-01-16 Thread D'Arcy J.M. Cain
hardware but we are concerned about not having access to that nice, cheap, generic hardware for when we need to grow again or for redundant backup. Thanks for any tips and suggestions. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 12:23, Neil Conway wrote: On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote: Is [Oracle RAC] really as simple as it sounds or would we just be giving up the other two for a new set of problems. That's a question you should be asking to an authority on Oracle

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 20:54, Christopher Kings-Lynne wrote: toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC) software. You mean Real Application Clusters? Oops, yes. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 11:59, Adrian 'Dagurashibanipal' von Bidder wrote: On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote: We are also looking at hardware solutions, multi-CPU PCs with tons (24GB) of memory. I know that memory will improve access if it prevents swapping but how

Re: [HACKERS] Survey results from the PostgreSQL portal page

2003-01-19 Thread D'Arcy J.M. Cain
. It doesn't matter how fast we are, faster is always better. Other items are of the nature have or not have a feature and people may disagree whether we need the feature or not but who will ever say that more speed is not wanted? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves

Re: [HACKERS] Call for objections: put back OIDs in CREATE TABLE

2003-01-23 Thread D'Arcy J.M. Cain
make sense for me. Have it so that OIDs are created by default if there is no primary key defined and not if there is. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] [SQL] Function for adding Money type

2003-01-26 Thread D'Arcy J.M. Cain
the number of decimal places on output but I am not sure if that would affect the primary benefit of using it, speed. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

[HACKERS] PostgreSQL, NetBSD and NFS

2003-01-30 Thread D'Arcy J.M. Cain
have and may even suggest fixes if necessary. I have Bcc'd the engineer on this message and will send anything I get to them. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-01-31 Thread D'Arcy J.M. Cain
On Thursday 30 January 2003 18:32, Simon J. Gerraty wrote: Is postgreSQL trying to lock a file perhaps? Would seem a sensible thing for it to be doing... Is that a problem? FWIW I am running statd and lockd on the NetBSD box. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-01-31 Thread D'Arcy J.M. Cain
On Thursday 30 January 2003 12:07, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I have posted before about this but I am now posting to both NetBSD and PostgreSQL since it seems to be some sort of interaction between the two. I have a NetAPP filer on which I am putting

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-01-31 Thread D'Arcy J.M. Cain
please. I think I remember someone else saying that they use PostgreSQL over NFS so hopefully this is not the situation. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-01-31 Thread D'Arcy J.M. Cain
On Thursday 30 January 2003 14:02, mlw wrote: Forgive my stupidity, are you running PostgreSQL with the data on an NFS share? Yes, sorry. PostgreSQL is running from the local disk but the data is on the mounted drive. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-01 Thread D'Arcy J.M. Cain
for the certificate database which is the 8 million record table that I am trying to load. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-01 Thread D'Arcy J.M. Cain
, nothing was logged after the COPY command. It's possible that the file was corrupted. I will do a new test from scratch now that I am not switching speeds. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-01 Thread D'Arcy J.M. Cain
On Saturday 01 February 2003 14:43, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Here's the log. As you can see, nothing was logged after the COPY command. What else was going on? As far as I can see, the code never does a semop unless it's waiting for some other backend

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-02 Thread D'Arcy J.M. Cain
/lwlock.c and backend/storage/lmgr/spin.c myself and can't find any place that it can get into an infinite loop without making a system call within the loop. It's very odd. Also odd, why would running over NFS have any bearing on it if we could find such a place? -- D'Arcy J.M. Cain darcy

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-02 Thread D'Arcy J.M. Cain
On Sunday 02 February 2003 12:26, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Also odd, why would running over NFS have any bearing on it if we could find such a place? Yup, 'tis the question. The only theory I have been able to come up with is that there's something flaky

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
-- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 2: you can get

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
On Wednesday 05 February 2003 10:12, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Well, it does appear to be working but it never finishes. Here are two backtraces. One was taken while it was running and the other after a kill -9. The primary key file should have had

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
On Wednesday 05 February 2003 11:49, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Hmm. This time it passed that point but this happened: COPY certificate FROM stdin; NOTICE: copy: line 253677, bt_insertonpg[certificate_pkey]: parent page unfound - fixing branch ERROR

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
interface in the machine which was on a completely different network than the one I am on now. What is the implication of smaller read and write size? Will I necessarily take a performance hit? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] A bad behavior under autocommit off mode

2003-02-20 Thread D'Arcy J.M. Cain
ought to start a transaction block. Sure but doesn't it also commit it? There's still no transaction open coming out of the SELECT. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD

Re: [HACKERS] analyze after a database restore?

2003-02-27 Thread D'Arcy J.M. Cain
that? [...] From an ease of use perspective, it would be one less step. Why not have pg_dump emit a friendly reminder? -- D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-14 Thread D'Arcy J.M. Cain
and explode just sound unprofessional to me. Minor point but it's just preference, right? -- D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-04-17 Thread D'Arcy J.M. Cain
are done, just plug the number into your configuration and get the plans that you are looking for. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's

[HACKERS] Money type

2002-05-16 Thread D'Arcy J.M. Cain
of the type I naturally have some bias but I still think that it is a good type for all the reasons we thought it was a good idea before. There is a definite advantage to being able to do integer arithmetic right on the CPU in large financial applications. -- D'Arcy J.M. Cain darcy@{druid|vex

[HACKERS] Edge case problem with pg_dump

2002-05-22 Thread D'Arcy J.M. Cain
. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Edge case problem with pg_dump

2002-05-23 Thread D'Arcy J.M. Cain
of the COPY look like? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast

Re: [HACKERS] Edge case problem with pg_dump

2002-05-23 Thread D'Arcy J.M. Cain
* Tom Lane [EMAIL PROTECTED] [020523 10:24]: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Do you mean issue COPY commands with fields or COPY out the fields in a specific order by using the extension in pg_dump? I intended that the dump scripts would say something like COPY mytab

Re: [HACKERS] Should next release by 8.0 (Was: Re: [GENERAL] I am

2002-07-06 Thread D'Arcy J.M. Cain
the top of my head, would be pgAccess, pgAdmin and phpPgAdmin ... but I would guess that any 'administratively oriented' interface would face similar problems, no? PyGreSQL pokes into the catalogues a bit. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http

Re: [HACKERS] Issues Outstanding for Point In Time Recovery (PITR)

2002-07-17 Thread D'Arcy J.M. Cain
and indexes do not propagate through the roll forward recovery mechanism properly. I can live with that. Schemas shouldn't change so often that you can't just dup any changes to the backup(s). -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-30 Thread D'Arcy J.M. Cain
to come up with anything. I think one of the values of it is that it is something that no one else has. It distinguishes us. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-30 Thread D'Arcy J.M. Cain
* Adrian 'Dagurashibanipal' von Bidder [EMAIL PROTECTED] [020730 08:01]: On Tue, 2002-07-30 at 13:46, D'Arcy J.M. Cain wrote: I think one of the values of it is that it is something that no one else has. It distinguishes us. Col. Let's have the 'automatically phone KFC if developer

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-08-02 Thread D'Arcy J.M. Cain
granted to them independent of the underlying tables. It a nice , distinguishing feature. What other database allows you to grant one person access to a subset of the colums of a table as well as a subset of the rows? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-20 Thread D'Arcy J.M. Cain
arithmetic though. I know that I do a lot of calculations (mostly sums) on money and going to numeric is going to be a hit. No matter how efficient it is it can't be as efficient as a cpu register addition. But maybe I'm wrong and the hit will be negligible. -- D'Arcy J.M. Cain darcy@{druid

[HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-26 Thread D'Arcy J.M. Cain
that it is an indexable type and that doesn't seem to have any problem. It is constructed the same way otherwise. The palloc calls appear to be correct. Can anyone see why this would suddenly be a problem? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-27 Thread D'Arcy J.M. Cain
On August 27, 2002 02:01 am, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I have been getting the subject message ever since upgrading to 7.2.1. I tried 7.2.2 with the same thing. It seems to be related to my chkpass type (see contrib) as it only happens on tables

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-27 Thread D'Arcy J.M. Cain
On August 27, 2002 09:13 am, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: On August 27, 2002 02:01 am, Tom Lane wrote: FWIW, I couldn't see any problem in CVS tip. Could you provide an exact sequence-to-reproduce? Surely. Create a database (chkpass_test) and, after

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-28 Thread D'Arcy J.M. Cain
. No difference. It seems that PostgreSQL is too good at catching the problem before the assert macros see it. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-28 Thread D'Arcy J.M. Cain
On August 28, 2002 12:48 pm, D'Arcy J.M. Cain wrote: On August 28, 2002 09:23 am, Tom Lane wrote: The behavior looks a lot like a memory clobber, so perhaps the key variable is some difference in malloc's allocation strategy, causing two items to be adjacent in NetBSD where

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-28 Thread D'Arcy J.M. Cain
a text type for both? Still doesn't explain why no one else sees this though. Oh, one more datapoint - the error only happens on vacuum analyze, not just vacuum. Not sure what that means exactly. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net

Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735

2002-08-29 Thread D'Arcy J.M. Cain
On August 28, 2002 11:07 pm, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Hmm. I did give it a harder look and look what jumped out. Both chkpass_out and chkpass_rout return PG_RETURN_CSTRING but chkpass_out builds a standard c string while chkpass_rout builds a variable

Re: Type definition process (was Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735)

2002-08-29 Thread D'Arcy J.M. Cain
On August 29, 2002 09:45 am, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: YES! Well, sort of. I didn't have any other operators but while I thought that both were the same (after all, I contributed it) someone must have fixed the one in CVS before adding it. The one I

Re: Type definition process (was Re: [HACKERS] MemoryContextAlloc: invalid request size 1934906735)

2002-08-29 Thread D'Arcy J.M. Cain
On August 29, 2002 03:37 pm, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: One thing I do see though is that there is a completion issue. Well, (a) the shell type can't be used for anything till you turn it into a real type, and (b) the completion issue already exists, and has

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread D'Arcy J.M. Cain
Thus spake Tom Ivar Helbekkmo We need some NetBSD folks to speak up! I have successfully compiled it from CVS sources on my NetBSD -current but I can't find the tar file for RC1 to try it with the package system. Can someone point me to it please. -- D'Arcy J.M. Cain darcy@{druid|vex}.net

Re: [HACKERS] capitalized sql (was: Re: Changing the default valu eof an inherited column)

2001-04-03 Thread D'Arcy J.M. Cain
d with language constructs and variables. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)---

Re: [HACKERS] Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't importto v7.1?

2001-04-11 Thread D'Arcy J.M. Cain
to fix one table if there is a problem. Finding and fixing one 7 row table in a multi-gigabyte files really sucks. :-) -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] Another news story in need of 'enlightenment'

2001-04-18 Thread D'Arcy J.M. Cain
be published on the net. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast

Re: [HACKERS] Building Fault Tolerant/Failover PGSQL Systems

2001-04-29 Thread D'Arcy J.M. Cain
we will still do nightly backups but it would have to be quite the catastrophe if we ever needed it. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's

Re: [HACKERS] Re: Extrordinarily Poor Performance....

2001-05-04 Thread D'Arcy J.M. Cain
considering increasing the shmmax again. Although it isn't supposed to be necessary, I find that I have to dump and reload once in a while to keep performance hight. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep

[HACKERS] Changes needed to build on NetBSD

2001-05-08 Thread D'Arcy J.M. Cain
someone could watch source changes and just review the changes. I am asking because I generally don't work on stuff outside of PyGreSQL. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD

[HACKERS] CVS access lost

2001-08-17 Thread D'Arcy J.M. Cain
nasty and sneaky bug) and I can't commit. Thanks. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end

Re: [HACKERS] Link to bug webpage

2001-08-21 Thread D'Arcy J.M. Cain
. I can't believe that anyone important is listening to this guy. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] Log rotation?

2001-09-06 Thread D'Arcy J.M. Cain
applications but I don't think that it should be forced on everyone. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] CVS access

2001-09-07 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier okay, is this still a problem, and is this with the new password that I issued/email'd about a couple of weeks back? Are you also addressing my problem connecting? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] CVS access

2001-09-07 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier with the new passowwrd, your problem should be resolved too ... is it not? What new password? Certainly the one I have on the mail machine doesn't work. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Hot spare PSQL server

2001-09-17 Thread D'Arcy J.M. Cain
Thus spake Turbo Fredriksson Justin http://pgreplicator.sourceforge.net Unfortunatly this seems to be asynchronous replication (you manually have to initiate the syncronization)... And it also uses the GNU license. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three

Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-18 Thread D'Arcy J.M. Cain
it is good for both projects to leave it where it is. Will you be in today? I can call you later to discuss this and hopefully resolve it. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212

Re: [HACKERS] pg_sorttemp files

2001-10-19 Thread D'Arcy J.M. Cain
Thus spake Tom Lane [EMAIL PROTECTED] (D'Arcy J.M. Cain) writes: I have tons of old files with names like base/db/pg_sorttemp.##. I assume that they are temporary sorting files but somehow they never got cleared out. Is it safe to delete these from a running system. The files

Re: [HACKERS] pg_sorttemp files

2001-10-20 Thread D'Arcy J.M. Cain
Thus spake Tom Lane [EMAIL PROTECTED] (D'Arcy J.M. Cain) writes: BTW, if you are seeing unreclaimed sorttemp files in a recent release (7.0 or later), I'd like to know about it. That shouldn't happen, short of a backend crash anyway... Well, I had over 6,000 of these files

Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-21 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier can you ssh into cvs.postgresql.org? Yes! I could not do that before. Did you fix something? Nope :( Just weird. Oh well. All's well, etc. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier can you ssh into cvs.postgresql.org? Yes! I could not do that before. Did you fix something? I will be sending some PyGreSQL changes over shortly. Thanks. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy

[HACKERS] pg_sorttemp files

2001-10-17 Thread D'Arcy J.M. Cain
I have tons of old files with names like base/db/pg_sorttemp.##. I assume that they are temporary sorting files but somehow they never got cleared out. Is it safe to delete these from a running system. The files are months old. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy

Re: [HACKERS] Time for 7.2.1?

2002-03-19 Thread D'Arcy J.M. Cain
and upgrades into PyGreSQL? -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast

Re: [HACKERS] Proposal: 7.2b2 today

2002-03-20 Thread D'Arcy J.M. Cain
* Peter Eisentraut [EMAIL PROTECTED] [011106 20:01]: D'Arcy J.M. Cain writes: I have a change I would like to discuss. It doesn't change the code base, only the build system. The patches I would like to commit follow this text. The only thing it does is create a config option

Re: [HACKERS] SET NULL / SET NOT NULL

2002-03-22 Thread D'Arcy J.M. Cain
of saying ...NOT SET NULL or NOT UNSET NULL but I realize that it should also look more like the NOT NULL clause we already have in the CREATE TABLE query. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416

Re: [HACKERS] monetary bug

2004-08-22 Thread D'Arcy J.M. Cain
. Perhaps I should submit it as a patch to the existing money type instead. I have fixed up a few other issues while I was at it. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread D'Arcy J.M. Cain
though. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 9

[HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D'Arcy J.M. Cain
and it did not get better with pg_autovacuum help. Is there any way to find out what's going on? -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D'Arcy J.M. Cain
On Tue, 21 Sep 2004 11:00:33 -0400 Tom Lane [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I had previously mentioned that queries run much different depending on whether a VACUUM ANALYZE is done or just a plain ANALYZE. The problem appears to be that it's picking

[HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-23 Thread D'Arcy J.M. Cain
-- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 3

[HACKERS] Nice vacuums

2004-10-22 Thread D'Arcy J.M. Cain
is this. Is this strategy likely to improve my transaction processing? -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

[HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D'Arcy J.M. Cain
can grab the lock. Right now I am modifying my lock class (It's in Python) to add a 1 second sleep before trying to grab an existing session. That seems to work but I hope I can do better. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D'Arcy J.M. Cain
On Mon, 08 Nov 2004 12:56:57 -0500 Jan Wieck [EMAIL PROTECTED] wrote: Hi Jan. On 11/8/2004 12:03 PM, D'Arcy J.M. Cain wrote: I checked the FAQ and docs but haven't found anything definitive. This is my SQL test script: SELECT pg_backend_pid(); SELECT * FROM pg_stat_activity order

Re: [HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D'Arcy J.M. Cain
On Mon, 08 Nov 2004 13:07:34 -0500 Tom Lane [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I checked the FAQ and docs but haven't found anything definitive. This is my SQL test script: SELECT pg_backend_pid(); SELECT * FROM pg_stat_activity order by procpid

[HACKERS] Trouble with plpgsql on 7.4.6

2004-11-18 Thread D'Arcy J.M. Cain
panther cert198[1332]: [60-1] LOG: 0: database system is ready Nov 18 11:49:21 panther cert198[1332]: [60-2] LOCATION: StartupXLOG, xlog.c:2946 -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-18 Thread D'Arcy J.M. Cain
On Thu, 18 Nov 2004 14:25:41 -0500 Tom Lane [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Has anyone else had any problem installing plpgsql into a 7.4.6 database? When I try (on NetBSD 2.0RC5) I get the following message: createlang: language installation failed

Re: [Plperlng-devel] Re: [HACKERS] Concern about new PL/Perl

2004-11-19 Thread D'Arcy J.M. Cain
is ;) It's what we call Veteran's Day and yes, Marc, it is on the same day as us. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-23 Thread D'Arcy J.M. Cain
On Sat, 20 Nov 2004 11:17:48 -0500 Tom Lane [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I thought that this would have sent everything to both the log and the screen but I found that the syslog has much more detail. I have attached that output. We still need

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-24 Thread D'Arcy J.M. Cain
On Tue, 23 Nov 2004 07:25:17 -0500 D'Arcy J.M. Cain [EMAIL PROTECTED] wrote: #0 0x483cafeb in kill () from /usr/lib/libc.so.12 #1 0x483cd0af in __libc_mutex_catchall_stub (m=1212478892) at /usr/src/lib/libc/thread-stub/thread-stub.c:112 #2 0x4843f0f7 in free (ptr=incomplete type

[HACKERS] Mailing list

2005-07-08 Thread D'Arcy J.M. Cain
that can be fixed? -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 2

Re: [HACKERS] POWER vs. POW ???

2005-11-24 Thread D'Arcy J.M. Cain
and you get seven, one more than the first. Check these out. test=# SELECT POW(2,-2) AS REALLY_BIG_LABEL; really_big_label -- 0.25 (1 row) test=# SELECT POWER(2,-2) AS X; x -- 0.25 (1 row) -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-13 Thread D'Arcy J.M. Cain
is guaranteed to be complex and still not handle everyone's requirements. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] ARC patent

2005-01-19 Thread D'Arcy J.M. Cain
and it doesn't sound like we are going backwards. 2. From a marketing standpoint it is easier to sell our bosses/clients that 8.0.1 is exactly the same as they have running and tested but without a legal constraint than 8.1 which sounds more like a new version. -- D'Arcy J.M. Cain darcy

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-20 Thread D'Arcy J.M. Cain
of modified rows as a parameter? I don't believe that such a facility exists but before dismissing it you should test it out. I think that you will find that disk buffering (the system's as well as PostgreSQL's) will effectively handle this for you anyway. -- D'Arcy J.M. Cain darcy@druid.net

Re: [HACKERS] win32 performance - fsync question

2005-02-17 Thread D'Arcy J.M. Cain
that it solves a different problem than all those other tools. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end

Re: [HACKERS] Interesting NetBSD annual report

2005-02-25 Thread D'Arcy J.M. Cain
things. I think that in any organization the people get stuff done regardless of what structure is in place. It depends more on the people than the structure. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting

Re: [HACKERS] psql readline win32

2006-01-02 Thread D'Arcy J.M. Cain
On Mon, 2 Jan 2006 16:27:48 -0600 (CST) Andrew Dunstan [EMAIL PROTECTED] wrote: Our BSD license is recognised as a GPL-compatible license. Recognized by who? The only two entities that I can think of that matter would be GNU itself or the courts. -- D'Arcy J.M. Cain darcy@druid.net

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-02 Thread D'Arcy J.M. Cain
possibilities. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 4

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-09 Thread D'Arcy J.M. Cain
that are likely needed to be done, and will be available to do so, I eagerly solicit your help. Please contact me off list in that case. What type of things will you be needing? I can probably spare some time. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-09 Thread D'Arcy J.M. Cain
On Thu, 9 Mar 2006 16:18:43 -0500 D'Arcy J.M. Cain darcy@druid.net wrote: What type of things will you be needing? I can probably spare some time. Doh! Sorry about that. I did reply instead of reply all thinking it would only go to Andrew. I didn't meant to send to the list. -- D'Arcy J.M

Re: [HACKERS] Slony-I for circular replication

2006-03-30 Thread D'Arcy J.M. Cain
, that was the conclusion we came to. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast

  1   2   3   >