Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ACB869FBC92 for ; Fri, 23 Mar 2007 09:48:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 04141-05 for ; Fri, 23 Mar 2007 09:48:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by postgresql.org (Postfix) with ESMTP id E7E1C9FBC93 for ; Fri, 23 Mar 2007 09:48:22 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i28so1242630wxd for ; Fri, 23 Mar 2007 05:48:21 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=oO4oYgZs3eh56zKM9w6RMv11uLFzYpMv0CcsNzqMnm5UJnSCinpILp4qpNguPt9JHKbieAvqR7Lcx7hEf2qHiZZnRbK/OcpNfs0D7R399WB1FDton8NVC3BHn6Msh6yUpsPALgi0zX9lTjYeocuOaW4RvOU2cteH3qaRciO8DeE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=GkI7LBBG3U1rNIw5tHzpFc9p7XSYcRrMd4xuvTSM4ThrOhB6keGNnji7+jQThk0Bv61Efyjio5T2hEBj4DfRvu7bcw2SFlColYNzER2SeYUM7TvOiTiYp/W9pM8z2ffBa9vyVRgXw3mMrhvt0WzWgp2ZN19nKOnobudcGfWh3Jg= Received: by 10.114.152.17 with SMTP id z17mr1177377wad.1174654099774; Fri, 23 Mar 2007 05:48:19 -0700 (PDT) Received: by 10.114.209.4 with HTTP; Fri, 23 Mar 2007 05:48:19 -0700 (PDT) Message-ID: Date: Fri, 23 Mar 2007 12:48:19 +0000 From: "Paolo Negri" To: pgsql-performance@postgresql.org Subject: linux - server configuration for small database MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/363 X-Sequence-Number: 23768 Hi I'm going to install a new server and I'm looking for some advice about how I can help my database performing at its best. I'll be using a redhat ES 4 on a dual core opteron with 2 SCSI 10.000rpm disks in RAID1. The first question I have is, since I'd strongly prefer to use postgresql 8.1 or 8.2 instead of the 7.4 that comes with redhat, if someone else is using with success third party rpms with success in business critical applications. Database size: under 1 G Load: reaches 100 r/w queries per second peak time but the average is lower Filesystem: I'll probably have ext3 because of the redhat support. RAM: I will have enough to let postgresql use a quantity about the size of the db itself. I'll have just one pair of disks so Linux will live on the same disk array of the database, but obviously I can make any choice I like about the partitioning and my idea was to put postgresql data on a dedicated partition. As processes I'll have some other webby things running on the server but the I/O impact at disk level of these should be not that bad. Now aside of the filesystem/partitioning choice, I have experience with LVM, but I've never tried to take snapshots of postgresql databases and I'd be interested in knowing how well this works/perform and if there's any downside. I'd like even to read which procedures are common to restore a db from the LVM snapshot. As an alternative i was thinking about using the wal incremental backup strategy. In any case I'll take a pg_dump daily. I would appreciate even just interesting web links (I've already googled a bit so I'm quite aware of the most common stuff) Thanks Paolo