[HACKERS] FW: PGBuildfarm member peripatus Branch REL9_2_STABLE Status changed from PLCheck-C failure to OK

2017-05-23 Thread Larry Rosenman
Rebuilding Perl and all it’s related ports fixed it. Dealing with the FreeBSD folks on what all we (FreeBSD) need to put in /usr/ports/UPDATING and / or /usr/src/UPDATING -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l

[HACKERS] FW: PGBuildfarm member peripatus Branch REL9_2_STABLE Failed at Stage PLCheck-C

2017-05-23 Thread Larry Rosenman
Looks like the upgrade of this machine to the inode64 commit of FreeBSD busted stuff. I’m rebuilding perl and all the ports to see if that fixes it. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail

Re: [HACKERS] Renaming some binaries

2016-08-26 Thread Larry Rosenman
o" etc Less code, no confusion because we have just one client tool - psql. Several of them have the ability to connect to several databases, some even do that in parallel. vacuumdb being one that I've needed recently to do a number of DB's in a row. -- Larry Rosenman

Re: [HACKERS] 10.0

2016-05-13 Thread Larry Rosenman
ps that have been written assuming the first part of the version number is only a single digit. Is that likely? That would be remarkably myopic, but I guess possible. Thom We (FreeBSD) had lots of that kind of fallout when 9->10. Autoconf, and other tools thought we were a.out and not

Re: [HACKERS] Mac OS: invalid byte sequence for encoding "UTF8"

2016-02-10 Thread Larry Rosenman
regards, tom lane Definitive FreeBSD Sources: https://svnweb.freebsd.org/base/ -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961 -- Sent via pgsql-hack

Re: [HACKERS] Mac OS: invalid byte sequence for encoding "UTF8"

2016-02-10 Thread Larry Rosenman
On 2016-02-10 17:00, Tom Lane wrote: Larry Rosenman <l...@lerctr.org> writes: On 2016-02-10 16:19, Tom Lane wrote: I looked into the OS X sources, and found that indeed you are right: *scanf processes the input a byte at a time, and applies isspace() to each byte separately, eve

Re: [HACKERS] New email address

2015-11-24 Thread Larry Rosenman
On 2015-11-24 13:43, Alvaro Herrera wrote: Larry Rosenman wrote: On 2015-11-24 13:11, Tom Lane wrote: >Kevin Grittner <kgri...@gmail.com> writes: >>On Tue, Nov 24, 2015 at 11:10 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>>>change the From header (and add

Re: [HACKERS] New email address

2015-11-24 Thread Larry Rosenman
ll allow you to do. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make cha

Re: [HACKERS] [PATCH] pg_upgrade: support for btrfs copy-on-write clones

2013-10-02 Thread Larry Rosenman
to a FreeBSD 10 system that is totally ZFS. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: l...@lerctr.org US Mail: 108 Turvey Cove, Hutto, TX 78634-5688 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 3/6/2012 8:32 AM, Robert Haas wrote: On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman l...@lerctr.org wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there any way to get more info out of CLUSTER VERBOSE so it says what index it's

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
processes are running. Do I need to cogitate on the code, or is one of the hackers that knows it better interested? Thanks! - -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 3/7/2012 2:42 PM, Tom Lane wrote: Larry Rosenman l...@lerctr.org writes: On 3/7/2012 12:31 PM, Alvaro Herrera wrote: Also, this isn't limited to CLUSTER; anything that rewrites the table and indexes would benefit. Meaning ALTER TABLE

[HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-05 Thread Larry Rosenman
versions in 4224437 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 168.02s/4324.68u sec elapsed 8379.12 sec. And at this point it's doing something(tm), I assume re-doing the indexes. It would be nice(tm) to get more info. Ideas? - -- Larry Rosenman http

Re: [HACKERS] 8.5 vs. 9.0

2010-01-21 Thread Larry Rosenman
AND Streaming Replication hit the tree, the release number would go to 9.0. Both are in the tree. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -- Sent via pgsql

Re: [HACKERS] Sought after architectures for the PostgreSQL buildfarm?

2009-12-08 Thread Larry Rosenman
I might be able to help with: Sparc PA-Risc (HP-UX) IA64 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: pgsql-hackers-ow

Re: [HACKERS] Rules: A Modest Proposal

2009-10-04 Thread Larry Rosenman
changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Larry Rosenman http

Re: [HACKERS] [PATCHES] Fix for large file support (nonsegment mode support)

2008-03-11 Thread Larry Rosenman
, per filesystem. At least that was the case on SCO UnixWare (No, I no longer run it). LER regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop

[HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). I'm thinking about attempting it for an inside project here at work, but was wondering if there was community interest? Thanks! -- Larry Rosenman

Re: [HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
On Mon, 21 Jan 2008, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). Depends on how big and ugly it is, I think. If you can do it just by hacking CFLAGS

Re: [HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
On Tue, 22 Jan 2008, Gregory Stark wrote: Tom Lane [EMAIL PROTECTED] writes: Larry Rosenman [EMAIL PROTECTED] writes: would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). Depends on how big and ugly it is, I think

[HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
owner. Shouldn't everything that is in the DB be owned by the purported owner? This is on 8.2.3, btw. Thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
On Mon, 16 Apr 2007, Andrew Dunstan wrote: Larry Rosenman wrote: Greetings, I think I found a bug, or at least a POLA violation. At work, I created a user that is NOT a superuser, nor can that user create databases. When I did a create database foo owner bar, all the schemas are set

Re: [HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
On Mon, 16 Apr 2007, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: When I try and RESTORE a pg_dump in the current state, we get errors because the public schema is owned by postgres, and the grant commands are issued as the user (since I'm restoring as the purported owner. That's

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-09 Thread Larry Rosenman
on it. This will take a week or 2, but I have permission now. (This box can get out to the internet via our proxy). LER Cheers, Adrian Maier -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-09 Thread Larry Rosenman
On Mon, 9 Apr 2007, Tom Lane wrote: Larry Rosenman ler@lerctr.org writes: I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets fixed, and assuming either the bundled compiler will work or I can get GCC on it. If the bundled compiler is still the same non-ANSI-C weakling

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-07 Thread Larry Rosenman
question is: 1) what os(s) do we need more coverage on 2) what collection of options for OS' in 1? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
On Fri, 6 Apr 2007, Andrew Dunstan wrote: Larry Rosenman wrote: It doesn't matter as far as MY box is concerned. I use VMWare extensively in my current $DAYJOB, and I want to be able to test/play with things related to that as well. The box I'm building will be using the (free) VMWare

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
On Fri, 6 Apr 2007, Stefan Kaltenbrunner wrote: Andrew Dunstan wrote: Larry Rosenman wrote: It doesn't matter as far as MY box is concerned. I use VMWare extensively in my current $DAYJOB, and I want to be able to test/play with things related to that as well. The box I'm building

[HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-05 Thread Larry Rosenman
. What OS's do we need coverage for? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-05 Thread Larry Rosenman
I might use that as the base then, since the hardware finishes getting here tomorrow. My question still stands on what OS's we need coverage for. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona

Re: [HACKERS] Possible Bug: high CPU usage for stats collector in 8.2

2007-03-02 Thread Larry Rosenman
. The stats collector CPU usage has dropped from inexcess of 95% to 5% Thanks. Any guess on when we'd see an 8.2.4? I have a business reason for asking. Thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US

Re: [HACKERS] BuildFarm: Do we need another FreeBSD/amd64 member?

2007-02-08 Thread Larry Rosenman
I can set up build farm on it if yall need it. Its running 6.2/amd64 --- Original Message --- From: Andrew Hammond [EMAIL PROTECTED] To: Larry Rosenman ler@lerctr.org Sent: 2/8/07, 12:19:07 PM Subject: Re: BuildFarm: Do we need another FreeBSD/amd64 member? On Jan 19 2006, 9:36 pm

Re: [HACKERS] gBorg status?

2006-09-02 Thread Larry Rosenman
No, since my time is up in the air at the moment, I've bowed out for now. Once I get settled at Surgient, I might take it up again, but not right now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby Sent: Saturday, September 02, 2006 5:42

Re: [HACKERS] Autovacuum on by default?

2006-08-24 Thread Larry Rosenman
both autovacuum and manual vacuum as well as analyze (both from the Autovacuum daemon and manual). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] Autovacuum on by default?

2006-08-17 Thread Larry Rosenman
. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [HACKERS] Autovacuum on by default?

2006-08-17 Thread Larry Rosenman
Bruce Momjian wrote: Larry Rosenman wrote: Alvaro Herrera wrote: Bruce Momjian wrote: Matthew T. O'Connor wrote: Bruce Momjian wrote: Matthew T. O'Connor wrote: and increasing the log level when autovacuum actually fires off a VACUUM or ANALYZE command. This was not done because

Re: [HACKERS] Autovacuum on by default?

2006-08-17 Thread Larry Rosenman
, delete) since the last stats reset, then the vacuum info isn't recorded because we refuse to create the pgstat entry for the table. Do I need to write a Doc patch for that? It seemed consistent with other functions of the same class when I did the date patch. -- Larry Rosenman

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

2006-08-15 Thread Larry Rosenman
I've used and use RT. It is web based for admin, but all the transactions are E-Mail based. http://www.bestpractical.com I can also make a test queue on my instance if someone wants to play. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683

Re: [HACKERS] Change in Pervasive's PostgreSQL strategy

2006-07-25 Thread Larry Rosenman
about that. I'd like to echo Jim's sentiment. The last 9 months here have been great, and the community is still as wonderful as ever. I hope I've been a positive asset to both Pervasive and the community (mailing-list and IRC). -- Larry Rosenman Database Support Engineer PERVASIVE

Re: Anyone still care about Cygwin? (was Re: [HACKERS] [CORE] GPL Source and Copyright Questions)

2006-06-23 Thread Larry Rosenman
on the host for this? I might be able to use either my house machine or my work desktop here @pervasive, or one of my test boxes here @pervasive. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop

Re: [HACKERS] [CORE] GPL Source and Copyright Questions

2006-06-22 Thread Larry Rosenman
. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [HACKERS] Test request for Stats collector performance improvement

2006-06-15 Thread Larry Rosenman
on a dual-xeon in 64-bit mode. HTT *IS* enabled. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---(end of broadcast

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-09 Thread Larry Rosenman
) on FreeBSD/amd64, Dual Xeon's in HTT mode help? What can I do to further the investigation? It has 8.1.4 on it. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-08 Thread Larry Rosenman
: Intel(R) Xeon(TM) CPU 3.00GHz hw.ncpu: 4 hw.byteorder: 1234 hw.physmem: 4286132224 hw.usermem: 4003151872 hw.pagesize: 4096 hw.floatingpoint: 1 hw.machine_arch: amd64 hw.realmem: 5368709120 [snip] the database is 8.1.4 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1

Re: [HACKERS] Going for all green buildfarm results

2006-06-02 Thread Larry Rosenman
---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Larry Rosenman said: If I generate fixes for firefly (I'm the owner), would they have a prayer Of being applied? Sure, although I wouldn't bother with 7.3 - just take 7.3 out of firefly's build schedule. That's not carte blanche

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Larry Rosenman wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Larry Rosenman said: If I generate fixes for firefly (I'm the owner), would they have a prayer Of being applied? Sure, although I wouldn't bother with 7.3 - just take 7.3 out of firefly's build schedule

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Larry Rosenman wrote: Larry Rosenman wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Larry Rosenman said: If I generate fixes for firefly (I'm the owner), would they have a prayer Of being applied? Sure, although I wouldn't bother with 7.3 - just take 7.3 out

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread Larry Rosenman
of the people have no idea how it is set up. I truly *WANT* to help here, but getting the information is tough. Larry Rosenman -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread Larry Rosenman
of testing? I remember reading something abou this as well but the big question is: Where is the scripting? it's in an admin project on pgfoundry, and VERY lacking in details. It assumes a LOT of knowledge that is not readily apparent. -- Larry Rosenman Database Support

Re: [HACKERS]

2006-05-19 Thread Larry Rosenman
section of the documentation. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end of broadcast

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
been shot down. How is this different? -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: Larry Rosenman wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: I thought about this. Attached is a patch you can use to popen(pg_config) and then look for the thread flag to configure. One idea would be to add this sample to our libpq documentation

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: Larry Rosenman wrote: Bruce Momjian wrote: Larry Rosenman wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: I thought about this. Attached is a patch you can use to popen(pg_config) and then look for the thread flag to configure. One idea would

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: Larry Rosenman wrote: Bruce Momjian wrote: Larry Rosenman wrote: Bruce Momjian wrote: Larry Rosenman wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: I thought about this. Attached is a patch you can use to popen(pg_config) and then look

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: Uh, it is an _admin_ function, not an application programmer function. but libpq is the only thing that knows where it is, and I had proposed a way for psql to use the function to get it. It'd make more sense for pg_config

[HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Larry Rosenman
for it. Thanks, Larry Rosenman -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end of broadcast

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Larry Rosenman
the logging? I still don't see a consensus on what needs to come out. Do we still need the autovacuum_verbosity type change? LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax

Re: [HACKERS] sblock state on FreeBSD 6.1

2006-05-03 Thread Larry Rosenman
see a direct hit looking at the routines we talked about yesterday, but I can't be sure. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web

Re: [HACKERS] Logging pg_autovacuum

2006-05-02 Thread Larry Rosenman
Simon Riggs wrote: On Fri, 2006-04-28 at 22:38 +0200, Martijn van Oosterhout wrote: On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote: Martijn van Oosterhout kleptog@svana.org writes: You know, rather than adding new columns to pg_class, why not extend the stats collector

[HACKERS] patch review, please: Autovacuum/Vacuum times via stats.

2006-05-02 Thread Larry Rosenman
, it includes docs as well. Thanks! LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end of broadcast

Re: [HACKERS] patch review, please: Autovacuum/Vacuum times via stats.

2006-05-02 Thread Larry Rosenman
Larry Rosenman wrote: Greetings, I've got a patch to be reviewed for having the stats system keep track of the last time a table was vacuumed or analyzed either by the user or via AutoVacuum. The patch is at: http://www.lerctr.org/~ler/pg-dev/vacuum-autovacuum-times-stats.diff I'd

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
still reading code to see whether I can determine at the time they are cut that this was autovacuum that did it. Thanks for the nice introductory project :) LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
Jim C. Nasby wrote: On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote: Since both vacuum and autovacuum will be cutting stats records, do we want to just have the autovacuum stats record have the fact that it was autovacuum that did the vacuum? Or, is there a way when vacuum

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
Larry Rosenman wrote: Jim C. Nasby wrote: On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote: Since both vacuum and autovacuum will be cutting stats records, do we want to just have the autovacuum stats record have the fact that it was autovacuum that did the vacuum

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Larry Rosenman wrote: Simon Riggs wrote: On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I'd like to see a more concrete definition of what we want Autovacuum to output and at what levels. autovacuum_verbosity Should we call

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Robert Treat wrote: On Friday 28 April 2006 12:09, Larry Rosenman wrote: Larry Rosenman wrote: Simon Riggs wrote: On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I'd like to see a more concrete definition of what we want Autovacuum to output

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
(as a relative noobie) to do. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end of broadcast

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Martijn van Oosterhout wrote: On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote: Martijn van Oosterhout kleptog@svana.org writes: You know, rather than adding new columns to pg_class, why not extend the stats collector to collect this information. That sounds doable. And a lot

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
, and it is very flexible. We definitely need to do something wrt autovacuum messages, but this doesn't say what gets logged at what level for autovacuum. I'd like to see a more concrete definition of what we want Autovacuum to output and at what levels. LER -- Larry Rosenman Database

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I'd like to see a more concrete definition of what we want Autovacuum to output and at what levels. I would argue that what people typically want is (0) nothing (1) per-database log messages or (2

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
--- This sounds like a winner to me. Anyone else want to grab it? I'm in the position to try and do this, but don't want to step on anyone else's toes. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
that made all of autovac's vacuums be VERBOSE. I was thinking along those exact lines. (A 3rd level). LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
people select it with log_min_messages. regards, tom lane I was going to make that same comment, as this seems to be more implementation detail, which should be at DEBUGn. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
Simon Riggs wrote: On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I'd like to see a more concrete definition of what we want Autovacuum to output and at what levels. autovacuum_verbosity Should we call it autovacuum_messages? In current

Re: [HACKERS] Unresolved Win32 bug reports

2006-04-20 Thread Larry Rosenman
the following batch file with arguments of 40 40 1000 is almost guaranteed to trigger the problem, though... @echo off dropdb bench createdb bench pgbench -i -s %1 bench pgbench -t %3 -c %2 -n bench It seems to hang up just fine on my XPSP2, PG 8.1.2 HTT box. :( LER -- Larry Rosenman

Re: [HACKERS] Unresolved Win32 bug reports

2006-04-20 Thread Larry Rosenman
Larry Rosenman wrote: Jim C. Nasby wrote: On Thu, Apr 20, 2006 at 08:06:30PM +0200, Magnus Hagander wrote: It reuqires a multi-CPU box, right? I don't hav eone with pgwin32 on ATM. Do you know if it's enough with hyperthreading? Hrm... not sure. Let me see if I can find a box with HT here

[HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
distro changes it, and you then overwrite parts of it, it would be useful for diagnostics. Comments? LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: 1) expose DEFAULT_PGSOCKET_DIR via a libpq call 2) add this information to the psql --version output (or some other switch, I'm agnostic). pg_config would seem to be the appropriate place, not libpq nor psql. The issue is when you

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Darcy Buskermolen wrote: On Tuesday 28 March 2006 14:07, Larry Rosenman wrote: Greetings, After helping a user on irc, I was wondering if there would be any objection to my making a patch that would: 1) expose DEFAULT_PGSOCKET_DIR via a libpq call 2) add this information to the psql

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman ler@lerctr.org writes: Tom Lane wrote: pg_config would seem to be the appropriate place, not libpq nor psql. The issue is what psql (and any libpq using program) is going to use to find the UNIX socket. No, the issue is where the server put the socket

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman ler@lerctr.org writes: The other issue is borked installs where the server and libpq disagree. What I'm looking for is to expose what libpq has for it's default as well as what the server is using. There is currently no way to determine what libpq has

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman ler@lerctr.org writes: That's making the assumption that you know which libpq. I was hoping to have a psql commandline Switch to dump the info, but with your objection(s), I'll just crawl back under my rock. It's not that I don't feel your pain ... but if you

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
that the windows code doesn't enable HAVE_UNIX_SOCKETS, and therefore even if the library returns a string, it's useless. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman ler@lerctr.org writes: What's the harm of a (pseudo code): const char *PQgetunixsocketdir(void) { return(DEFAULT_PGSOCKET_DIR) } In libpq, and a psql command line switch to call it. By the time you get done adding the infrastructure

Re: [HACKERS] [SUGGESTION] CVSync

2006-03-23 Thread Larry Rosenman
the new diffs (optionally compressed) from the ,v files that are needed to bring the clients' repository mirror up to date. As a complete out of nowhere suggestion, you might also look at csup in FreeBSD's CVS (or the project page), which is a cvsup clone in C. LER -- Larry Rosenman

Re: [HACKERS] Updated email signature

2006-02-18 Thread Larry Rosenman
in 1975. Started posting on UseNet in 1988. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---(end of broadcast

Re: [HACKERS] Updated email signature

2006-02-18 Thread Larry Rosenman
-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Cleaning up the INET/CIDR mess

2006-01-25 Thread Larry Rosenman
of that. Please do **NOT** change the I/O formats. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast

[HACKERS] BuildFarm: Do we need another FreeBSD/amd64 member?

2006-01-19 Thread Larry Rosenman
Greetings, I've got a fast FreeBSD/amd64 server available to run Buildfarm on. However, I see we already have a couple of others running it. My questions are: 1) do we need another one? 2) if yes, what options need coverage? Thanks, LER -- Larry Rosenman

Re: [HACKERS] BuildFarm: Do we need another FreeBSD/amd64 member?

2006-01-19 Thread Larry Rosenman
Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I've got a fast FreeBSD/amd64 server available to run Buildfarm on. However, I see we already have a couple of others running it. My questions are: 1) do we need another one? 2) if yes, what options need

[HACKERS] FW: PGBuildfarm member firefly Branch HEAD Failed at Stage Check

2006-01-16 Thread Larry Rosenman
(SCO UDK) / 4.2 For more information, see http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=fireflybr=HEAD This is a Stats failure. I thought the latest change Tom put in would fix it. I guess not. How can I help? LER -- Larry Rosenman http://www.lerctr.org/~ler

[HACKERS] FW: Intermittent Stats Failiures: firefly: HEAD

2006-01-11 Thread Larry Rosenman
Reposting, since it seems to not have made it :( Larry Rosenman wrote: Ever since the stats collector changes, I've seen intermittent failures on 'firefly' in the buildfarm. This is my machine. There is one posted now, and the history has them as well. Could someone look and tell me

Re: [HACKERS] ISO 8601 Intervals

2006-01-09 Thread Larry Rosenman
Michael Glaesemann wrote: On Jan 8, 2006, at 12:12 , Larry Rosenman wrote: I was thinking of handling the TODO for ISO8601 Interval output. Just to be clear, you're talking about the ISO8601 duration syntax (PnYnMnDTnHnMnS), correct? (The SQL standard made the unfortunate choice

[HACKERS] ISO 8601 Intervals

2006-01-07 Thread Larry Rosenman
, but got a bounce :( Thanks, LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---(end of broadcast)--- TIP 1

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-03 Thread Larry Rosenman
, and I have a DynDns.org Hostname that changes to support that, as well as a CNAME out of my domain to Point to it. Just more things to think about. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-03 Thread Larry Rosenman
Bruno Wolff III wrote: On Tue, Jan 03, 2006 at 12:08:46 -0600, Larry Rosenman [EMAIL PROTECTED] wrote: The issue is folks that DON'T set reverse DNS, I.E. have generic rDNS set on their IP's. I've seen (in my ISP days, and on my mailserver) LOTS of folks that can't/won't update

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-29 Thread Larry Rosenman
the 4.11-FreeBSD guy refered to above, and with a very simple table, it comes right back with NO results, but I may not have what it's looking for in the table definition. I **DO** get the explain failure, which seems, to me, to be a bug. :( LER -- Larry Rosenman, Database Support Engineer, E

Re: [HACKERS] server closed connection on a select query

2005-11-22 Thread Larry Rosenman
Sorry for the top post. If you can get a UDK license, that will work better. LER On Nov 22, 2005, at 12:02 PM, Guillaume Lelarge wrote: Sorry for answering this late. 2005/11/16, Larry Rosenman ler@lerctr.org: Bruce Momjian wrote: The SCO compiler is so buggy (and for so many years) I

  1   2   3   4   5   6   7   8   >