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 prob

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

2004-11-11 Thread Andrew McMillan
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 > > enabling higher log levels at selective points has the potential to help > > _a lot_ with

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

2004-11-10 Thread Andrew McMillan
her log levels at selective points has the potential to help _a lot_ with diagnostic detail, without smothering you in _every_ detail. Regards, Andrew McMillan. - Andrew @ Catalyst .Net .NZ

Re: [HACKERS] [PATCHES] CVS should die

2004-11-06 Thread Andrew McMillan
On Fri, 2004-11-05 at 15:37 -0500, Tom Lane wrote: > > One of the reasons I'm disinclined to move is that none of the proposed > alternatives seem especially, um, mature. AFAIK this project has never > had CVS lose any data in the eight years we've used it. I'd want a > comparable level of trust

Re: [HACKERS] LinuxTag wrapup

2004-07-05 Thread Andrew McMillan
since I've never been able to get the environment to even install on a Debian system :-( Regards, Andrew McMillan. - Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wel

Re: [HACKERS] casting for dates

2001-09-26 Thread Andrew McMillan
On Thu, 2001-09-27 at 08:30, Vince Vielhaber wrote: > > I'm trying to use an integer from a table to add/subtract time in months. > IOW: > > create table foo(nummonths int); > > select now() - nummonths months; newsroom=# select now() - interval( text(3) || ' months'); ?column?

Re: [HACKERS] Postgresql log analyzer

2001-08-21 Thread Andrew McMillan
nice to see an EXPLAIN on the query page, but you would want this to be an option, I guess. I imagine you could do this by getting the EXPLAIN at log analysis time if it isn't in the logs. Cheers, Andrew. -- _________

Re: [HACKERS] Link to bug webpage

2001-08-21 Thread Andrew McMillan
d around bugs for a single application. If Bugzilla were installed I'm sure some functionality could be added into it along the lines of the Debian BTS too. Regards, Andrew. -- _________

Re: [HACKERS] Incomplete idea about views and INSERT...RETURNING

2001-07-22 Thread Andrew McMillan
SELECT clause keyed on values from that? Cheers, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709

Re: [HACKERS] SAPDB Open Souce

2001-04-29 Thread Andrew McMillan
Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64(21)635-694, Fax: +64(4)499-5596, Office: +64(4)499-2267xtn709 ---(end of broadcast)--

Re: [HACKERS] Speaking of Indexing... (Text indexing)

2001-04-10 Thread Andrew McMillan
nges it to keyword indexing, if you're interested. Regards, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me:

Re: [HACKERS] "--tuning" compile and runtime option (?)

2001-04-10 Thread Andrew McMillan
arcane though, hence the APW, BIW and AIW statistics are zero above. Regards, Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 T

Re: [HACKERS] "--tuning" compile and runtime option (?)

2001-04-10 Thread Andrew McMillan
as hopefully providing more data on performance issues back to the core team. That'll be 2c, please :-) Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-22

Re: [HACKERS] Re: xlog loose ends, continued

2001-03-13 Thread Andrew McMillan
rvers that have this sort of thing, and it has been a life-saver for me on occasion to allow critical information to be extracted before you nuke it all and start over. Cheers, Andrew. -- _

Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster

2001-03-07 Thread Andrew McMillan
Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267 ---(end of

Re: [HACKERS] mailing list messages

2001-03-06 Thread Andrew McMillan
ice, I think. We must all be able to come up with 100 or so little one or two liners about PostgreSQL can't we? Just a thought, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PR

Re: [HACKERS] Upper limit on number of buffers?

2000-12-31 Thread Andrew McMillan
Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [HACKERS] Why vacuum?

2000-12-14 Thread Andrew McMillan
doubt challenge these hackers whom we are all greatly indebted to. Cheers, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Re: [HACKERS] Import text field

2000-11-24 Thread Andrew McMillan
not handled by the COPY ... DELIMITER ... sort of mechanism in PostgreSQL. E-mail me privately if you want a copy. Regards, Andrew. -- _ Andrew McMillan, e-mail: [EMAIL PROTECTE

Re: [HACKERS] Full text indexing (Question/request)

2000-10-17 Thread Andrew McMillan
_ to see full-text or keyword indexing natively in PostgreSQL. Regards, Andrew. -- _____ Andrew McMillan, e-mail: [EMAIL PROTECTED] Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The T