On Friday 05 January 2007 21:05, Erik Jones wrote:
> Quick question, when running a VACUUM query through the postmaster,
> does it use the external vacuumdb tool?
No, quite the opposite; the 'vacuumdb' simply invokes the VACUUM command in
the postmaster. vacuumdb along with reindexdb, createdb,
Hullo :)
We have pg 8.1.3 and for whatever reason (network blips, poor pooling on
behalf of the client, etc.) we sometimes see a large number (dozens) of
old connections in the idle state which never get reused.
Is there a function in postgres similar to MySQL's 'wait_timeout' which
automat
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
At a guess rip = return instruction pointer, rsp = return stack point.
The fact that they're all the same seems to rule out hardware.
That's good to hear (in one way... :)
fore st
Hi, our 8.1.3 system on quad Xeon has been happily chugging away for
weeks with no stability problems until yesterday:
/var/log/syslog:May 4 11:57:17 cayenne kernel: postmaster[19291]:
segfault at rip 2b5e8c00 rsp 7fffd418
error 4
/var/log/syslog.0:May 3 09:3
On Tue, 25 Apr 2006 10:06:12 -0700
Bill Moseley <[EMAIL PROTECTED]> wrote
> Ok. So as someone that tried to understand pinning once and gave up,
> do you pin the packages or use:
>
> apt-get -t sarge-backports install postgresql
>
> method?
As per the instructions on the site - you use bo
Bill Moseley wrote:
Anyone installed 8.1 on Stable? Did you build from source or use a
backport?
Very simple www.backports.org :)
They have 8.1.3 and it works perfectly.. even the -contrib package is
there for cube/earthdistance, and the -dev package is there if you want
to compile Slon
On Sun, 09 Apr 2006 17:00:14 +0100
Simon Riggs <[EMAIL PROTECTED]> wrote:
> On Sat, 2006-04-08 at 15:10 +0100, Gavin Hamill wrote:
>
> > SELECTS go to *both* live and test, but only the answers from live
> > are sent back to clients - the answers from test ar
On Sun, 09 Apr 2006 17:00:14 +0100
Simon Riggs <[EMAIL PROTECTED]> wrote:
> Sniff the live log for SELECT statements (plus their live durations),
Wow, how wonderfully low-tech - hence it's right up my street :) Yay,
some tail + psql fun coming up!
Cheers,
Gavin.
---(end
Hi,
I'm asking here in case this kind of thing has been done before, but
I've not been able to find it..
We have two pg 8.1.3 servers, one live and one test. What I'd like to do
is have something like pgpool to act as a connection broker, but
instead of using pgpool's own replication where all qu
On Wed, 29 Mar 2006 11:22:11 -0500
Seneca Cunningham <[EMAIL PROTECTED]> wrote:
>
> Are "0x800" and "0x400" typos in this message, or did you really
> request less than 256MB? Those numbers are the number of bytes
> requested for the heap and memory is set aside in 256MB segments.
No,
Seneca Cunningham wrote:
You're using a 32-bit build with the default memory model, it would
seem. You're limited to less than 256MB for the heap in that model.
Try stopping the postmaster and starting it back up with the
environment variable LDR_CNTRL set to "MAXDATA=0x8000". This
expa
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
2006-03-28 14:15:35 BSTLOG: autovacuum: processing database "laterooms"
TopMemoryCont
Tom + Seneca,
Thank you for your sage advice - hopefully I will have enough Linux +
compilation experience to bridge the AIX gap - no doubt if I run into
big problems, you'll hear about it soon! :)
Cheers,
Gavin,
---(end of broadcast)---
TIP
Hullo :)
We're a Linux shop, and are getting an IBM pSeries 650 with AIX
preloaded on Friday - I have no AIX experience, and was looking for info
about compiling pg 8.1.3 on AIX, since it's the only app that will run
on the machine. First, are there any precompiled packages? :))
Basically, i
14 matches
Mail list logo
