Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-08 Thread Enrico Weigelt
* Tena Sakai wrote: Hi, > I have been reading this thread and I got the idea that > SANs to avoid, but would somebody please give a bit of > Comparison/perspective on NAS? same as for SAN: measure it on your real workload and compare different products w/ similar stability and accessibility pro

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-08 Thread Enrico Weigelt
* Scott Marlowe wrote: > What really matters here is if the 8gb SAN is as fast as or faster > than the DAS setup. For most people measuring the speed of the > interface is a lot like the famous Tom Lane quote about benchmarking > jet fighters versus airliners by measuring the amount of runway th

Re: [ADMIN] vacuumdb for schema only

2010-09-08 Thread Bèrto ëd Sèra
Nice to know that, which means we can only send out scripts by cron... On 8 September 2010 16:06, Fabrízio de Royes Mello wrote: > > > 2010/9/8 Bèrto ëd Sèra > > Hi! >> >> I would also expect you to be able to make a Stored Procedure executing >> the same command, although I never tried it mysel

Re: [ADMIN] vacuumdb for schema only

2010-09-08 Thread Fabrízio de Royes Mello
2010/9/8 Bèrto ëd Sèra > Hi! > > I would also expect you to be able to make a Stored Procedure executing the > same command, although I never tried it myself. > > It is not possible... vacuum cannot be executed inside a function or transaction. See de sample: -- Using function CREATE OR REPLACE

[ADMIN] PostgreSQL article online - PDF

2010-09-08 Thread Thomas Uzunoff
Hello, Pavel Stehule wrote an article for Linux Technical Review which is published now. The language is German. It's regarding PostgreSQL and its possibilities with e.g. Stored Procedures. The first 100 downloads are sponsored by Linux Technical Review. Feel free to download the PDF and to rea