Re: [PERFORM] Slow vacuum performance

2004-06-21 Thread Andrew McMillan
On Fri, 2004-06-18 at 19:51 -0700, Patrick Hatcher wrote: > > Thanks! > > My effective_cache_size = 625000 > > I thought that having the shared_buffers above 2k or 3k didn't gain > any performance and may in fact degrade it? Hi Patrick, Quoting from: http://www.varlena.com/varlena/GeneralBi

Re: [PERFORM] pg_fetch_array

2004-06-21 Thread Richard Huxton
Thanks wrote: Hello I would like to know the performance of pg_fetch_array. Cosider the code: $query = "select * from foo"; $result = pg_query( $db, $query ); while ($row = pg_fetch_array($result)) { $a = $row["a"]; $b = $row["b"]; $c = $row["c"]; $d = $row["d"]; } Does php need to

Re: [PERFORM] Slow vacuum performance

2004-06-21 Thread Patrick Hatcher
Thanks! Patrick Hatcher Andrew McMillan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/21/04 03:11 AM To Patrick Hatcher <[EMAIL PROTECTED]> cc [EMAIL PROTECTED] Subject Re: [PERFORM] Slow vacuum performance On Fri, 2004-06-18 at 19:51 -0700, Patrick Hatcher wrote: > >

[PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We're looking for an alternative to fiber-channel disk arrays for mass storage. One of the ideas that we're exploring would involve having the cluster on an NFS mounted filesystem. Another technology we're looking at is the Linux NBD (Network Block Devi

Re: [PERFORM] Pl/Pgsql Functions running simultaneously

2004-06-21 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marcus Whitney wrote: | Am I on the wrong list to ask this question, or does this list usually have | low activity? Just asking because I am new and I need to know where to ask | this question. Thanks. Your .sig may hold the reason why people are not

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Tom Lane
Andrew Hammond <[EMAIL PROTECTED]> writes: > We're looking for an alternative to fiber-channel disk arrays for mass > storage. One of the ideas that we're exploring would involve having the > cluster on an NFS mounted filesystem. Another technology we're looking > at is the Linux NBD (Network Block

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Andrew Rawnsley
On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We're looking for an alternative to fiber-channel disk arrays for mass storage. One of the ideas that we're exploring would involve having the cluster on an NFS mounted filesystem. Another technology we

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Scott Marlowe
On Mon, 2004-06-21 at 20:46, Andrew Rawnsley wrote: > On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote: > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > We're looking for an alternative to fiber-channel disk arrays for mass > > storage. One of the ideas that we're exploring would i