pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedindex fragmentation on insert-only table with non-unique column
2016-05-24 17:39 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 04:16 UTC Peter Geoghegan <pg@bowt.ie>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 04:26 UTC Stephen Frost <sfrost@snowman.net>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 04:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 05:18 UTC Peter Geoghegan <pg@bowt.ie>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 06:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 13:45 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-05-25 14:00 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-03 21:26 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-03 23:54 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-04 02:05 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-04 13:39 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-05 16:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index fragmentation on insert-only table with non-unique column
2016-06-05 19:28 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-08-13 18:54 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: index fragmentation on insert-only table with non-unique column
2016-08-15 17:42 UTC Claudio Freire <klaussfreire@gmail.com>
[16+ messages in thread]
Planner do seq scan on empty master partitioned table
2016-08-11 10:46 UTC Andrey Zhidenkov <andrey.zhidenkov@gmail.com>
` Re: Planner do seq scan on empty master partitioned table
2016-08-11 13:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner do seq scan on empty master partitioned table
2016-08-11 13:55 UTC Vladimir Borodin <root@simply.name>
[3+ messages in thread]
Logging queries using sequential scans
2016-08-10 11:13 UTC Ivan Voras <ivoras@gmail.com>
` Re: Logging queries using sequential scans
2016-08-10 11:39 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Create language plperlu Error
2016-08-02 05:47 UTC Om Prakash Jaiswal <op12om@yahoo.co.in>
` Re: Create language plperlu Error
2016-08-02 06:05 UTC John R Pierce <pierce@hogranch.com>
` Re: Create language plperlu Error
2016-08-02 06:45 UTC Ranjeet Dhumal <jeetu.dhumal@gmail.com>
` Re: Create language plperlu Error
2016-08-02 07:21 UTC John R Pierce <pierce@hogranch.com>
` Re: Create language plperlu Error
2016-08-02 12:00 UTC Luca Ferrari <fluca1978@infinito.it>
` Re: [PERFORM] Create language plperlu Error
2016-08-08 07:26 UTC Johan Fredriksson <eskil@kth.se>
` Re: Create language plperlu Error
2016-08-08 10:30 UTC Om Prakash Jaiswal <op12om@yahoo.co.in>
` Re: [PERFORM] Create language plperlu Error
2016-08-08 11:21 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
[8+ messages in thread]
Need Beta Users for New Database Monitoring Solution!
2016-08-03 16:27 UTC jonescam <cameron.jones@bluemedora.com>
Very poor performance with Nested Loop Anti Join
2016-08-01 13:33 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Very poor performance with Nested Loop Anti Join
2016-08-01 13:40 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Very poor performance with Nested Loop Anti Join
2016-08-01 23:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very poor performance with Nested Loop Anti Join
2016-08-02 11:30 UTC Andreas Joseph Krogh <andreas@visena.com>
[4+ messages in thread]
Very slow query (3-4mn) on a table with 25millions rows
2016-07-25 15:26 UTC Abadie Lana <Lana.Abadie@iter.org>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-25 18:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-26 09:01 UTC Abadie Lana <Lana.Abadie@iter.org>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-26 10:34 UTC Martín Marqués <martin@2ndquadrant.com>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-27 06:03 UTC Abadie Lana <Lana.Abadie@iter.org>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-27 09:15 UTC Félix GERZAGUET <felix.gerzaguet@gmail.com>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-27 09:36 UTC Félix GERZAGUET <felix.gerzaguet@gmail.com>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-27 14:55 UTC Abadie Lana <Lana.Abadie@iter.org>
` Re: Very slow query (3-4mn) on a table with 25millions rows
2016-07-28 09:55 UTC Abadie Lana <Lana.Abadie@iter.org>
[9+ messages in thread]
Seeing execution plan of foreign key constraint check?
2016-07-05 12:14 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-19 14:47 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-19 20:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-21 21:42 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-21 21:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-21 22:14 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-22 08:37 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Seeing execution plan of foreign key constraint check?
2016-07-23 01:57 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[8+ messages in thread]
[PERFORMANCE] Performance index and table
2016-07-22 13:34 UTC Oscar Camuendo <oscar.dny86@hotmail.com>
` Re: [PERFORMANCE] Performance index and table
2016-07-22 14:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Performance problems with 9.2.15
2016-05-27 12:10 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-05-27 13:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems with 9.2.15
2016-05-27 14:13 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-05-27 14:45 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Performance problems with 9.2.15
2016-05-30 07:35 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-05-30 13:56 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-07-21 14:48 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-07-21 18:24 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Performance problems with 9.2.15
2016-07-21 18:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Performance problems with 9.2.15
2016-07-21 21:12 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Performance problems with 9.2.15
2016-07-22 00:59 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-07-22 01:07 UTC Johan Fredriksson <eskil@kth.se>
` Re: Performance problems with 9.2.15
2016-07-22 07:08 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Performance problems with 9.2.15
2016-07-22 07:20 UTC Johan Fredriksson <eskil@kth.se>
[14+ messages in thread]
less than 2 sec for response - possible?
2016-07-02 00:54 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-02 01:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: less than 2 sec for response - possible?
2016-07-02 02:48 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-05 10:10 UTC Pujol Mathieu <mathieu.pujol@realfusio.com>
` Re: less than 2 sec for response - possible?
2016-07-05 11:39 UTC Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: less than 2 sec for response - possible?
2016-07-05 15:35 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-06 08:35 UTC Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: less than 2 sec for response - possible?
2016-07-06 15:06 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-06 15:27 UTC Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: less than 2 sec for response - possible?
2016-07-06 16:46 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-09 17:26 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-19 14:10 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: less than 2 sec for response - possible?
2016-07-19 14:28 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-19 14:41 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: less than 2 sec for response - possible?
2016-07-19 14:56 UTC trafdev <trafdev@mail.ru>
` Re: less than 2 sec for response - possible?
2016-07-21 22:20 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[16+ messages in thread]
Poor choice of backward scan
2016-07-20 20:56 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
Random slow queries
2016-06-29 01:24 UTC devel.brain99@xoxy.net
` Re: Random slow queries
2016-06-29 12:45 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: Random slow queries
2016-06-29 14:32 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Random slow queries
2016-06-29 18:01 UTC devel.brain99@xoxy.net
` Re: Random slow queries
2016-06-29 18:04 UTC devel.brain99@xoxy.net
` Re: Random slow queries
2016-06-29 20:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Random slow queries
2016-06-29 21:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Random slow queries
2016-06-29 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Random slow queries
2016-07-04 12:19 UTC devel.brain99@xoxy.net
` Re: Random slow queries
2016-07-19 14:51 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[10+ messages in thread]
DELETE takes too much memory
2016-07-04 16:35 UTC Kouber Saparev <kouber@gmail.com>
` Re: DELETE takes too much memory
2016-07-04 17:04 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: DELETE takes too much memory
2016-07-04 17:10 UTC Kouber Saparev <kouber@gmail.com>
` Re: DELETE takes too much memory
2016-07-05 18:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: DELETE takes too much memory
2016-07-05 21:03 UTC Kouber Saparev <kouber@gmail.com>
` Re: DELETE takes too much memory
2016-07-06 16:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: DELETE takes too much memory
2016-07-07 07:39 UTC Kouber Saparev <kouber@gmail.com>
` Re: DELETE takes too much memory
2016-07-19 14:28 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[8+ messages in thread]
slony rpm help slony1-95-2.2.2-1.rhel6.x86_64
2016-06-03 23:03 UTC avi Singh <avisingh19811981@gmail.com>
` Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64
2016-06-09 15:32 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64
2016-07-17 01:14 UTC Jan Wieck <jan@wi3ck.info>
[3+ messages in thread]
9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-25 14:33 UTC Vladimir Borodin <root@simply.name>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-27 16:57 UTC Vladimir Borodin <root@simply.name>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-27 21:56 UTC Andres Freund <andres@anarazel.de>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-30 14:53 UTC Vladimir Borodin <root@simply.name>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-30 17:03 UTC Vladimir Borodin <root@simply.name>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-05-31 09:06 UTC Vladimir Borodin <root@simply.name>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-06-02 11:18 UTC Антон Бушмелев <bushmelev.aa@gmail.com>
` Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-06-09 22:28 UTC Andres Freund <andres@anarazel.de>
` Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-06-12 21:42 UTC Vladimir Borodin <root@simply.name>
` Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-06-12 21:51 UTC Andres Freund <andres@anarazel.de>
` Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-06-13 18:58 UTC Vladimir Borodin <root@simply.name>
` Re: [HACKERS] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-07-04 13:30 UTC Vladimir Borodin <root@simply.name>
` Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-07-14 18:48 UTC Andres Freund <andres@anarazel.de>
` Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-07-14 18:53 UTC Andres Freund <andres@anarazel.de>
` Re: [HACKERS] [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
2016-07-15 09:24 UTC Dmitriy Sarafannikov <d.sarafannikov@bk.ru>
[15+ messages in thread]
pgtune or similar to assist in initial settings
2016-07-12 00:34 UTC Tory M Blue <tmblue@gmail.com>
` Re: pgtune or similar to assist in initial settings
2016-07-12 20:03 UTC Imre Samu <pella.samu@gmail.com>
[2+ messages in thread]
Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 10:23 UTC Jean-David Beyer <jeandavid8@verizon.net>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 10:36 UTC Levente Birta <blevi.linux@gmail.com>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 10:45 UTC Thomas Samson <koollman@gmail.com>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 11:44 UTC vincent <vinny@xs4all.nl>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 13:27 UTC Karl Denninger <karl@denninger.net>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 14:50 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Capacitors, etc., in hard drives and SSD for DBMS machines...
2016-07-08 14:56 UTC Jean-David Beyer <jeandavid8@verizon.net>
[7+ messages in thread]
Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-05 14:50 UTC Kaixi Luo <kaixiluo@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-05 19:17 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-06 18:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-06 21:48 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-06 22:34 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 04:59 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 07:49 UTC Kaixi Luo <kaixiluo@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 14:09 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 16:27 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 17:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-07 21:06 UTC Kaixi Luo <kaixiluo@gmail.com>
` Re: Tuning guidelines for server with 256GB of RAM and SSDs?
2016-07-08 03:13 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[12+ messages in thread]
pg_xlog dir not getting swept
2016-06-29 10:00 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: pg_xlog dir not getting swept
2016-06-29 19:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_xlog dir not getting swept
2016-06-30 09:36 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
[3+ messages in thread]
testing - ignore
2016-06-28 14:10 UTC George Neuner <gneuner2@comcast.net>
[PERFORM] Cache performance decreases
2016-06-27 11:43 UTC Suren Arustamyan <suren-a@inbox.ru>
can't explain commit performance win7 vs linux : 8000/s vs 419/s
2016-06-25 16:19 UTC t.dalpozzo@gmail.com <t.dalpozzo@gmail.com>
` Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s
2016-06-25 18:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s
2016-06-25 19:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s
2016-06-25 22:27 UTC Imre Samu <pella.samu@gmail.com>
[4+ messages in thread]
Can't get two index scans
2016-06-22 16:03 UTC Craig James <cjames@emolecules.com>
` Re: Can't get two index scans
2016-06-22 18:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Can't get two index scans
2016-06-23 04:36 UTC Craig James <cjames@emolecules.com>
` Re: Can't get two index scans
2016-06-23 15:47 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Can't get two index scans
2016-06-23 19:52 UTC Craig James <cjames@emolecules.com>
[5+ messages in thread]
Looking for more Beta Users!
2016-06-20 14:00 UTC jonescam <cameron.jones@bluemedora.com>
[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