[ADMIN] PostgreSQL and ZFS

2008-09-03 Thread Thomas Bräutigam
Hello all, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS?

[ADMIN] PostgreSQL and ZFS

2008-09-03 Thread Thomas Bräutigam
Hello, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS? Like

Re: [ADMIN] Recommended RAID for Postgres

2008-07-01 Thread Thomas Bräutigam
ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote: > Why avoid RAID5? I though that would be good? Can you explain this? RAID5 has a lot of disadvantages, especially in terms of performance. .oO(There was a link posted recently...) > Writing i

Re: [ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Thomas Bräutigam
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tino Schwarze Sent: Montag, 30. Juni 2008 14:53 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 02:30:23PM +0200, Thomas Bräutigam wrote: > I have a pre

[ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Thomas Bräutigam
Hello all, I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. What do you guys recommend on RAID Levels for this Database. Which does Postgres recommend, and with which do Postgres run very good or in the best way? What Backup Strategy do you think would be the best. Dump the DB once a

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-30 Thread Thomas Bräutigam
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 20:25 To: Thomas Bräutigam Cc: [EMAIL PROTECTED]; Joshua D. Drake; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from Solaris 10 Thomas Bräutigam wrote: > Hi Jignesh > > What things do I all need to ta

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-30 Thread Thomas Bräutigam
al Message- From: Igor Polishchuk [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 03:57 To: Joshua D. Drake; Thomas Bräutigam Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from Solaris 10 In our organization, we are running multi

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-30 Thread Thomas Bräutigam
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 05:58 To: Thomas Bräutigam Cc: Joshua D. Drake; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from Solaris 10 Here are my two cents: You dont want to remove

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-29 Thread Thomas Bräutigam
Thomas -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 02:33 To: Thomas Bräutigam Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from Solaris 10 On Wed, 30 Apr 2008 01:59:08

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-29 Thread Thomas Bräutigam
Hi Joshua, Why does it affect shmmax? Cheers Thomas -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 01:52 To: Thomas Bräutigam Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-29 Thread Thomas Bräutigam
not the elegant version of doin it. Cheers Thomas -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. April 2008 01:52 To: Thomas Bräutigam Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-29 Thread Thomas Bräutigam
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 29. April 2008 04:45 To: Thomas Bräutigam Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: Remove Postgres from Solaris 10 I guess what you mean is to remove the "role" postgres so that you ca

[ADMIN] Remove Postgres from Solaris 10

2008-04-28 Thread Thomas Bräutigam
Hello all, I have a software solution with a postgres database. The user postgres is abolutly needed for my software. With Solaris 10, Postgres is automatically installed and uses the user postgres. How can I easily remove the current postgres install from this Solaris 10? Is there a proces

Re: [ADMIN] Postgres and SUN

2008-04-06 Thread Thomas Bräutigam
Hi Jignesh, Thanks for this information. Did SUN make any other tests with SUN Machines and Postgres Databases? Cheers Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jignesh K. Shah Sent: Freitag, 4. April 2008 15:14 To: Thomas Bräutigam Cc

Re: [ADMIN] Postgres and SUN

2008-04-04 Thread Thomas Bräutigam
Hi Robert What do you think about the SUN T5120 or T5220 with a Postgres Database? Cheers Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 3. April 2008 19:28 To: Thomas Bräutigam Cc: pgsql-admin@postgresql.org; Jignesh K. Shah Subject: Re

Re: [ADMIN] Postgres and SUN

2008-04-01 Thread Thomas Bräutigam
in 10-20 Seconds. Price for the Machine doesn’t matter at all. The machine should just fit and can handle this kinda huge database. Cheers Thomas -Original Message- From: Michael Monnerie [mailto:[EMAIL PROTECTED] Sent: Dienstag, 1. April 2008 14:54 To: Thomas Bräutigam Cc: pgsql-admin

[ADMIN] Postgres and SUN

2008-04-01 Thread Thomas Bräutigam
Hey, I am very new in this mailing list and also very new in working with Postgres. My questions is, is there a recommendation from Postgres about which SUN Machine you should choose when you have a huge Postgres Database. Cheers thomas