Kevin Keith wrote:
I am coming from an Oracle background - which in the case of bulk data
loads there were several options I had where I could disable writing to
the redo log to speed up the bulk data load (i.e. direct load, set the
user session in no archive logging, set the affected tables to
Tom Lane wrote:
William Yu <[EMAIL PROTECTED]> writes:
If you have enough memory, you can always make a ramdisk to store the
WAL temporarily while you bulk load data. I also temporarily alter the
config to set checkpoint_segments = 1 to use as few pg_xlog files as
possible.
Really?
Benjamin Krajmalnik wrote:
We are currently inserting about 1 million rows per day, and will
increase to probably 5 million once it goes into full deployment.
It is currently running on a 3GHz Xeon HT, 2GB RAM, dual 72GB disks
running RAID 1. This server is a 1U without only 2 drive bays, so
Geoffrey wrote:
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will include vpn connectivity from one site to another. It ap
scott.marlowe wrote:
Note that if you're on an IDE drive and you haven't disabled the write
cache, you may as well turn off fsync as well, as it's just getting in the
way and doing nothing, i.e. the IDE drives are already lying about fsync
so why bother.
What about Serial ATA?
-
Danielle Cossette wrote:
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
I've run 7.1, 7.2 and 7.3 on Solaris 8 x86 and Solaris 9 x86. 7.1
install, config, run was nearly 100% hands-off. 7.3 takes setting
LD_LIBRARY_PAT
Ivan wrote:
I use the MySQL database on the web for the forum and for a news system. I
would like to know what are the advantages of pgsql over MySQL. I am
entering in the world of databases so i don't know much as I am 16 years
old.
For a forum & news system, there's probably zero difference/adva
Joe Conway wrote:
Jonathan Gardner wrote:
$ ./configure --with-openssl
I forget the exact reason, but I ran into this before. There is some
kind of dependency between openssl and kerberos 5. Try:
./configure --with-openssl --with-krb5=/usr/kerberos
I have to do this with Apache also on Redhat
Also for this time we do not have any problems with oracle servers (and
we have had many power downs).
> (...stuff...)
>
We found that ext3 is less stable comparing to reiserfs and we need to
use fsck.
We are using ~300 tables with ~3M rows (max) .
Also we are using mostly dual pentium + IDE disks.
Jose Mendoza wrote:
How can be efectivly configured the PostgreSQL to run in a machine with
2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work with the 2
processors?
I had run tests and the tiems is always the same that in a computer with
1 CPU pentium 4 2.4GHz and 2GB RAM.
The way it wo
Bhartendu Maheshwari wrote:
Dear Hal, Frank, Oli and all,
I understand what you all trying to say, I know this is not good way of
designing, but we are planning for using the database for the keeping
mobile transactions and at the same time we need to provided the HA
solutions. The one solution i
The answer is simple. Don't use floating point for money.
Sai Hertz And Control Systems wrote:
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
Also I would like to learn how professional users of PostgreSQL work
with r
/usr/local/lib probably is not in your library path.
Try the following commands before running initdb (or any other pg
program for that matter):
LD_LIBRARY_PATH=/usr/local/lib:/lib:/usr/lib:/usr/ccs/lib
export LD_LIBRARY_PATH
Fabiàn R. Breschi wrote:
Dear All,
I'm trying to get my db initial
Erwin Brandstetter wrote:
CPU:
Single AMD Opteron.
Opteron, because i plan to migrate to amd64 debian as soon as Debian
has a stable release.
Single, because multi-CPU would only make sense if the CPU could ever
get the bottleneck. But I don't have to fear that, right? No need for a
dual-cpu set
Shane | SkinnyCorp wrote:
I would like to also add that I've been a sysadmin for quite some time, and
I've been designing databases for quite some time as well. I'm no idiot, I
just can't find the bottleneck here (if one does in fact exist). So in light
of this, please send me some suggestions I ca
William Yu wrote:
There are cases where seqscan will be faster than indexscans. For
example, your query to retrieve the latest 25 threads -- always faster
using seqscan. If it was using indexscan, that would explain the 9
seconds to run because the HD heads would have to jump back & forth
No. I gave it a try and postgres refused to start up.
Jesper Krogh wrote:
Is it possible to migrate from 7.4.3 - i386 to 7.4.6 - x86-64 without a
dump and restore?
Jesper
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
John Jensen wrote:
Hi Greg & others.
I run this on a 4 cpu smp box (Dell PE6650+EMC AX100) so I already
offload pg_dump, gzip and split to other cpu's. Top confirms this:
postmaster = 95% cpu ie. it uses one cpu completely. Unless I can get
postmaster to do less work (that's what I'm looking for) o
Iain wrote:
Upon further investigation, I think this the way to go, specificaly
I'llbe recommending the 320-2 as I plan to put the WAL and DB on
seperate channels and partitions (as opposed to to putting them on the
same logical partition split over the two channels).
SOmething to think about. L
Iain wrote:
Hi William,
SOmething to think about. Let's suppose a channel/cable completely
dies. How would you protect against it? Split a logical mirror device
over 2 channels.
This effectively implements RAID 0+1, right? RAID 1 (mirroring) over
RAID 0 striped volumes. I can certainly see your
Iain wrote:
As bytepile has it, failure of 1 disk in 0+1 leaves you with just RAID 0
so one more failure on the other pair and your data is gone. On the
other hand, failure of 1 disk in raid 10 leaves you with a working raid
1 that can sustain a second failure.
What they're saying is in the case
I've used a slew of LSI controllers (22915A, integrated 53C1010,
22320-R, MegaRAID 320-1) and they've all performed w/o issues. Now I
have had some hardware die though. One was probably our fault -- during
an attempted upgrade, we probably weren't careful enough with the
22320-R (cramped [EMAIL PRO
Iain wrote:
> Thanks to all for your feedback on this.
>
> I'm looking forward to getting my hands on the system.
>
> It seems that the battery backed cache is an important factor, though I
> havn't found any information specifically concerning this on the tyan
> site. I can't tell if it's an
I've been able to do Solaris x86 -> Linux x86 copies. But I'm pretty
sure Sparc & x86 are not compatible endian-wise so hence the data is not
stored the same. Other attempts that have failed -- Linux x86 32bit -->
Linux x86_64.
Vlad Harchev wrote:
On Sat, Apr 09, 2005 at 08:42:19PM +0200, Peter
Archie MacDonald (rsh) wrote:
I am following the instructions in the techdocs for solaris 8 ( see
link below) and I am trying to
instal readline 4.2a first. It has not went well so far ...:-(
Easiest way to get tools installed on Solaris ... go to
www.sunfreeware.com. They've got readline, gcc, e
25 matches
Mail list logo
