Re: [PERFORM] select max(column) from parent table very slow

2006-08-25 Thread Alvaro Herrera
Joshua D. Drake wrote: Tom Lane wrote: Joshua D. Drake [EMAIL PROTECTED] writes: Sriram Dandapani wrote: Parent table has a column say column1 which is indexed (parent table and all child tables are indexed on that column) In older versions of postgresql that would scan the whole table. In

Re: [PERFORM] select max(column) from parent table very slow

2006-08-25 Thread Joshua D. Drake
query on each child and a max on the set that is returned. It is not. Feel free to submit a patch for planagg.c ... I think my patch to pgbench may have set your expectations of me a bit high ;)... Actually I think this is the perfect opportunity for you -- a patch that not only was

[PERFORM] Related to Inserting into the database from XML file

2006-08-25 Thread soni de
Hello, I want to ask, Is there any way to insert records from XML file to the postgres database? Please provide me some help regarding above query. Postgres version which we are using is 7.2.4 Thanks, Sonal

Re: [PERFORM] Related to Inserting into the database from XML file

2006-08-25 Thread Jeff Davis
On Fri, 2006-08-25 at 21:23 +0530, soni de wrote: Hello, I want to ask, Is there any way to insert records from XML file to the postgres database? Try the contrib/xml2 module. Please provide me some help regarding above query. Postgres version which we are using is 7.2.4 I

[PERFORM] Changing max_connections without restart ?

2006-08-25 Thread Jean Arnaud
Hi ! I'm looking for a way to change the max_connections parameter without restarting the PostGreSQL database. All the docs i found online are saying that this option can only be set on startup (-N option to comand-line) or by changing it in postgresql.conf. Does anyone know how to do it ?

Re: [PERFORM] Changing max_connections without restart ?

2006-08-25 Thread Tom Lane
Jean Arnaud [EMAIL PROTECTED] writes: I'm looking for a way to change the max_connections parameter without restarting the PostGreSQL database. There is none. That's one of the parameters that determines shared memory array sizes, and we can't change those on-the-fly.