Re: [PERFORM] select max(column) from parent table very slow
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 8.1 and above it doesn't. However, I am guess that since this is a partitioned table the planner isn't smart enough to just perform the 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 absolutely unexpected, undiscussed, and posted without previous warning, but one that you were actually asked about! And weren't you recently joking about giving Tom nightmares by sending patches to the optimizer? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] select max(column) from parent table very slow
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 absolutely unexpected, undiscussed, and posted without previous warning, but one that you were actually asked about! And weren't you recently joking about giving Tom nightmares by sending patches to the optimizer? Yeah, but Tom is getting up there a bit, and that might mean a heart attack. Then what would we do? ;) Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[PERFORM] Related to Inserting into the database from XML file
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
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 highly recommend upgrading if at all possible. That's quite an old version. Hope this helps, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[PERFORM] Changing max_connections without restart ?
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 ? Thanks -- -- Jean Arnaud -- Projet SARDES -- INRIA Rhône-Alpes / LSR-IMAG -- Tél. : +33 (0)4 76 61 52 80 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PERFORM] Changing max_connections without restart ?
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. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
