[ADMIN] Web Application Engineer - Drupal, PHP, CSS, JavaScript, Postgresql

2008-11-11 Thread NetGraviton
Web Application Engineer - Drupal, PHP, CSS, JavaScript, Postgresql Position Title: Web Application Developer - Drupal, PHP, CSS, JavaScript, Postgresql, Linux, HTML, Apache Location: Boston, MA (Back Bay - Prudential Building - Commuter Rail and T-accessible). Status: Full Time, Regular

Re: [ADMIN] max_files_per_process limit

2008-11-11 Thread Scott Marlowe
On Tue, Nov 11, 2008 at 5:10 AM, Dilek Küçük [EMAIL PROTECTED] wrote: On Mon, Nov 10, 2008 at 4:51 PM, Achilleas Mantzios [EMAIL PROTECTED] wrote: Στις Monday 10 November 2008 16:18:37 ο/η Dilek Küçük έγραψε: Hi, We have a database of about 62000 tables (about 2000 tablespaces) with

Re: [ADMIN] Ideal way to upgrade to postgres 8.3 with less downtime

2008-11-11 Thread Scott Marlowe
On Thu, Nov 6, 2008 at 11:04 PM, Swathi S [EMAIL PROTECTED] wrote: Hi, I have a database of size approx 400G. It's a 24/7 database. Only few tables have regular reads and writes. The other tables just store information. I would like to upgrade to 8.3 and would like to know the best way to

Re: [ADMIN] max_files_per_process limit

2008-11-11 Thread Dilek Küçük
On Mon, Nov 10, 2008 at 4:51 PM, Achilleas Mantzios [EMAIL PROTECTED] wrote: Στις Monday 10 November 2008 16:18:37 ο/η Dilek Küçük έγραψε: Hi, We have a database of about 62000 tables (about 2000 tablespaces) with an index on each table. Postgresql version is 8.1. So you have about

Re: [ADMIN] max_files_per_process limit

2008-11-11 Thread Dilek Küçük
On Mon, Nov 10, 2008 at 5:24 PM, Tom Lane [EMAIL PROTECTED] wrote: =?ISO-8859-1?Q?Dilek_K=FC=E7=FCk?= [EMAIL PROTECTED] writes: We have a database of about 62000 tables (about 2000 tablespaces) with an index on each table. Postgresql version is 8.1. You should probably rethink that schema.