Re: [GENERAL] How large can a PostgreSQL database get?
On Wed, 17 Apr 2013 08:23:41 -0500, Aleksey Tsalolikhin atsaloli.t...@gmail.com 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 database size and if so, what it is? According to yahoo...: http://glinden.blogspot.com/2008/05/yahoo-builds-two-petabyte-postgresql.html ...pretty big. But yahoo threw some programmers at it, I believe. Straight out of the box? Not sure, but I'd expect many on this list have databases larger than enterprise oracle shops. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to analyze load average ?
On Mon, 06 Aug 2012 09:38:33 -0500, Tomas Vondra t...@fuzzy.cz 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=articlesid=20090715034920 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to analyze load average ?
On Mon, 06 Aug 2012 10:27:18 -0500, Tomas Vondra t...@fuzzy.cz 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 activity etc. Ahh, I didn't see the mention of ext4 initially. I tend to just use iostat for getting a better baseline of what's truly happening on the system. At least on FreeBSD (not sure of Linux at the moment) the iostat output also lists CPU usage in the last columns and if id (idle) is not close to zero it's probably OK. :-) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
On Sat, 17 Mar 2012 10:46:00 -0500, dennis jenkins dennis.jenkins...@gmail.com 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 rebuilding a 300GB database (via slony) over a bandwidth-limited (2MB/s) VPN link and it cut the replication resync time down significantly. SSH with the HPN patchset[1] would help as well if it's higher latency or if you're CPU limited as it can use multiple threads then. It works wonderfully for me on a 35mbit link. If you have a lower sized link that wouldn't benefit from the HPN patchset anyway it may be worth forcing Blowfish instead of AES to keep the CPU load lower. Hope that helps! [1] http://www.psc.edu/networking/projects/hpn-ssh/ FYI, the HPN patchset is included the base OpenSSH of FreeBSD 9 now. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] SSDs with Postgresql?
On Thu, 28 Apr 2011 17:27:04 -0500, Basil Bourque basil.l...@me.com 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 and their servers all went down (weren't paying for N+1 power). They had several FusionIO cards in servers running Postgres and experienced zero corruption. YMMV. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Bytea error in PostgreSQL 9.0
On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh hatua...@gmail.com 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_output = escape? Regards, Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Do we want SYNONYMS?
On Mon, 06 Dec 2010 15:09:04 -0600, Tom Lane t...@sss.pgh.pa.us 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 be interconnected. They paid to have access to our data via this VPN and the synonyms. I'm pretty sure I remember things changing a few times and if the synonyms weren't matching on both ends stuff would break. So yeah, I'm 99% this is possible in Oracle and I don't know how anyone would replicate that type of an environment in Postgres. Regards, Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] advise on performance issues please
On Tue, 30 Nov 2010 04:34:32 -0600, Gregory Machin g...@linuxpro.co.za 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 setup where ESX's datastores are on the iSCSI SAN? Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
