Re: [ADMIN] Password Policy

2007-02-10 Thread Ezequias Rodrigues da Rocha
Hi list (my first post), Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autentication (the password changes according the date/month etc of a day

[ADMIN] Priorities for users or queries?

2007-02-10 Thread Benjamin Arai
Hi, Is there a way to give priorities to queries or users? Something similar to NICE in Linux. My goal is to give the updating (backend) application a very low priority and give the web application a high priority to avoid disturbing the user experience. Thanks in advance! Benjamin

[ADMIN] Problem indexing large database with large number of inserts (partial index building?)

2007-02-10 Thread Benjamin Arai
Hi, I have a database (200GB+), I need to upload about 10GB of data each week. There are no deletions. My problem is that inserting takes a very long time due to the indexes. I can speedup inserting the data insertion if I drop the indexes but then I am left with the problem of

Re: [ADMIN] Priorities for users or queries?

2007-02-10 Thread Joshua D. Drake
Benjamin Arai wrote: Hi, Is there a way to give priorities to queries or users? Something similar to NICE in Linux. My goal is to give the updating (backend) application a very low priority and give the web application a high priority to avoid disturbing the user experience.\ Nope :)

Re: [ADMIN] Priorities for users or queries?

2007-02-10 Thread Benjamin Arai
Just to clarify, there is no way to throttle specific queries or users in PostgreSQL? Benjamin Joshua D. Drake wrote: Benjamin Arai wrote: Hi, Is there a way to give priorities to queries or users? Something similar to NICE in Linux. My goal is to give the updating (backend)

Re: [ADMIN] Password Policy

2007-02-10 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Ezequias Rodrigues da Rocha) wrote: Hi list (my first post), Is there any password polity that postgresql implement ? No, that would be a serious mistake, as it would prevent people from having local policies that differed

Re: [ADMIN] Priorities for users or queries?

2007-02-10 Thread Joshua D. Drake
Benjamin Arai wrote: Just to clarify, there is no way to throttle specific queries or users in PostgreSQL? That is correct. Sincerely, Joshua D. Drake Benjamin Joshua D. Drake wrote: Benjamin Arai wrote: Hi, Is there a way to give priorities to queries or users? Something