Re: [GENERAL] How large can a PostgreSQL database get?

2013-04-17 Thread Mark Felder
On Wed, 17 Apr 2013 08:23:41 -0500, Aleksey Tsalolikhin wrote: Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are looking to switch to open source to cut their licensing costs, and was asked how large a database does PostgreSQL support? Is there an upper bound on datab

Re: [GENERAL] How to analyze load average ?

2012-08-06 Thread Mark Felder
On Mon, 06 Aug 2012 10:27:18 -0500, Tomas Vondra wrote: Although the OP mentioned he's using ext4, so I suppose he's running Linux (although I know there was some ext4 support e.g. in FreeBSD). Still, the load average 0.88 means the system is almost idle, especially when there's no I/O acti

Re: [GENERAL] How to analyze load average ?

2012-08-06 Thread Mark Felder
On Mon, 06 Aug 2012 09:38:33 -0500, Tomas Vondra wrote: Load average is defined as a number of processes in the run queue That depends on if he's running Linux or BSD. http://www.undeadly.org/cgi?action=article&sid=20090715034920 -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

2012-03-18 Thread Mark Felder
On Sat, 17 Mar 2012 10:46:00 -0500, dennis jenkins wrote: Aleksey, a suggestion: The vast majority of the postgresql wire protocol compresses well. If your WAN link is not already compressed, construct a compressed SSH tunnel for the postgresql TCP port in the WAN link. I've done this when

Re: [GENERAL] SSDs with Postgresql?

2011-04-28 Thread Mark Felder
On Thu, 28 Apr 2011 17:27:04 -0500, Basil Bourque wrote: So, while I can't specifically recommend their products, I certainly suggest considering them. Customer of ours is probably lurking on here. We host their servers in our datacenter -- we had a UPS go "pop" after an amazing surge an

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-13 Thread Mark Felder
On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh wrote: I have program work with bytea, this field store image. Program work well in postgresql 8.3.9 but error in postgresql 9.0 I don't know if this is your problem, but bytea changed in Postgres 9.0. Could you try enabling "set bytea_ou

Re: [GENERAL] Do we want SYNONYMS?

2010-12-06 Thread Mark Felder
On Mon, 06 Dec 2010 15:09:04 -0600, Tom Lane wrote: though I think it is possible to do in Oracle. I'm not a DBA but the DBA I closely worked with at my last job had me do maintenance on a VPN that went to another company -- basically we had synonyms on both ends that let our databases b

Re: [GENERAL] advise on performance issues please

2010-11-30 Thread Mark Felder
On Tue, 30 Nov 2010 04:34:32 -0600, Gregory Machin wrote: running on a vmware ESXi 4.1 host - 4 x 2.4 GHz cpus AMD 6 cores each, 96 Gig ram, storage is provided by HP Left hand SAN iSCSI. Does the VM do iSCSI itself to get access to the filesystem on the SAN, or is this just a generic set