Hi,
In fact it is difficult to answer to that questions as they depend of how big is your
database, how many simultaneous connections you
have, ... etc
But, I can help you by giving you my results on a Bi-CPU Xeon 2.6 GHz , 4 Gb RAM,
external 2 x RAID0 on four disks each with Redhat
9.0.
1) Co
Tom Lane wrote:
Stephan Szabo <[EMAIL PROTECTED]> writes:
It's not really any different than other errors. The commit doesn't
complain (although it also doesn't actually commit anything).
People have occasionally suggested that the command tag from a COMMIT
should read "ABORT" or "ROLLBACK" if
We're planning on using veritas filesystem and volume manager with linux
and an hitachi disk array. I'm wondering if anyone has any experiences
with veritas fs and vm on linux and hitachi both good and bad.
Also, has anyone compared veritas fs with any of the other linux
filesystems, like xfs a
On Thu, 29 Jan 2004 17:00:27 -0800
Mark Harrison <[EMAIL PROTECTED]> wrote:
> We observed that there was postmaster connected to the ip address
> of the downed machine with an "in transaction" status. Killing
> that processes unblocked the other processes.
>
> Is this expected behavior? Was po
--On Friday, January 30, 2004 09:48:28 -0500 Trevor Astrope
<[EMAIL PROTECTED]> wrote:
We're planning on using veritas filesystem and volume manager with linux
and an hitachi disk array. I'm wondering if anyone has any experiences
with veritas fs and vm on linux and hitachi both good and bad.
A
Jeff <[EMAIL PROTECTED]> writes:
> Eventually PG would have found out the socket was dead.
We do enable TCP keepalive on the client socket, so eventually the
kernel will time out and notify us of a lost connection. Unfortunately
the timeouts involved are long --- IIRC the relevant RFCs specify at
Hope you don't mind if I disagree. Most OS's that have a tcp/ip layer also have a
parameter therein called tcp_keep_alive. They also set this parameter to infinity.
The purpose of tcp_keep_alive is to have the OS kernel periodically verify that all
tcp/ip connections it is managing are still
Hi everybody!
Does anybody knows how can I change the size (something about 4Mb) of
the files inside the pg_xlog directory and how can I have no more than
one file inside it.
Would be nice a quick explanation about the efects of it.
Thanks for all
--
Daniel Henrique Debonzi Linux user number
Hi there,
I'm trying to install tsearch2 and got an error :
Makefile:5: ../../src/Makefile.global: No such file or directory
Makefile:47: /contrib/contrib-global.mk: No such file or directory
gmake: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
For your information, firstly, I'm
I'm having some issues dumping a database from 7.2, reloading it to 7.4.
I'm using the 7.4 pg_dump. The problem I'm having is an issue of internal
object dependancies. For instance I have a_function that uses b_function. The
a_function gets dumped in first, and errors out because b_function hsan't
I am migrating a database from SQLServer to PostgreSQL and I want to know if exists some tool to execute tests to see if the functionality of the triggers and stored procedures still the same?
Thanks, and sorry for the terrible english...
Well, after living with the (depreciated) Money datatype for 5 years, I think
its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH
easier transition). What's the preferred monetary datatype? numeric(10,2)?
float4? float8? We're dealing only with US Dollars.
CG
_
We recently had an unexpected san outage which caused
our postgresql to stop pg_dumpall'ing properly. As a
unix admin, not a db person, i'm short on ideas for
what I should try next.
some base info:
RHAS2.1 box
postgresql-libs-7.1.3-4bp.2
postgresql-jdbc-7.1.3-4bp.2
postgresql-tk-7.1.3-4bp.2
pos
We recently had an unexpected san outage which caused
our postgresql to stop pg_dumpall'ing properly. As a
unix admin, not a db person, i'm short on ideas for
what I should try next.
some base info:
RHAS2.1 box
postgresql-libs-7.1.3-4bp.2
postgresql-jdbc-7.1.3-4bp.2
postgresql-tk-7.1.3-4bp.2
pos
On Fri, Jan 30, 2004 at 10:55:13 -0800,
Chris Gamache <[EMAIL PROTECTED]> wrote:
> Well, after living with the (depreciated) Money datatype for 5 years, I think
> its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH
> easier transition). What's the preferred monetary da
Bruno Wolff III wrote:
On Fri, Jan 30, 2004 at 10:55:13 -0800,
Chris Gamache <[EMAIL PROTECTED]> wrote:
Well, after living with the (depreciated) Money datatype for 5 years, I think
its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH
easier transition). What's the pref
Daniel Henrique Debonzi <[EMAIL PROTECTED]> writes:
> Does anybody knows how can I change the size (something about 4Mb) of
> the files inside the pg_xlog directory
You can't, short of hacking the source code (and I'm not sure it's a
one-line change if you do...)
> and how can I have no more than
Chris Gamache <[EMAIL PROTECTED]> writes:
> I'm having some issues dumping a database from 7.2, reloading it to 7.4.
> I'm using the 7.4 pg_dump. The problem I'm having is an issue of internal
> object dependancies.
> ...
> There must be a better way! Thoughts?
This is (at long last) fixed in deve
18 matches
Mail list logo
