Re: [GENERAL] Linux ready for high-volume databases?

>Don't think of this as a troll, because I really don't know, even >though I do know that MVS, OpenVMS & Solaris can. (I won't even >ask about toys like Windows and FreeBSD.) What so toy in Windows? With some experience on huge DBs, one on Windows ( MS SQL 2K ) works x1.5/2 faster, than one on L

Re: [GENERAL] deleting referenced data

On Tuesday 26 August 2003 18:55, Bruno Wolff III wrote: > On Tue, Aug 26, 2003 at 18:34:04 +0100, > > Richard Huxton <[EMAIL PROTECTED]> wrote: > > On Tuesday 26 August 2003 15:06, Andreas Fromm wrote: > > > When I delete a record of the table realtions I also want to delete the > > > record on t

Re: [GENERAL] Linux ready for high-volume databases?

> Online backups with archived transaction logs are the next big killer feature > (the last one remaining?) for 24x7 operation I think. I believe this is at least theoretically possible using Linux device layer tricks. Using network block devices, you can have a network RAID1, with the transactio

Re: [GENERAL] Buglist

> "TL" == Tom Lane <[EMAIL PROTECTED]> writes: TL> Just nice'ing the VACUUM process is likely to be counterproductive TL> because of locking issues (priority inversion). Though if anyone cares TL> to try it on a heavily-loaded system, I'd be interested to hear the TL> results... tried it onc

Re: [GENERAL] pl/tcl trigger question

Ok the way you could do this is as follows: create or replace function my_lowercase() returns trigger as ' foreach id [array names NEW] { set NEW($id) [string tolower $NEW($id)] } return [array get NEW] ' language 'pltcl'; HTH Darren On 26 Aug 2003, Robert Treat wrote: > On Tue, 2003-

Re: [GENERAL] Fwd: installing postgres7.3.4 problem II

On Tue, Aug 26, 2003 at 18:40:12 +0200, javier garcia - CEBAS <[EMAIL PROTECTED]> wrote: > Please, disregard my last message. I've discovered that in "password" file it > was mentioned a path '/var/lib/psql' where Mandrake distro installed postres > previously. I've solved it. > > But I still

Re: [GENERAL] Fwd: installing postgres7.3.4 problem II

javier garcia - CEBAS wrote: Please, disregard my last message. I've discovered that in "password" file it was mentioned a path '/var/lib/psql' where Mandrake distro installed postres previously. I've solved it. But I still have another problem: A later step in Postgres installation instructio

Re: [GENERAL] Bulk Insert / Update / Delete

Thanks Jason. The UPDATE part works fine. However, INSERT still gives problems. For now, I'm inserting hard coded values, and not from one table into the other. I use UPDATE telephones SET telephone_type='CELL', telephone_number=836789012 WHERE data_set='AA' AND account_number=8 AND dependant_num

Re: [GENERAL] deleting referenced data

On Tue, Aug 26, 2003 at 18:34:04 +0100, Richard Huxton <[EMAIL PROTECTED]> wrote: > On Tuesday 26 August 2003 15:06, Andreas Fromm wrote: > > > > When I delete a record of the table realtions I also want to delete the > > record on the data-tables if there is no other record referencing them. > >

Re: [GENERAL] Linux ready for high-volume databases?

Vivek Khera <[EMAIL PROTECTED]> writes: > I run a 24x7x365 db on FreeBSD which has *never* crashed in the 3 > years it has been in production. Only downtime was the upgrade from > PG 7.1 to 7.2 and once for a switchover from RAID5 to RAID10. I would be interested to know what backup strategy

Re: [GENERAL] deleting referenced data

On Tuesday 26 August 2003 15:06, Andreas Fromm wrote: > > When I delete a record of the table realtions I also want to delete the > record on the data-tables if there is no other record referencing them. > How can I do this? You want to add "ON DELETE CASCADE" to the REFERENCES... clause. See the

Re: [GENERAL] Linux ready for high-volume databases?

On Tue, 26 Aug 2003, Al Hulaton wrote: > After seeing this article yesterday, I did a bit of research. One _big_ reason > why Sourceforge/VA/OSDN is moving over to IBM/Webshere/DB2 from PostgreSQL is > the resulting product will be jointly marketed by Sourceforge and IBM's > zillions of sales p

Re: [GENERAL] WAL Files checkpoint_timeout with voluminous delete/insert

Hi Tom, (sorry again but no answer about this any idea ?) Le Vendredi 22 Août 2003 22:43, Tom Lane a écrit : > =?iso-8859-15?q?Herv=E9=20Piedvache?= <[EMAIL PROTECTED]> writes: > > I have a dedicated partition on the disk for the WAL files, 2Gb. > > > > So I start my script and saw the size of the

Re: [GENERAL] [PERFORM] Best tweak for fast results.. ?

actually, isin't 1000 tps pretty good? Ron Johnson wrote: On Tue, 2003-08-26 at 08:42, JM wrote: need input on parameter values on confs... our database is getting 1000 transactions/sec on peak periods.. sitting on RH 7.3 2.4.7-10smp RAM: 1028400 SWAP: 2040244 queries are just simple selec

Re: [GENERAL] is linux ready for databases ? (Ziff Davis article

Yup, me too. Unthought out techspeak. Mike Mascari wrote: Gregory S. Williamson wrote: One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database.

Re: [GENERAL] [PERFORM] Best tweak for fast results.. ?

On Tue, 2003-08-26 at 08:42, JM wrote: > need input on parameter values on confs... > > our database is getting 1000 transactions/sec on peak periods.. > > sitting on RH 7.3 > 2.4.7-10smp > RAM: 1028400 > SWAP: 2040244 > > queries are just simple select statements based on timestamps, varchars.

Re: [GENERAL] is linux ready for databases ? (Ziff Davis article

On Tue, 2003-08-26 at 08:47, Mike Mascari wrote: > Gregory S. Williamson wrote: > > > One of our sysads sent this link ... wondering if there > > is any comment on it from the world of actual users > > of linux and a database. > > > >

Re: [GENERAL] Linux ready for high-volume databases?

On Tue, Aug 26, 2003 at 09:15:14AM -0700, Al Hulaton wrote: > Perhaps the PostgreSQL team bidding for the job, if any were even consulted, > didn't frame the project as IBM did -- a product joint venture. It's a good > tactic and I don't blame Sourceforge one bit for the opportunity. Well, since

Re: [GENERAL] installing postgres7.3.4 problem

javier garcia - CEBAS writes: > # su - postgres > (I don't know the meaning of a "login shell", but this is not my problem) > And then appears the message (in spanish): > "su: atention: we can't change to the directory /var/lib/pgsql: the directory > or file doesn't exists" > > Previously I had p

Re: [GENERAL] Database recovery after fs crash

> Hmm, presumably you don't have those. Unfortunately not. All backup measures I took failed on the exact same occasion - worst case possible. > I usually start by browsing files by hand to see if I can determine > from any embedded text which table it was. Seems easy enough. > Then if you crea

Re: [GENERAL] Index usage and wrong cost analisys

Look through the docs. By altering the values of random_page_cost, effect_cache_size and cpu_tuple_cost you can make the estimates approximate real life better. On Tue, Aug 26, 2003 at 12:32:23PM +0100, Pedro Alves wrote: > > > > One more thing I just noticed. Right after making a vacuum an

Re: [GENERAL] Linux ready for high-volume databases?

On Tue, 2003-08-26 at 03:06, Shridhar Daithankar wrote: > On 26 Aug 2003 at 2:55, Ron Johnson wrote: > > > On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote: > > > One of our sysads sent this link ... wondering if there is any comment on it > > > from the world of actual users of linux and

Re: [GENERAL] Database recovery after fs crash

On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote: > Wow. Take to pull out those backups... > > Hmm, presumably you don't have those. There are programs to read postgresql > data files however they need to know the exact structure of the table before > you can even start to de

Re: [GENERAL] Excel 97 Export to Postgres

On Tuesday 26 August 2003 09:10 am, Raymond wrote: > Need to export an existing M$ Access 97 database to Postgres. > > Tuples must be filtered as I am using sequences and other constraints. > > Help from anyone that has experience with this or know of 3rd party > automation tools would be greatly a

[GENERAL] Fwd: installing postgres7.3.4 problem II

Please, disregard my last message. I've discovered that in "password" file it was mentioned a path '/var/lib/psql' where Mandrake distro installed postres previously. I've solved it. But I still have another problem: A later step in Postgres installation instructions says: "/usr/local/pgsql/bin

Re: [GENERAL] pl/tcl trigger question

On Tue, 2003-08-26 at 07:28, Jules Alberts wrote: > Hello everyone, > > I'm working on a tiny trigger function that needs to ensure that all > values entered in a field are lowercase'd. I can't use pl/pgsql because > I have a dozen different columns (with different names) that need a > trigger

Re: [GENERAL] installing postgres7.3.4 problem

On Tue, Aug 26, 2003 at 18:10:10 +0200, javier garcia - CEBAS <[EMAIL PROTECTED]> wrote: > # su - postgres > (I don't know the meaning of a "login shell", but this is not my problem) > And then appears the message (in spanish): > "su: atention: we can't change to the directory /var/lib/pgsql: th

Re: [GENERAL] is linux ready for databases ? (Ziff Davis article

Gregory S. Williamson wrote: > One of our sysads sent this link ... wondering if there > is any comment on it from the world of actual users > of linux and a database. > > I found the following paragra

Re: [GENERAL] Buglist

Bruce Momjian wrote: Jan Wieck wrote: Manfred Koizar wrote: > On Thu, 21 Aug 2003 21:10:34 +0530, "Shridhar Daithankar" > <[EMAIL PROTECTED]> wrote: >>Point I am trying to make is to tune FSM and autovacuum frequency >>such that you catch all the dead tuples in RAM > > You might be able to catch

Re: [GENERAL] Index usage

Pedro Alves <[EMAIL PROTECTED]> writes: > The vacuum analyze is run on daily basis, so that cannot be the point. The next thing I'd try to improve the planner's guess is to increase the statistics target for the ra_datacolh column (see ALTER TABLE SET STATISTICS). It looks like the default of 10

[GENERAL] deleting referenced data

Hi, I have The following situation: CREATE TABLE data1 ( id SERIAL PRIMARY KEY, data INTEGER ); CREATE TABLE data2 ( id SERIAL PRIMARY KEY, data INTEGER ); CREATE TABLE data3 ( id SERIAL PRIMARY KEY, data INTEGER ); CREATE TABLE relations ( id SERIAL PRIMARY KEY, data1 INT

[GENERAL] Excel 97 Export to Postgres

Need to export an existing M$ Access 97 database to Postgres. Tuples must be filtered as I am using sequences and other constraints. Help from anyone that has experience with this or know of 3rd party automation tools would be greatly appreciated. Raymond ---(end of bro

Re: [GENERAL] many columns with references to one table

Andreas Fromm <[EMAIL PROTECTED]> writes: > My problem is that the references to the phones table do not get > restricted, i.e. I can insert any value in the phone*-fields, while the > references to the other tables are restricted to values that allready > exists. Hard to believe --- and I coul

[GENERAL] row level locks

How do we acquire row level locks in postgresql and is there any feild in LOCK or PROCLOCK datastructes (src/include/storage/lock.h) that tells us the lock is row-level? thanks _ Enter for your chance to IM with Bon Jovi, Seal, Bow

[GENERAL] Linux ready for high-volume databases?

On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote: > One of our sysads sent this link ... wondering if there is any comment on it from > the world of actual users of linux and a database. > > "W

Re: [GENERAL] Index usage

On Mon, 25 Aug 2003, Pedro Alves wrote: > The querys below are exactly the same but refer to different months. > One case uses indexes, the other doesn't. > > Is there anything I can do? Increasing index mem size? Run "vacuum analyze". The planner seems to think that one of the queries

Re: [GENERAL] convert database to unicode

--- Gianni Mariani <[EMAIL PROTECTED]> wrote: > David Lutz wrote: > > >Hello, I want to convert an existing database with > >SQL_ASCII encoding to UNICODE encoding. > > > >(postgresql ver 7.3.2) > > > >I thought that it might be as easy as: > >pg_dump mydatabase > dump.sql > >createdb --encoding

Re: [GENERAL] move to usenet?

On Tue, 2003-08-26 at 08:40, Dennis Gearon wrote: > Hee Hee, but I _**LIKE**_ top quoting. That's good. Top-quoting is good. Top posting, on the other hand, is bad. It's also what you did. Stephen -- Stephen Robert Norris <[EMAIL PROTECTED]> CommSecure Australia Pty Ltd -

Re: [GENERAL] table constraints and performance

Besides the performance issues, I think it's correct to detect refreshes before sending data to the database. In our applications, we ignore refreshes from the begining. We do it by sending a serial number, which we keep on a session variable. Every time we send a page to a client, we increme

Re: [GENERAL] Replication Ideas

Chris Travers <[EMAIL PROTECTED]> writes: > Yes I have. Postgres-r is not a high-availability solution which is > capable of transparent failover, What makes you say that? My understanding is it's supposed to survive loss of individual servers. regards, tom lane ---

[GENERAL]

One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database. Greg Williamson DBA GlobeXplorer LLC ---(e

Re: [GENERAL] move to usenet?

Hee Hee, but I _**LIKE**_ top quoting. Greg Stark wrote: Oh the irony. "Chris M" <[EMAIL PROTECTED]> writes: I use outlook express to visit news.postgresql.org now. It works well. "David W Noon" <[EMAIL PROTECTED]> news:[EMAIL PROTECTED] On Tuesday 19 Aug 2003 09:06 in <[EMAIL PROTECTE

Re: [GENERAL] timeofday() and CAST

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Hmm... I'm seeing Chile standard timezones, so it's not a matter of how > big the country is. However, in the table at > src/backend/utils/adt/datetime.c I'm seeing conflict between BST > (British Summer Time), BST (Brazil Standard Time) and BST (Bering

Re: [GENERAL] Database recovery after fs crash

Wow. Take to pull out those backups... Hmm, presumably you don't have those. There are programs to read postgresql data files however they need to know the exact structure of the table before you can even start to decode them. I usually start by browsing files by hand to see if I can determine fro

Re: [GENERAL] convert database to unicode

David Lutz wrote: Hello, I want to convert an existing database with SQL_ASCII encoding to UNICODE encoding. (postgresql ver 7.3.2) I thought that it might be as easy as: pg_dump mydatabase > dump.sql createdb --encoding=unicode newdatabase psql newdatabase < dump.sql but it wasn't going to be t

[GENERAL] is linux ready for databases ? (Ziff Davis article on Oracle and Linux)

Perhaps a subject line would help ... -Original Message- From: Gregory S. Williamson Sent: Monday, August 25, 2003 2:28 PM To: '[EMAIL PROTECTED]' Subject: One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a datab

Re: [GENERAL] Buglist

Jan Wieck wrote: > Manfred Koizar wrote: > > On Thu, 21 Aug 2003 21:10:34 +0530, "Shridhar Daithankar" > > <[EMAIL PROTECTED]> wrote: > >>Point I am trying to make is to tune FSM and autovacuum frequency > >>such that you catch all the dead tuples in RAM > > > > You might be able to catch the pag

[GENERAL] convert database to unicode

Hello, I want to convert an existing database with SQL_ASCII encoding to UNICODE encoding. (postgresql ver 7.3.2) I thought that it might be as easy as: pg_dump mydatabase > dump.sql createdb --encoding=unicode newdatabase psql newdatabase < dump.sql but it wasn't going to be that easy now was

Re: [GENERAL] move to usenet?

Dennis Gearon wrote: > I prefer NOT to have to scroll down to the bottom of an email anyway. I > think discussion list emails like ours need to be like your medical > records, the most important, recent stuff is at the top. I do often top-post, and I didn't realize it was an issue until this wee