On 12 May 2004, at 12:17 PM, Manfred Koizar wrote:
On Tue, 11 May 2004 15:46:25 -0700, Paul Tuckfield [EMAIL PROTECTED]
wrote:
- I'll bet you have a low value for shared buffers, like 1. On
your 3G system
you should ramp up the value to at least 1G (125000 8k buffers)
In most cases this is
I've been using a PGSQL 7.3.1 system as my development box for some time, and so far,
it worked fine. (This is running on Slackware distro with a 2.2.19 kernel under VMWare
4)
However, yesterday, I added a column to a base table (that is inherited by several
other tables). Shortly afterwards,
Gordon Ross [EMAIL PROTECTED] writes:
I've been using a PGSQL 7.3.1 system as my development box for some time, and so
far, it worked fine. (This is running on Slackware distro with a 2.2.19 kernel under
VMWare 4)
However, yesterday, I added a column to a base table (that is inherited by
4. Do whatever it takes in the psql session to provoke crash. gdb
should announce that the backend has gotten a signal 11. Now say
gdb bt
gdb quit
and send along the output of bt.
Program received signal SIGSEGV, Segmentation fault.
0x806ba0a in nocachegetattr () at eval.c:88
88
Gordon Ross [EMAIL PROTECTED] writes:
4. Do whatever it takes in the psql session to provoke crash
and send along the output of bt.
Program received signal SIGSEGV, Segmentation fault.
0x806ba0a in nocachegetattr () at eval.c:88
88 eval.c: No such file or directory.
(gdb) bt
#0
switchboards=# \d DNOwner;
Table public.DNOwner
Column| Type | Modifiers
-+-+
Id | integer | not null default nextval('DNOwner_id_seq'::text)
ExDirectory |
Hello all:
I have a customer with an application in production (postgres + php +
apache) where we began seeing a number of scary messages in the logs. (It's
postgres 7.2.1, by the way).
Generally the messages seem to point to resource starvation of some kind:
FATAL 1: out of free buffers:
Gordon Ross [EMAIL PROTECTED] writes:
switchboards=# select * from DNOwner;
server closed the connection unexpectedly
The DNOwner table is the base table. There are other tables that inherit from this
table, and doing a simple select on those produce the same result.
Hmm. Does 'select *
*SIGH* Oh, well. I suppose I should have updated up development machine a while ago.
./configure; make here we come.
Thank you for looking at this. At least I can be re-assured that the problem is fixed
in later versions of Postgres.
GTG
Tom Lane [EMAIL PROTECTED] 05/12/04 20:36 PM
Gordon
Steve Lane [EMAIL PROTECTED] writes:
I have a customer with an application in production (postgres + php +
apache) where we began seeing a number of scary messages in the logs. (It's
postgres 7.2.1, by the way).
^^
Reading the CVS logs for post-7.2.1 bug fixes will curl your
From: Tom Lane [EMAIL PROTECTED]
Date: Wed, 12 May 2004 16:13:37 -0400
To: Steve Lane [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] RAM usage per connection
Steve Lane [EMAIL PROTECTED] writes:
I have a customer with an application in production (postgres + php +
apache)
On Tue, 11 May 2004 15:46:25 -0700, Paul Tuckfield [EMAIL PROTECTED]
wrote:
- the cache column shows that linux is using 2.3G for cache. (way too
much)
There is no such thing as way too much cache.
you generally want to give memory to postgres to keep it close to
the user,
Yes, but only a
Hi,
at first, many thanks for your valuable replies. On my quest for the
ultimate hardware platform I'll try to summarize the things I learned.
-
This is our current setup:
Hardware:
Dual Xeon DP 2.4 on a TYAN S2722-533 with HT enabled
Jie Liang [EMAIL PROTECTED] writes:
You will see AAA associate with 'whatever', it's an internal variable,
but how could I use it in my SQL query?
regression=# \set AAA 'whatever'
regression=# select :AAA;
ERROR: column whatever does not exist
regression=# \set AAA '\'whatever\''
regression=#
Thank you, Tom.
Jie
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:06 PM
To: Jie Liang
Cc: Christian Kratzer; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [ADMIN] [SQL] \set
Jie Liang [EMAIL PROTECTED] writes:
You will see AAA
15 matches
Mail list logo