Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-22 Thread Holger Hoffstaette
On Tue, 21 May 2013 11:40:55 +1000, Toby Corkindale wrote: While it is important to let the SSD know about space that can be reclaimed, I gather the operation does not perform well. I *think* current advice is to leave 'discard' off the mount options, and instead run a nightly cron job to

Re: [GENERAL] Pet Peeves?

2009-01-31 Thread Holger Hoffstaette
On Sat, 31 Jan 2009 15:28:31 +0100, Martijn van Oosterhout wrote: Nicest would be ofcourse a niceness level, so that VACUUM slows itself down according to the amount of queries going on (to a minimum ofcourse). Linux has IO priority support for this, see ionice. Starting with 2.6.28 the CFQ

Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results

2009-01-27 Thread Holger Hoffstaette
On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: Harald Armin Massa haraldarminma...@gmail.com wrote: 4.) it seems to be no longer cool to have your data below Program Files / Program Files (x86) That was never cool or good practice. I'm not sure which directory should we

Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results

2009-01-27 Thread Holger Hoffstaette
On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote: Holger Hoffstaette wrote: On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote: I'm not sure which directory should we create $PGDATA -- My Documents, Application Data, Local Settings or direct child of %USERPROFILE

Re: [GENERAL] Upgrading side by side in Gentoo

2008-11-13 Thread Holger Hoffstaette
On Wed, 12 Nov 2008 19:47:15 -0500, Guy Rouillier wrote: To answer your question directly, you won't find a prepackaged solution to running simultaneous version of PG (or any other software package) on Gentoo. That's not how Gentoo is designed to be used. Having said that, You are

Re: [GENERAL] Upgrading side by side in Gentoo

2008-11-13 Thread Holger Hoffstaette
On Thu, 13 Nov 2008 11:41:35 +0200, Andrus wrote: Greg, You need to get one of the experimental builds that include slotted support. Take a look at http://overlays.gentoo.org/proj/postgresql/wiki/ExperimentalFAQ and the page linked to by the blog article you mentioned at

Re: [GENERAL] Upgrading side by side in Gentoo

2008-11-13 Thread Holger Hoffstaette
On Wed, 12 Nov 2008 21:33:26 -0500, Greg Smith wrote: You need to get one of the experimental builds that include slotted support. Take a look at http://overlays.gentoo.org/proj/postgresql/wiki/ExperimentalFAQ and the page linked to by the blog article you mentioned at

Re: [GENERAL] PostgreSQL process architecture question.

2008-09-09 Thread Holger Hoffstaette
On Tue, 09 Sep 2008 10:07:32 -0600, Scott Marlowe wrote: On Tue, Sep 9, 2008 at 9:35 AM, Amber [EMAIL PROTECTED] wrote: We know PostgreSQL uses one dedicated server process to serve one client connection, what we want to know is whether PostgreSQL use multiple threads inside agents processes

Re: [GENERAL] Using PostgreSQL to archive personal email

2007-03-21 Thread Holger Hoffstaette
On Tue, 20 Mar 2007 18:48:15 -0700, [EMAIL PROTECTED] wrote: Does anyone know of any apps using PostgreSQL to archive their personal email and make it searchable? And that runs on Mac OS X? http://www.dbmail.org/ ?:) -h ---(end of

Re: [GENERAL] Spam from EnterpriseDB?

2007-01-19 Thread Holger Hoffstaette
On Fri, 19 Jan 2007 13:51:18 -0500, Merlin Moncure wrote: one second it took to move the mail to my spam folder. Yes, we all know how annoying and stupid spam is but there is a human element here that puts things in slightly different light, don't you think? Absolutely! I'd like to know how

Re: [GENERAL] 8.1 on gentoo

2006-05-25 Thread Holger Hoffstaette
On Thu, 25 May 2006 08:55:51 +0200, Sim Zacks wrote: Does anybody know when postgresql 8.1 will be considered stable on gentoo for x86? No, maybe ask in gentoo-users or -dev? Anyway just because it's not marked stable does not mean it isn't. It's very unfortunate that distributions have

Re: [GENERAL] Postgres Library natively available for Mac OSX Intel?

2006-04-10 Thread Holger Hoffstaette
On Sat, 08 Apr 2006 14:04:28 +0200, Philipp Ott wrote: (..snippetysnip..) I just wanted to know - I would like to have universal binaries of libpg and psql to deploy. Currently 8.1.3 compiles and runs just fine on OSX 10.4.6 + XCode 2.2.1, but generates binaries just for the current host

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

2006-03-28 Thread Holger Hoffstaette
On Mon, 27 Mar 2006 07:31:36 -0600, Jim C. Nasby wrote: On Mon, Mar 27, 2006 at 05:22:40PM +0400, Ivan Zolotukhin wrote: Hello, Does anybody know good comparison/review article of XML support in major RDMBSes? I know that PostgreSQL's XML capabilities are quite weak, but how far is it from

Re: [GENERAL] 7.5 Windows version

2004-06-22 Thread Holger Hoffstaette
On Tue, 22 Jun 2004 12:13:01 -0700, Jonathan Barnhart wrote: Is there any chance I can get a pre-release executable of the Windows native Postgresql so I can start doing some application development? I do not intend to deploy a buggy postgres, but even if it goes boom occasionally it will

Re: [GENERAL] Filesystem vs. Postgres for images

2004-04-20 Thread Holger Hoffstaette
On Tue, 13 Apr 2004 12:56:09 +0200, Holger Klawitter wrote: Oh please. Reiser is as unstable as postgres is slow - in other words, both have to suffer prejudice which used to be true lng ago. ;-) True. In cases of large directories ext2/3 perform extremely bad (as in the original post)