Re: [pgadmin-support] [SQL] Statistics

2007-03-09 Thread Hiltibidal, Robert
Joe is quite right about comparing stats. Unless things are equal across the board (database, tables, data, hardware, software) results will always differ. Another consideration and this may be painful, is consider what Oracle support may be able to offer. Executives do not want to hear the core

Re: [pgadmin-support] [SQL] Statistics

2007-03-09 Thread Joe
On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote: > Does someone have statistcs from PostgreSQL ? Numbers from the list, > performance statistics. I must argue with another person the idea of > do not put Oracle in our organization. > > We are quite well with postgresql and I h

Re: Re : [pgadmin-support] Request for better visual feedback in the event of errors

2007-03-09 Thread Ezequias Rodrigues da Rocha
Perfect. Great and simple request. 2007/3/9, Laurent ROCHE <[EMAIL PROTECTED]>: I second that ! Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : jws <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 8 Mars 2007, 23h32mn 18s Objet : [pg

[pgadmin-support] Statistics

2007-03-09 Thread Ezequias Rodrigues da Rocha
Hi list, Does someone have statistcs from PostgreSQL ? Numbers from the list, performance statistics. I must argue with another person the idea of do not put Oracle in our organization. We are quite well with postgresql and I have no plans to change my plataform. Regards -- Ezequias Rodrigues

[pgadmin-support] Bitmap AND multicolumn index used !

2007-03-09 Thread Arnaud Lesauvage
Hi list ! I have a quite large table with a PostGIS-geometry field (~25M rows) representing road segments. The segments are classified in 9 classes (from 0 to 8), based on their importance. I am trying some different methods for optimizing queries on this table. I decided to try with a multicol

Re : [pgadmin-support] Changing owner objects

2007-03-09 Thread Laurent ROCHE
>>If you use PostgreSQL 8.2, you can >> REASSIGN OWNED BY A TO B; Good but I am using 8.1 >>We aren't sure that all objects in this schema are owned by the same >>user. But perhaps we can add some code to "emulate" REASSIGN OWNED for >>older PostgreSQL releases. That will be great ! Hav

Re: [pgadmin-support] Changing owner objects

2007-03-09 Thread Guillaume Lelarge
Laurent ROCHE a ecrit le 09/03/2007 12:58: Is there an easy way (in one go) to change the owner of all database objects with PG Admin ? I am creating a schema with a script that assign the objects owner to login (I mean conection role) A . Then I switch the schema owner to login (/conection r

[pgadmin-support] Changing owner objects

2007-03-09 Thread Laurent ROCHE
Hi, Is there an easy way (in one go) to change the owner of all database objects with PG Admin ? I am creating a schema with a script that assign the objects owner to login (I mean conection role) A . Then I switch the schema owner to login (/conection role) B. But the objects are still owned

Re : [pgadmin-support] Request for better visual feedback in the event of errors

2007-03-09 Thread Laurent ROCHE
I second that ! Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : jws <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 8 Mars 2007, 23h32mn 18s Objet : [pgadmin-support] Request for better visual feedback in the event of errors It would