However the result was (running on 64bit Sol 7, E250/1Gig
RAM) that Oracle was roughly twice as fast. Is this real
or might there be stuff I could do, to improve postgres
performance?
PostgreSQL version?
7.0.2
Try 7.1 or use -F.
You didn't use -F, did you?
What's -F ?
A quick question:
Have someone made effort to do profiling of pgsql during execution of
certain things (inserts, selects, sorting, indices)?
I have a feeling (based on stopping postgres from gdb periodically), that
a lot of time is used in strcoll() (if table and index has string
columns).
Okay, that's basically what I tried on my 7.1b3 system which
worked, both with quantity as int2 and int4. It'll probably
work there. In the mean time, what kinds of queries are you
using this in, maybe a subselect would work as a temporary fix.
On Sat, 3 Feb 2001, Anand Raman wrote:
hi
First of all 7.1 is great! I'm using beta4 and it seems to be working
very well.
Thank's particularly for the SQL92 join syntax (though union joins
would be usefull).
I have a problem though and I'm not sure if it's a bug or not so I
thought I'd discuss it here first.
The synopsis of the
I've noticed that the PostgreSQL Programmer's Guide (ISBN: 0595149170
)is availabe in print now. Does anyone know if the user, and admin
guides will be offered down the road as well? I realize you can dl them
from the site. Because of the number of pages, I'd rather buy it in
printed form.
Is there any way to have up to the minute recovery from a disk
failure in postgres?
Is there a timeframe for the recover from WAL feature?
Thanks,
Alex.
Thanks for the info, Raid is definitely in the picture,
I'm worried about the less likely but definitely possible case where
your entire raid array gets smoked (or just the two disks you care about)
and I don't want to recover from a 24 hour backup.
The two options I can see are one way
On Fri, 2 Feb 2001, adb wrote:
Is there any way to have up to the minute recovery from a disk
failure in postgres?
RAID1? :)
Is there a timeframe for the recover from WAL feature?
If you are asking if WAL logs can be reapplied to an database dump, the
answer is currently no. I think it'd be
Francisco,
Excellent idea.
Thanks for the info. Is this what you are doing now? And if so, since the
current version does not appear to have replication, have you found a
workaround?
-Michael
-Original Message-
From: Francisco Reyes [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Is there a way (in plpgsql) to know if an insert, update or delete
instruction was successful without having to run a select statement
after either one?
Something like an error flag, a set of instructions, a process...
Thanks again.
Any one written a shell or php script that runs
pg_dump on a db say everyday or something?
Any suggestions?
thanks,
Matt
Friedman
This is simple, but it's what I use to do my daily dumps (run from
crontab) -- I took out some stuff specific to my application..Replace
database with the name of the database..
#!/bin/sh
pgpath=/usr/local/pgsql/bin
homepath=/home/postgres
backup=/usr/local/pgsql/backup
today=`date
Not 'transaction'. If previous operation _failed_, you won't even get to
next instruction. What you are asking whether previous statement updated
any rows. I _think_ in 7.1 you can do that, but I don't remember how.
-alex
On Fri, 2 Feb 2001, Alfonso Peniche wrote:
Is there a way (in plpgsql)
I desperately need to get Postgresql 7 running on either a RaQ2 or
RaQ3i. I have tried getting help on the Cobalt list-server and at
Cobalt but the only response I get is that it will effect my GUI .
Since I have been a long supporting Mac user the conversion to the
Linux environment
Here's a simple PHP script that I use. You can backup only certain
databases or the whole server. I'm actually planning on making this part of
the phpPgAdmin package. You can specify how many days you want the backup
files to remain.
-Dan
#!/usr/bin/php -q
?php
15 matches
Mail list logo
