Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 705572E096D for ; Tue, 13 Nov 2007 06:24:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 22809-09 for ; Tue, 13 Nov 2007 06:24:39 -0400 (AST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 0BA982E08D3 for ; Tue, 13 Nov 2007 06:24:41 -0400 (AST) Received: (qmail invoked by alias); 13 Nov 2007 10:24:39 -0000 Received: from unknown (EHLO [192.168.89.164]) [87.234.85.108] by mail.gmx.net (mp021) with SMTP; 13 Nov 2007 11:24:40 +0100 X-Authenticated: #18841147 X-Provags-ID: V01U2FsdGVkX18Q8zkYZ8gQe/9OOE8uXeTWTTfqjkuZeHCoWDCJST S3jHoq+Cy4If+X Message-ID: <47397B6A.6070008@gmx.de> Date: Tue, 13 Nov 2007 11:24:42 +0100 From: Jens-Wolfhard Schicke User-Agent: Mozilla-Thunderbird 2.0.0.6 (X11/20071008) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: random_page_cost etc. per tablespace? X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/193 X-Sequence-Number: 27608 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, how hard would it be to give users the ability to configure different random_page and seq_page costs per tablespace? Obviously this does not match with random_page_cost being a GUC variable but nonetheless I think it'd make a nice feature. I just came across this problem because I own a solid state disk but not all data is stored there. Regards, Jens-W. Schicke -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHOXtqzhchXT4RR5ARArkkAKCxljEjRF0vXDJyyLBVTVhnxJ/idwCeOYiD ndXrD8ZFvh5XUmzz5nTZbiI= =871T -----END PGP SIGNATURE-----