On Mon, Oct 20, 2003 at 08:09:34AM -0400 I heard the voice of
Jeff, and lo! it spake thus:
>
> insured shipping. But yeah, new scsi is quite expensive, but it can be
> worth it... IMHO scsi is to be used in a raid, not alone. No one disk
> can saturate the bw offered. (both ide and scsi).
T
Some sort of ATA Raid is probably worth considering -
e.g. I am experimenting with a system using 2 ATA-66 Seagates + 1
Promise TX2000
The disks themselves give fairly poor performance when attached to the
std IDE channels :
sequential write 15Mb/s
sequential read 20Mb/s
But attached to the Pr
How do you get the last value of a sequence without
having called nextval? phppgadmin displays last value
for sequences (I haven't found out how yet rooting
through the code).
CSN
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://sho
Ben-Nes Michael writes:
> 1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed,
> efficiency )
PostgreSQL might work better on "simple" file systems, so you avoid making
the head run all over the place for writing its own log and the PostgreSQL
log. Some have even suggeste
Hi Ben,
You asked so here's my take on the subject, but I've gotta say that you
can't go far wrong with reading Bruce Momjian's paper at:
http://www.ca.postgresql.org/docs/momjian/hw_performance/
But with that aside.
1. Unless your doing major league DB stuff, the FS should make more
than m
On Mon, Oct 20, 2003 at 03:23:39PM -0400, Daniel E. Fisher wrote:
> Ok...ran into problems backing database up.
>
> trying to run pg_dumpall > backup102003
>
> gives me
>
> Database version 7.3.3 compiled by gcc 2.96
> Archiver DB ver 7.1.3
> Aborting cause of version mismatch.
Huh... apparen
This site:
http://fsbench.netnation.com/
has some decent generic file system benchmarks that may help with your
decision.
On Mon, 2003-10-20 at 10:32, Murthy Kambhampaty wrote:
> You'd be well served if you could benchmark several filesystems and see
> which one gives the best "performance" (tal
On Monday 20 October 2003 10:28 am, scott.marlowe wrote:
> On Mon, 20 Oct 2003, Peter Childs wrote:
> > On Mon, 20 Oct 2003, Shridhar Daithankar wrote:
> > > A fast HD with a good RAID controller. Subject to budget, SCSI
> > > are beter buy than IDE. So does hardware SCSI RAID.
> >
> > I hate a
Stephen wrote:
Nope, I installed the RedHat 9 myself and no one else has access to this
machine. It's either that Redhat uses a different elevator setting for SCSI
drives than IDEs or the latest Redhat updates I applied brought it to my
current numbers. Besides, I believe your values may indicate a
--- CSN wrote:
> > >> Feature request - add "reload" to
> > /etc/init.d/postgres
> >
> > ># /etc/init.d/postgresql
> > >Uso: /etc/init.d/postgresql
> >
>
>{start|stop|status|restart|condrestart|reload|force-reload}
> >
> > >You should tell us what OS you are using.
>
> Redhat 9. I just looked
On Sun, 2003-10-19 at 22:51, Ling Xiaoyu wrote:
> Hello there.
> Can anybody help me with Postgresql triggers?
> what I need is a trigger which update value of field
> "tables_rows.total_rows" to rows count of table
> "zzz" if I insert new row in table "zzz"...
>
> CREATE TABLE zzz (
> ...
>
On Monday 20 October 2003 16:19, Cláudia Morgado wrote:
> Tom Lane,
>
> This problem was solved with the suggested permission.
>
> GRANT USAGE ON SCHEMA wlog_data TO wlog_uni;
>
> There is the possibility of us to consult the permission above in the
> database?
SELECT * FROM pg_namespace ;
For ta
Hello,
Also you should really upgrade to 7.3.4.
Sincerely,
Joshua Drake
Martin Marques wrote:
El Lun 20 Oct 2003 10:19, Daniel E. Fisher escribió:
I can't get a rest for a min guys.
I go away for the weekend and my server is getting this error.
Fatal error: Call to undefined function: pg
13 matches
Mail list logo
