pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Row level security policy policy versus SQL constraints. Any performance difference?
  2017-10-17 20:44 UTC  Joe Carlson <jwcarlson@lbl.gov>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
  2017-10-17 21:35 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
  2017-10-17 22:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Row level security policy policy versus SQL constraints. Any performance difference?
  2017-10-17 22:18 UTC  Joe Carlson <jwcarlson@lbl.gov>
  [4+ messages in thread]

99% time spent in WAL wait events
  2017-10-16 13:34 UTC  Purav Chovatia <puravc@gmail.com>
` Re: 99% time spent in WAL wait events
  2017-10-16 15:31 UTC  Purav Chovatia <puravc@gmail.com>
  [2+ messages in thread]

Stored Procedure Performance
  2006-04-11 07:19 UTC  Simon Dale <sdale@rm.com>
` Re: Stored Procedure Performance
  2006-04-11 07:58 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: Stored Procedure Performance
  2006-04-11 08:22 UTC  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
` Re: Stored Procedure Performance
  2006-04-11 10:04 UTC  Richard Huxton <dev@archonet.com>
` Re: Stored Procedure Performance
  2006-04-11 13:49 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Stored Procedure Performance
  2006-04-11 13:56 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Stored Procedure Performance
  2006-04-11 14:02 UTC  H.J. Sanders <hjs@rmax.nl>
` Re: Stored Procedure Performance
  2006-04-11 14:08 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Stored Procedure Performance
  2006-04-11 21:02 UTC  Merlin Moncure <mmoncure@gmail.com>
` Stored Procedure Performance
  2017-10-03 14:33 UTC  Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
  2017-10-03 14:54 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Stored Procedure Performance
  2017-10-03 15:17 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
  2017-10-03 15:28 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 13:59 UTC  Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 14:11 UTC  Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 14:20 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 16:05 UTC  Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 16:37 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 16:52 UTC  Purav Chovatia <puravc@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 16:54 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Stored Procedure Performance
  2017-10-11 19:06 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stored Procedure Performance
  2017-10-14 10:21 UTC  phb07 <phb07@apra.asso.fr>
  [22+ messages in thread]

Rowcount estimation changes based on from clause order
  2017-10-11 09:33 UTC  Ants Aasma <ants.aasma@eesti.ee>
` Re: Rowcount estimation changes based on from clause order
  2017-10-12 20:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Rowcount estimation changes based on from clause order
  2017-10-13 02:32 UTC  Ants Aasma <ants.aasma@eesti.ee>
  [3+ messages in thread]

synchronization between PostgreSQL and Oracle
  2017-10-12 09:13 UTC  ROS Didier <didier.ros@edf.fr>
` Re: synchronization between PostgreSQL and Oracle
  2017-10-12 10:01 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: synchronization between PostgreSQL and Oracle
  2017-10-12 10:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [3+ messages in thread]

blocking index creation
  2017-10-11 12:58 UTC  Neto pr <netopr9@gmail.com>
` Re: blocking index creation
  2017-10-11 13:46 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: blocking index creation
  2017-10-11 14:11 UTC  Neto pr <netopr9@gmail.com>
` Re: blocking index creation
  2017-10-11 21:08 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: blocking index creation
  2017-10-11 22:54 UTC  Neto pr <netopr9@gmail.com>
` Re: blocking index creation
  2017-10-12 01:35 UTC  Neto pr <netopr9@gmail.com>
` Re: blocking index creation
  2017-10-12 02:25 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [7+ messages in thread]

Wrong plane for limit after group by
  2017-10-12 00:18 UTC  Денис Смирнов <darthunix@gmail.com>

Cursor With_Hold Performance Workarounds/Optimization
  2017-10-10 12:20 UTC  Leon Winter <winter-pg@bfw-online.de>

Regression from 9.4-9.6
  2017-10-08 19:25 UTC  Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
  2017-10-08 19:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Regression from 9.4-9.6
  2017-10-08 20:02 UTC  Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
  2017-10-08 20:33 UTC  Jim Nasby <jim@nasby.net>
` Re: Regression from 9.4-9.6
  2017-10-08 20:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Regression from 9.4-9.6
  2017-10-08 21:07 UTC  Jim Nasby <jim@nasby.net>
  [6+ messages in thread]

How does max_parallel_workers_per_gather change load averages?
  2017-10-03 19:48 UTC  Ben Nachtrieb <bnachtrieb@crescat.net>
` Re: How does max_parallel_workers_per_gather change load averages?
  2017-10-03 21:44 UTC  David Rowley <david.rowley@2ndquadrant.com>
  [2+ messages in thread]

select with max functions
  2017-10-01 12:41 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
  2017-10-01 13:35 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: select with max functions
  2017-10-01 18:48 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: select with max functions
  2017-10-02 13:25 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
  2017-10-02 13:45 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: select with max functions
  2017-10-02 14:45 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: select with max functions
  2017-10-02 15:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: select with max functions
  2017-10-03 21:16 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [8+ messages in thread]

BDR, wal sender, high system cpu, mutex_lock_common
  2017-09-29 23:07 UTC  milist ujang <ujang.milist@gmail.com>
` Re: BDR, wal sender, high system cpu, mutex_lock_common
  2017-10-01 01:36 UTC  milist ujang <ujang.milist@gmail.com>
  [2+ messages in thread]

Slow query in JDBC
  2017-09-28 08:19 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 08:48 UTC  Julien Rouhaud <rjuju123@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 08:58 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 09:20 UTC  Julien Rouhaud <rjuju123@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 09:26 UTC  Pavy Philippe <Philippe.Pavy@worldline.com>
` Re: Slow query in JDBC
  2017-09-28 09:59 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 13:59 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Slow query in JDBC
  2017-09-28 16:32 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-28 19:04 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Slow query in JDBC
  2017-09-29 05:57 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-29 06:49 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query in JDBC
  2017-09-29 10:44 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
  2017-09-29 13:04 UTC  Dave Cramer <pg@fastcrypt.com>
  [13+ messages in thread]

query of partitioned object doesnt use index in qa
  2017-09-13 20:28 UTC  Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-13 21:57 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-14 13:25 UTC  Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 20:18 UTC  Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 20:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 20:59 UTC  Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 21:03 UTC  Andres Freund <andres@anarazel.de>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 22:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query of partitioned object doesnt use index in qa
  2017-09-15 22:26 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-20 16:15 UTC  Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-20 23:05 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
  2017-09-25 16:21 UTC  Mike Broers <mbroers@gmail.com>
  [12+ messages in thread]

Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ?
  2017-09-25 11:10 UTC  Tobias Gierke <tobias.gierke@code-sourcery.de>

Query regarding EXPLAIN (ANALYZE,BUFFERS)
  2017-09-21 10:52 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Query regarding EXPLAIN (ANALYZE,BUFFERS)
  2017-09-21 18:37 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [2+ messages in thread]

repeated subplan execution
  2017-09-19 23:30 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: repeated subplan execution
  2017-09-20 02:31 UTC  monika yadav <monika.1234yadav@gmail.com>
` Re: repeated subplan execution
  2017-09-20 16:46 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: repeated subplan execution
  2017-09-21 10:35 UTC  monika yadav <monika.1234yadav@gmail.com>
  [4+ messages in thread]

 https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
  2017-09-19 00:49 UTC  園田祥平 <shohei.nkapl@gmail.com>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
  2017-09-19 02:44 UTC  George Neuner <gneuner2@comcast.net>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
  2017-09-19 03:30 UTC  Jonathan Rogers <jrogers@emphasys-software.com>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
  2017-09-19 13:08 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [4+ messages in thread]

Pageinspect bt_metap help
  2017-09-17 21:52 UTC  Neto pr <netopr9@gmail.com>
` Re: Pageinspect bt_metap help
  2017-09-17 21:59 UTC  Peter Geoghegan <pg@bowt.ie>
` Re: Pageinspect bt_metap help
  2017-09-18 14:31 UTC  Neto pr <netopr9@gmail.com>
` Re: Pageinspect bt_metap help
  2017-09-19 01:07 UTC  Peter Geoghegan <pg@bowt.ie>
` Re: Pageinspect bt_metap help
  2017-09-19 03:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

max partitions behind a view?
  2017-09-18 11:25 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: max partitions behind a view?
  2017-09-18 13:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Partitioning perfomance issue
  2017-09-17 08:34 UTC  Konstantin Kivi <konstantin.kivi@gmail.com>

Indexing an array of two separate columns
  2017-09-15 20:51 UTC  Jeremy Finzel <finzelj@gmail.com>

Store/Retrieve time series data from PostgreSQL
  2017-09-14 11:51 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Store/Retrieve time series data from PostgreSQL
  2017-09-14 12:03 UTC  vinny <vinny@xs4all.nl>
` Re: Store/Retrieve time series data from PostgreSQL
  2017-09-14 12:33 UTC  Subramaniam C <subramaniam31784@gmail.com>
` Re: Store/Retrieve time series data from PostgreSQL
  2017-09-14 12:38 UTC  Subramaniam C <subramaniam31784@gmail.com>
  [4+ messages in thread]

postgresql 9.6 data directory fs becomes full
  2017-09-11 09:42 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 9.6 data directory fs becomes full
  2017-09-11 12:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql 9.6 data directory fs becomes full
  2017-09-11 17:07 UTC  Jerry Sievers <gsievers19@comcast.net>
  [3+ messages in thread]

OS cache management
  2017-09-06 08:12 UTC  Soni M <diptatapa@gmail.com>
` Re: OS cache management
  2017-09-06 14:13 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: [SPAM] OS cache management
  2017-09-06 14:45 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: OS cache management
  2017-09-10 05:48 UTC  Soni M <diptatapa@gmail.com>
` Re: [SPAM] OS cache management
  2017-09-10 05:49 UTC  Soni M <diptatapa@gmail.com>
  [5+ 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