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 rebuilding

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) application

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 diffe

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 use