Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-22 Thread Andrew Rawnsley
There are some less expensive baby-SAN options coming out now - Dell has an rebranded EMC baby SAN (which of course doesn't work with any other EMC system...) that starts at about $6000 or so. Just read the announcement - don't know anything else. While there have been some reports of

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-22 Thread Matt Clark
How about iSCSI? This is exactly what it's for - presenting a bunch of remote SCSI hardware as if it were local. There are several reference implementations on SourceForge from Intel, Cisco others. I've never tried it myself, but I would if I had the need. And let's face it there are some

Re: [PERFORM] [BULK] Problems with vacuum!

2004-06-22 Thread Domenico Sgarbossa
As you suggets I've tried to upgrade to the kernel 2.4.28, but it seems that nothing change! I built a new machine with Red Hat 8 (kernel 2.4.28) a 1GB RAM using the same parameters i've been used before. After the boot, i've got 800Mb of free memory, if a launch a pg_dump then the system swap

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-22 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | What exactly are you trying to gain, avoid, or do? Gain: seperate database storage from processing. This lets me move clusters from one server to another easily. Just stop the postgres instance on server A and unmount it's filesystem. Then mount it

[PERFORM] postgresql and openmosix migration

2004-06-22 Thread Bill
Hi, I am trying to make a cluster out of any database, postgresql or mysql or any other free database. I have looked at openmosix patched with the migshm patch for shared memory support and it seems that neither work fully. Postgresql in particular uses "shared memory but not the system

Re: [PERFORM] reindex and copy - deadlock?

2004-06-22 Thread Litao Wu
Hi, I have changed reindex table my_table to: psql ... -c drop index my_index; create index my_index; We still experience the same hang problem. I was told that this time, the process is create index my_index; before the PG server is bounced. When I login the database, I found the my_index

Re: [PERFORM] Hi!

2004-06-22 Thread Josh Berkus
Janio, I am trying install the postgresql-7.4.3 simple installation. I did ./configure command at the postgresql directory source. While the configuring proccess I receiving the follow message: This is the wrong list for this question. Please try PGSQL-ADMIN. You're much more likely to get

[PERFORM] after using pg_resetxlog, db lost

2004-06-22 Thread Shea,Dan [CIS]
The pg_resetxlog was run as root. It caused ownership problems of pg_control and xlog files. Now we have no access to the data now through psql. The data is still there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But there is no reference to 36 of our tables in pg_class. Also the

Re: [PERFORM] postgresql and openmosix migration

2004-06-22 Thread Matthew Nuzum
Hi Bill, I am more often in the needing help category than the giving help when it comes to advise about using postgresql. I have found it to be an extremely powerful tool and by far the best performance/price for my work. I think you will get some excellent answers and help to your performance

Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-22 Thread Tom Lane
Shea,Dan [CIS] [EMAIL PROTECTED] writes: The pg_resetxlog was run as root. It caused ownership problems of pg_control and xlog files. Now we have no access to the data now through psql. The data is still there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But there is no

Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-22 Thread Richard Huxton
Tom Lane wrote: Shea,Dan [CIS] [EMAIL PROTECTED] writes: The pg_resetxlog was run as root. It caused ownership problems of pg_control and xlog files. Now we have no access to the data now through psql. The data is still there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But there

Re: [PERFORM] postgresql and openmosix migration

2004-06-22 Thread Joe Conway
Bill wrote: Ok, so maybe someone on this group will have a better idea. We have a database of financial information, and this has literally millions of entries. I have installed indicies, but for the rather computationally demanding processes we like to use, like a select query to find the