Re: [PERFORM] best way to run maintenance script

2008-03-15 Thread Gregory Stark
"Vinubalaji Gopal" <[EMAIL PROTECTED]> writes: > On Fri, 2008-03-14 at 18:37 -0700, Tom Lane wrote: >> That's only a little bit better. Read about all the bug fixes you're > > Sure - will eventually upgrade it sometime - but it has to wait for > now :( Waiting for one of those bugs to bite you i

Re: [PERFORM] Benchmark: Dell/Perc 6, 8 disk RAID 10

2008-03-15 Thread Justin
I decided to reformat the raid 10 into ext2 to see if there was any real big difference in performance as some people have noted here is the test results please note the WAL files are still on the raid 0 set which is still in ext3 file system format. these test where run with the fsync as

[PERFORM] What is the best way to storage music files in Postgresql

2008-03-15 Thread Rich
I am going to embarkon building a music library using apache, postgresql and php. What is the best way to store the music files? Which file type should I use? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql

Re: [PERFORM] What is the best way to storage music files in Postgresql

2008-03-15 Thread Craig James
Rich wrote: I am going to embarkon building a music library using apache, postgresql and php. What is the best way to store the music files? Which file type should I use? In Postgres, its all just binary data. It's entirely up to you which particular format you use. mp2, mp3 mp4, wmv, avi, w

Re: [PERFORM] What is the best way to storage music files in Postgresql

2008-03-15 Thread Craig Ringer
Rich wrote: I am going to embarkon building a music library using apache, postgresql and php. What is the best way to store the music files? Your options are either to use a BLOB within the database or to store paths to normal files in the file system in the database. I suspect using normal