pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed8.4/9.0 simple query performance regression
2011-06-06 21:45 UTC Josh Berkus <josh@agliodbs.com>
` Re: 8.4/9.0 simple query performance regression
2011-06-06 23:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.4/9.0 simple query performance regression
2011-06-07 08:19 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
[3+ messages in thread]
not exits slow compared to not in. (nested loops killing me)
2011-06-06 20:38 UTC mark <dvlhntr@gmail.com>
` Re: not exits slow compared to not in. (nested loops killing me)
2011-06-06 23:07 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: not exits slow compared to not in. (nested loops killing me)
2011-06-07 00:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: not exits slow compared to not in. (nested loops killing me)
2011-06-07 00:16 UTC mark <dvlhntr@gmail.com>
[4+ messages in thread]
Re: Different execution time for same plan
2011-06-06 15:48 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
Index use difference betweer LIKE, LIKE ANY?
2011-02-25 13:31 UTC Sam Wong <sam@hellosam.net>
` Re: Index use difference betweer LIKE, LIKE ANY?
2011-02-26 21:13 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index use difference betweer LIKE, LIKE ANY?
2011-03-15 12:30 UTC Chetan Suttraway <chetan.suttraway@enterprisedb.com>
` Re: Index use difference betweer LIKE, LIKE ANY?
2011-04-18 16:14 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Index use difference betweer LIKE, LIKE ANY?
2011-06-06 09:43 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: Index use difference betweer LIKE, LIKE ANY?
2011-06-06 09:47 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
[6+ messages in thread]
Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 15:50 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 16:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:02 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:06 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:09 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:19 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:21 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:27 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:30 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:44 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 17:56 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 18:26 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 18:32 UTC Craig James <craig_james@emolecules.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 20:55 UTC Tobias Brox <tobixen@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-10 21:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 08:19 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 09:29 UTC Tobias Brox <tobixen@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 09:44 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 11:26 UTC Tobias Brox <tobixen@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 11:33 UTC Andrea Suisani <sickpig@opinioni.net>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-11 14:51 UTC Pierre C <lists@peufeu.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-16 21:22 UTC Bruce Momjian <bruce@momjian.us>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-02-23 02:22 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-06-05 15:25 UTC pasman pasmański <pasman.p@gmail.com>
` Re: Why we don't want hints Was: Slow count(*) again...
2011-06-06 08:14 UTC Robert Klemme <shortcutter@googlemail.com>
[26+ messages in thread]
Understanding Hash Join performance
2011-06-02 00:10 UTC Robert James <srobertjames@gmail.com>
` Re: Understanding Hash Join performance
2011-06-02 14:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Understanding Hash Join performance
2011-06-02 18:39 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Understanding Hash Join performance
2011-06-02 18:56 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Understanding Hash Join performance
2011-06-03 03:55 UTC Robert Haas <robertmhaas@gmail.com>
[5+ messages in thread]
Problem query
2011-06-01 20:14 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Problem query
2011-06-01 21:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Problem query
2011-06-01 21:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Problem query
2011-06-01 22:26 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Problem query
2011-06-01 22:28 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Problem query
2011-06-02 01:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Problem query
2011-06-02 13:47 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Problem query
2011-06-02 15:34 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Problem query
2011-06-02 15:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Problem query
2011-06-02 16:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Problem query
2011-06-02 17:31 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Problem query
2011-06-02 19:17 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Problem query
2011-06-02 19:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[13+ messages in thread]
Strange behavior of child table.
2011-05-31 07:20 UTC Jenish <jenishvyas@gmail.com>
` Re: Strange behavior of child table.
2011-06-01 18:53 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Strange behavior of child table.
2011-06-02 13:39 UTC Jenish <jenishvyas@gmail.com>
[3+ messages in thread]
Speeding up loops in pl/pgsql function
2011-05-25 16:59 UTC Reuven M. Lerner <reuven@lerner.co.il>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 18:35 UTC Alex Hunsaker <badalex@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 18:45 UTC Reuven M. Lerner <reuven@lerner.co.il>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 18:48 UTC Alex Hunsaker <badalex@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 19:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 20:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-25 22:26 UTC Reuven M. Lerner <reuven@lerner.co.il>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 00:03 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 01:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 03:55 UTC Santhakumaran <santhkn@yahoo.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 08:46 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 12:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 12:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 12:49 UTC Reuven M. Lerner <reuven@lerner.co.il>
` Re: Speeding up loops in pl/pgsql function
2011-05-26 15:24 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Speeding up loops in pl/pgsql function
2011-06-01 09:19 UTC Reuven M. Lerner <reuven@lerner.co.il>
` Re: Speeding up loops in pl/pgsql function
2011-06-01 13:26 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Speeding up loops in pl/pgsql function
2011-06-02 06:49 UTC Reuven M. Lerner <reuven@lerner.co.il>
[18+ messages in thread]
Delete performance
2011-05-31 00:08 UTC Jarrod Chesney <jarrod.chesney@gmail.com>
` Re: Delete performance
2011-05-31 09:26 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: Delete performance
2011-05-31 23:11 UTC Pierre C <lists@peufeu.com>
` Re: Delete performance
2011-06-01 01:40 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Delete performance
2011-06-01 01:45 UTC Jarrod Chesney <jarrod.chesney@gmail.com>
` Re: Delete performance
2011-06-01 06:14 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Delete performance
2011-06-02 01:46 UTC Jarrod Chesney <jarrod.chesney@gmail.com>
[7+ messages in thread]
CLUSTER versus a dedicated table
2011-06-01 23:54 UTC Robert James <srobertjames@gmail.com>
` Re: CLUSTER versus a dedicated table
2011-06-02 01:18 UTC mark <dvlhntr@gmail.com>
` Re: CLUSTER versus a dedicated table
2011-06-02 01:33 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Hash Anti Join performance degradation
2011-05-24 04:14 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-24 05:53 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Hash Anti Join performance degradation
2011-05-24 11:16 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Hash Anti Join performance degradation
2011-05-24 14:34 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-24 20:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hash Anti Join performance degradation
2011-05-25 01:53 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Hash Anti Join performance degradation
2011-05-25 16:42 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-25 17:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Hash Anti Join performance degradation
2011-05-26 02:40 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Hash Anti Join performance degradation
2011-05-26 12:33 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-26 14:21 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Hash Anti Join performance degradation
2011-05-26 14:48 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Hash Anti Join performance degradation
2011-05-26 16:08 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-26 17:08 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Hash Anti Join performance degradation
2011-05-26 18:04 UTC panam <panam@gmx.net>
` Re: Hash Anti Join performance degradation
2011-05-26 18:13 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Hash Anti Join performance degradation
2011-05-27 00:00 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Hash Anti Join performance degradation
2011-05-31 21:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 00:43 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 00:55 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 01:11 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 02:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 03:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 11:40 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 12:40 UTC panam <panam@gmx.net>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:31 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:34 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:43 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 20:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 21:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 21:53 UTC Ross J. Reedstrom <reedstrm@rice.edu>
` Re: [PERFORM] Hash Anti Join performance degradation
2011-06-01 22:49 UTC panam <panam@gmx.net>
[35+ messages in thread]
picking a filesystem
2011-05-31 15:35 UTC Robert Haas <robertmhaas@gmail.com>
` Re: picking a filesystem
2011-05-31 17:09 UTC Shaun Thomas <sthomas@peak6.com>
` Re: picking a filesystem
2011-05-31 17:58 UTC Samuel Gendler <sgendler@ideasculptor.com>
[3+ messages in thread]
The shared buffers challenge
2011-05-26 14:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-26 15:10 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: The shared buffers challenge
2011-05-26 15:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-26 15:45 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: The shared buffers challenge
2011-05-26 16:02 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-26 16:37 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: The shared buffers challenge
2011-05-26 16:45 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-26 17:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: The shared buffers challenge
2011-05-26 23:10 UTC Greg Smith <greg@2ndquadrant.com>
` Re: The shared buffers challenge
2011-05-26 23:40 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: The shared buffers challenge
2011-05-27 15:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-27 16:44 UTC Scott Carey <scott@richrelevance.com>
` Re: The shared buffers challenge
2011-05-27 17:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: The shared buffers challenge
2011-05-27 18:26 UTC Greg Smith <greg@2ndquadrant.com>
` Re: The shared buffers challenge
2011-05-27 18:47 UTC Greg Smith <greg@2ndquadrant.com>
` Re: The shared buffers challenge
2011-05-27 18:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The shared buffers challenge
2011-05-27 19:04 UTC Robert Haas <robertmhaas@gmail.com>
` Re: The shared buffers challenge
2011-05-27 19:24 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: The shared buffers challenge
2011-05-27 22:12 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: The shared buffers challenge
2011-05-27 23:30 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: The shared buffers challenge
2011-05-28 00:19 UTC Jeff Davis <pgsql@j-davis.com>
` Re: The shared buffers challenge
2011-05-28 21:47 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: The shared buffers challenge
2011-05-31 13:57 UTC Merlin Moncure <mmoncure@gmail.com>
[23+ messages in thread]
serveRAID M5014 SAS
2011-05-25 07:33 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: serveRAID M5014 SAS
2011-05-25 14:00 UTC Greg Smith <greg@2ndquadrant.com>
` Re: serveRAID M5014 SAS
2011-05-25 14:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: serveRAID M5014 SAS
2011-05-25 22:24 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-25 22:42 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-26 08:11 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: serveRAID M5014 SAS
2011-05-26 08:25 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-26 08:31 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: serveRAID M5014 SAS
2011-05-26 22:43 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-26 23:19 UTC Greg Smith <greg@2ndquadrant.com>
` Re: serveRAID M5014 SAS
2011-05-26 23:22 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-26 23:42 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-27 14:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: serveRAID M5014 SAS
2011-05-27 23:24 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: serveRAID M5014 SAS
2011-05-28 09:42 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: serveRAID M5014 SAS
2011-05-28 10:15 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[16+ messages in thread]
Performance block size.
2011-05-26 22:34 UTC Tory M Blue <tmblue@gmail.com>
` Re: Performance block size.
2011-05-27 10:54 UTC Ivan Voras <ivoras@freebsd.org>
[2+ messages in thread]
Is any effect other process performance after vaccumdb finished ?
2011-05-27 01:58 UTC Junghwe Kim <junghwe.kim76@gmail.com>
` Re: Is any effect other process performance after vaccumdb finished ?
2011-05-27 03:31 UTC Craig Ringer <craig@postnewspapers.com.au>
[2+ messages in thread]
LIMIT and UNION ALL
2011-05-18 15:26 UTC Dave Johansen <davejohansen@gmail.com>
` Re: LIMIT and UNION ALL
2011-05-18 15:54 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: LIMIT and UNION ALL
2011-05-18 15:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: LIMIT and UNION ALL
2011-05-26 16:21 UTC Dave Johansen <davejohansen@gmail.com>
` Re: LIMIT and UNION ALL
2011-05-26 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-14 10:10 UTC Stefan Keller <sfkeller@gmail.com>
` Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-16 00:25 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-16 13:47 UTC Merlin Moncure <mmoncure@gmail.com>
` FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-17 15:10 UTC m1ott@hsr.ch
` Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-17 19:30 UTC Jim Nasby <jim@nasby.net>
` Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-17 22:07 UTC Stefan Keller <sfkeller@gmail.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-23 10:53 UTC Pierre C <lists@peufeu.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-23 17:19 UTC Robert Haas <robertmhaas@gmail.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-24 23:45 UTC Stefan Keller <sfkeller@gmail.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-25 16:59 UTC Pierre C <lists@peufeu.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-25 22:08 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-25 22:58 UTC Stefan Keller <sfkeller@gmail.com>
` Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
2011-05-26 09:24 UTC Pierre C <lists@peufeu.com>
[13+ messages in thread]
"error with invalid page header" while vacuuming pgbench data
2011-05-23 22:16 UTC John Rouillard <rouilj@renesys.com>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-23 22:21 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-25 17:12 UTC John Rouillard <rouilj@renesys.com>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-25 20:19 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-25 20:41 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-25 22:07 UTC John Rouillard <rouilj@renesys.com>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-25 22:18 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: "error with invalid page header" while vacuuming pgbench data
2011-05-26 03:17 UTC Craig Ringer <craig@postnewspapers.com.au>
[8+ messages in thread]
Performance degradation of inserts when database size grows
2011-05-17 12:45 UTC Andrey Vorobiev <andrey.o.vorobiev@gmail.com>
` Re: Performance degradation of inserts when database size grows
2011-05-22 06:38 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Performance degradation of inserts when database size grows
2011-05-23 13:30 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Performance degradation of inserts when database size grows
2011-05-23 18:46 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance degradation of inserts when database size grows
2011-05-23 19:05 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance degradation of inserts when database size grows
2011-05-23 19:08 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance degradation of inserts when database size grows
2011-05-23 19:17 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance degradation of inserts when database size grows
2011-05-24 05:24 UTC Terry Schmitt <tschmitt@schmittworks.com>
` Re: Performance degradation of inserts when database size grows
2011-05-24 19:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance degradation of inserts when database size grows
2011-05-24 21:46 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Performance degradation of inserts when database size grows
2011-05-25 02:01 UTC Santhakumaran <santhkn@yahoo.com>
[11+ messages in thread]
reducing random_page_cost from 4 to 2 to force index scan
2011-04-26 09:49 UTC Sok Ann Yap <sokann@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-26 21:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-26 23:23 UTC Sok Ann Yap <sokann@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 01:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 07:22 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 07:23 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 12:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 22:34 UTC Sok Ann Yap <sokann@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-27 23:23 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-28 00:19 UTC Sok Ann Yap <sokann@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-28 11:32 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-04-28 15:56 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 17:44 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 17:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 19:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 20:04 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 20:13 UTC Josh Berkus <josh@agliodbs.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-13 20:51 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-14 02:20 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-15 03:49 UTC Stuart Bishop <stuart@stuartbishop.net>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-15 18:08 UTC Josh Berkus <josh@agliodbs.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-15 18:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-15 20:32 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-15 21:45 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 01:05 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 01:18 UTC Greg Smith <greg@2ndquadrant.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 04:41 UTC Jesper Krogh <jesper@krogh.cc>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 04:49 UTC Jesper Krogh <jesper@krogh.cc>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 14:34 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 15:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 16:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 17:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 19:10 UTC Nathan Boley <npboley@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-16 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-17 19:19 UTC Jim Nasby <jim@nasby.net>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-19 03:00 UTC Greg Smith <greg@2ndquadrant.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-19 14:53 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-19 18:39 UTC Jim Nasby <jim@nasby.net>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-19 20:07 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-19 22:27 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-23 19:08 UTC Josh Berkus <josh@agliodbs.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-24 02:44 UTC Robert Haas <robertmhaas@gmail.com>
` Re: reducing random_page_cost from 4 to 2 to force index scan
2011-05-24 09:12 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
[43+ messages in thread]
postgres not use index, IN statement
2011-05-23 21:30 UTC Anibal David Acosta <aa@devshock.com>
` Re: postgres not use index, IN statement
2011-05-23 23:26 UTC Craig Ringer <craig@postnewspapers.com.au>
[2+ messages in thread]
Pushing LIMIT into sub-queries of a UNION ALL
2011-05-16 19:38 UTC Dave Johansen <davejohansen@gmail.com>
` Pushing LIMIT into sub-queries of a UNION ALL?
2011-05-17 15:31 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing LIMIT into sub-queries of a UNION ALL?
2011-05-22 17:34 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Pushing LIMIT into sub-queries of a UNION ALL?
2011-05-23 15:54 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Pushing LIMIT into sub-queries of a UNION ALL
2011-05-23 17:21 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Pushing LIMIT into sub-queries of a UNION ALL?
2011-05-23 19:47 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Pushing LIMIT into sub-queries of a UNION ALL?
2011-05-23 21:31 UTC Josh Berkus <josh@agliodbs.com>
[7+ messages in thread]
SORT performance - slow?
2011-05-19 21:13 UTC Strange, John W <john.w.strange@jpmchase.com>
` Re: SORT performance - slow?
2011-05-19 21:41 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: SORT performance - slow?
2011-05-20 03:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: SORT performance - slow?
2011-05-22 23:11 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: SORT performance - slow?
2011-05-23 17:01 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: SORT performance - slow?
2011-05-23 17:27 UTC Robert Haas <robertmhaas@gmail.com>
` Re: SORT performance - slow?
2011-05-23 17:56 UTC Tomas Vondra <tv@fuzzy.cz>
[7+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox