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
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
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
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 ELF.
--
Larry Rosenman
On 2016-02-10 17:00, Tom Lane wrote:
Larry Rosenman 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, even when the locale is such that
)
Ugh.
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,
On 2015-11-24 13:43, Alvaro Herrera wrote:
Larry Rosenman wrote:
On 2015-11-24 13:11, Tom Lane wrote:
>Kevin Grittner writes:
>>On Tue, Nov 24, 2015 at 11:10 AM, Tom Lane wrote:
>>>>change the From header (and add a Reply-To, so replies still work).
>
>>If t
e that, but perhaps those things trigger some popular antispam
heuristics.
regards, tom lane
Any Header or Body changes will invalidate most, if not all, DKIM
signatures. Since DKIM is used as part
of DMARC, it's a problem.
Not sure what MajorDomo2 will allow
I was not complaining; I think JSONB is awesome.
But I am one of those people who would like to put 100's of GB (or more)
JSON files into Postgres and I am concerned about file size and possible
future changes to the format.
On Fri, Aug 8, 2014 at 7:10 PM, Peter Geoghegan wrote:
> On Fri, Aug
Apologies if this is a ridiculous suggestion, but I believe that swapping
out the compression algorithm (for Snappy, for example) has been discussed
in the past. I wonder if that algorithm is sufficiently different that it
would produce a better result, and if that might not be preferable to some
o
pply SSH access 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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 3/7/2012 2:42 PM, Tom Lane wrote:
> Larry Rosenman 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. Mea
CUUM FULL.
>
+1. I think we should update ps_status as well as pg_stat_activity as
all of these table rewrite 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.or
-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
> wrote:
>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1
>>
>> Is there any way to get more info out of CLUSTER VERBOSE so it
>>
60953511 nonremovable row
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 Ros
But by using the above code: how do we deal with multiple matching values?
For example:
java
c++
In this case, perhaps I would want something like
---+-
my_question | java
my_question | c++
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/
ion-bump? Is there a link somewhere?
AFAIR, it was stated if Hot Standby 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...@le
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
ke 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 Ros
Greetings, Please help provide a chm file for 8.4b2. Unlike prior Windows
installations, the postgreSQL.chm is absent. This file format provides very
valuable searching capabilities.
Appreciatively! --LS
Larry Silvermintz, Ph.D.| Biologist & Engineer
(510) 705-1432
--
Sent
largefiles option, 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
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
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
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 Ros
ckers@postgresql.org; Larry McGhaw
Subject: Re: [HACKERS] Selecting a constant question: A summary
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> In the case of a SELECT query that selects a fixed constant of any
> sort, it would be a definite improvement for PostgreSQL to give so
to encounter
this problem .. Its just been covered up by assigning
An arbitrary maximum size .. So I guess we will do the same and make it
configurable like the official postgres driver.
Thanks
lm
-Original Message-
From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
That one surprised me as well.
Thanks
lm
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 12, 2007 12:00 PM
To: Larry McGhaw
Cc: Brian Hurt; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Selecting a constant question
Larry McGhaw wrote
t '123'::varchar(3) libpq returns the following:
Pqfsize returns -1
Pqfmod returns -1
Thanks
lm
-Original Message-
From: Brian Hurt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 12, 2007 11:09 AM
To: Larry McGhaw
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Sele
ne out of the
box.
It is in your hands now :)
Thanks
lm
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 12, 2007 4:50 AM
To: Larry McGhaw
Cc: Hannu Krosing; Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark;
Martijn van Oosterhout; pgsql-hack
of the 1st column in the
resultset is 3 ... it cant be any more plain than that.
Thanks
lm
From: Hannu Krosing [mailto:[EMAIL PROTECTED]
Sent: Mon 6/11/2007 10:43 PM
To: Larry McGhaw
Cc: Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van
Oosterh
uot; postgres in our application until it is
addressed.
Thanks
lm
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 6/11/2007 5:32 PM
To: Larry McGhaw
Cc: Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van Oosterhout;
pgsql-hackers@postgresql.org
Subject: Re: [
e; Gregory Stark; Martijn van Oosterhout;
pgsql-hackers@postgresql.org; Larry McGhaw
Subject: Re: [HACKERS] Selecting a constant question
Dann Corbit wrote:
> If the server bound the data as UNICODE, then it will tell me
> UNICODE(3). I know how big this will be.
>
> In the worst cas
e; Gregory Stark; Martijn van Oosterhout;
pgsql-hackers@postgresql.org; Larry McGhaw
Subject: Re: [HACKERS] Selecting a constant question
Dann Corbit wrote:
> If the server bound the data as UNICODE, then it will tell me
> UNICODE(3). I know how big this will be.
>
> In the worst case s
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 purp
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 to
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
On Mon, 9 Apr 2007, Tom Lane wrote:
Larry Rosenman 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 tha
r I can get
GCC 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: 4
ing Solaris, my 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
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 buildi
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 (fr
---
TIP 5: don't 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
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 V
as buildfarm clients.
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
.c does fix this issue.
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-Ma
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 "
Sent: 2/8/07, 12:19:07 PM
Subject: Re: BuildFarm: Do we need another FreeBSD/amd64 member?
On Ja
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
info about regular (manual) vacuums, so
> the above scenario still applies.
They do. The stats patch as applied captures both autovacuum and manual
vacuum
as well as analyze (both from the Autovacuum daemon and manual).
--
Larry Rosenman http://www.lerctr.org/~ler
Pho
ty
>>> table to see if autovacuum is doing something right now, but what I
>>> want to be able to do is look through my logs and see that
>>> table_foo hasn't been vacuumed since last week, or that table_bar
>>> has been vacuumed 7 times today.
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:
>>>>>>
>>
at it's *currently* doing, but it
> doesn't let you know what has happened in the last day or whatever.
> It can't answer "has table foo been vacuumed recently?" or "what
> tables haven't been vacuumed at all during this week?"
I added last vacuum
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
ted to mention, though.
>
> First, I'm now officially looking for work. :) So is Larry.
>
> Second, Pervasive is keeping me employed until the end of August, so
> I'll continue posting from this email address and using this signature
> until then.
>
> While it's di
t; a port. If we can't find anyone who cares enough about Cygwin to
> host a regularly-scheduled buildfarm member, I'm for blowing it off.
>
What all's needed on the host for this?
I might be able to use either my house machine or my work desktop
here @pervasive, or one of m
asks, the files I wrote in contrib/mac are free to be licensed
any way the
project sees fit.
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
--
SD. This was done
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
--
terday (39ms without explain analyze, 280+ with explain
analyze)
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-M
BLE #59: Thu Jun
1 09:40:47 CDT 2006
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/THEBIGHONKER amd64
$ sysctl hw
hw.machine: amd64
hw.model: 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_ar
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
>>>>&
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?
>>
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
y (I'm the owner), would they have a prayer
Of being applied?
LER
>
> regards, tom lane
>
> ---(end of
> broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
--
Larry Rosenman http://w
I *thought* was already written, just needed alot
>> 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
e of how each is set up, is resident in a very small minority of
the
folks that help run things.
I have Pervasive's blessing to spend paid time working on "community"
projects,
and this could be one of them, but every time I try to get more
information about
how things on BOTH gborg
your table/index/relation.
see the storage 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
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 t
Bruce Momjian wrote:
> Larry Rosenman wrote:
>> Bruce Momjian wrote:
>>> Larry Rosenman wrote:
>>>> Bruce Momjian wrote:
>>>>> Larry Rosenman wrote:
>>>>>> Tom Lane wrote:
>>>>>>> Bruce Momjian writes:
>>
Bruce Momjian wrote:
> Larry Rosenman wrote:
>> Bruce Momjian wrote:
>>> Larry Rosenman wrote:
>>>> Tom Lane wrote:
>>>>> Bruce Momjian writes:
>>>>>> I thought about this. Attached is a patch you can use to
>>>>>&
Bruce Momjian wrote:
> Larry Rosenman wrote:
>> Tom Lane wrote:
>>> Bruce Momjian 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.
>>>>
x27;ve proposed libpq functions to expose compile-time
constants, I've 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
Emai
ble?
I.E. capture all the verbose info somewhere?
Or, do people just want to increase 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
PERVA
or 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 broa
t we don't block when
>>> attempting to write to these sockets?
>>
>> Well, we have the socket set to O_NONBLOCK mode. Whether that avoids
>> the problem you're seeing ...
>
> A quick grep through the source code doesn't look too promising, so
> m
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/vacuu
review, 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
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 writes:
>>>>> You know, rather than adding new columns to pg_class, why not
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
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?
ag to set that says this
(vacuum|analyze) was done by the autovacuum daemon?
I agree that the existing stats calls are good, but I'm 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 :)
Martijn van Oosterhout wrote:
> On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote:
>>> Martijn van Oosterhout writes:
>>>> You know, rather than adding new columns to pg_class, why not
>>>> extend the stats collector to collect this information.
&
or me (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)--
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:
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 Autovac
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.
>>
>> aut
7;m happy if we just emit that at DEBUG1 and let 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
D
wever, it might be cleaner if we allowed a "level 3" 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-
ng on it.
LER
>
---
>
>>>
>>
>> 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
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) noth
t 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 Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA T
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?
>>
>>
g up just fine on my XPSP2, PG 8.1.2 HTT box.
:(
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
---(e
Tom Lane wrote:
> "Larry Rosenman" 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.
systems (since I think 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 M
Tom Lane wrote:
> "Larry Rosenman" 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
Tom Lane wrote:
> "Larry Rosenman" 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
&g
Tom Lane wrote:
> "Larry Rosenman" 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.
&
Bruno Cassol wrote:
> Hi, my teacher want's me to find out and explain how PgSQL stores
> data fisically! I've done searches but could not find it. Please help
> me!
>
Read the docs. It's all in there.
LER
--
Larry Rosenman http://www.lerctr
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 libp
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 a
some 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: [
1 - 100 of 828 matches
Mail list logo