Re: [PERFORM] pg_dump and thousands of schemas

2012-07-31 Thread Hugo
Hi guys, I just want to let you know that we have created our own solution to dump and restore our databases. The tool was written in java and the source is now on Github (MIT license): https://github.com/tig100/JdbcPgBackup The main approach was to cache all database objects - schemas, tables, i

Re: [PERFORM] ZFS vs. UFS

2012-07-31 Thread Craig James
On Tue, Jul 31, 2012 at 1:50 AM, Laszlo Nagy wrote: > > When Intel RAID controller is that? All of the ones on the motherboard >> are pretty much useless if that's what you have. Those are slower than >> software RAID and it's going to add driver issues you could otherwise >> avoid. Better to

Re: [PERFORM] ZFS vs. UFS

2012-07-31 Thread Laszlo Nagy
When Intel RAID controller is that? All of the ones on the motherboard are pretty much useless if that's what you have. Those are slower than software RAID and it's going to add driver issues you could otherwise avoid. Better to connect the drives to the non-RAID ports or configure the cont