Postgresql Performance

Date Index

[Prev Page][Next Page]

query on parent partition table has bad performance, Huang, Suya
- Re: query on parent partition table has bad performance, David G Johnston
- Re: query on parent partition table has bad performance, Tom Lane
  - Re: query on parent partition table has bad performance, Huang, Suya
    - Re: query on parent partition table has bad performance, Tom Lane
query against pg_locks leads to large memory alloc, Dave Owens
- Re: query against pg_locks leads to large memory alloc, Matheus de Oliveira
  - Re: query against pg_locks leads to large memory alloc, Merlin Moncure
    - Re: query against pg_locks leads to large memory alloc, Dave Owens
      - Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Tom Lane
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
      - Re: query against pg_locks leads to large memory alloc, Andres Freund
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Dave Owens
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
        
        Re: query against pg_locks leads to large memory alloc, Kevin Grittner
select on index column,why PG still use seq scan?, Xiaoyulei
- Re: select on index column,why PG still use seq scan?, Tom Lane
how does the planer to estimate row when i use order by and group by, 楊新波
- Re: how does the planer to estimate row when i use order by and group by, Marti Raudsepp
Optimization idea for long IN() lists, Josh Berkus
- Re: Optimization idea for long IN() lists, Maxim Boguk
Re: two table join with order by on both tables attributes, Evgeniy Shishkin
- Re: two table join with order by on both tables attributes, Tom Lane
  - Re: two table join with order by on both tables attributes, Evgeniy Shishkin
    - Re: two table join with order by on both tables attributes, Evgeniy Shishkin
      - Re: two table join with order by on both tables attributes, Marti Raudsepp
        
        Re: two table join with order by on both tables attributes, Evgeniy Shishkin
Very slow planning performance on partition table, Rural Hunter
- Re: Very slow planning performance on partition table, Douglas J Hunley
estimate btree index size without creating, Евгений Селявка
Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
- Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, David G Johnston
  - Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
    - Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, David G Johnston
      - Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
        
        Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, David G Johnston
        
        Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
- Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, Tom Lane
  - Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
    - Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, Tom Lane
      - Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions, johno
Blocking every 20 sec while mass copying., Benjamin Dugast
- Re: Blocking every 20 sec while mass copying., Albe Laurenz
  - Message not available
    - Re: Blocking every 20 sec while mass copying., Albe Laurenz
      - Re: Blocking every 20 sec while mass copying., Benjamin Dugast
- Re: Blocking every 20 sec while mass copying., Guillaume Cottenceau
- Re: Blocking every 20 sec while mass copying., Jeff Janes
Building multiple indexes on one table., Chris Ruprecht
- Re: Building multiple indexes on one table., Claudio Freire
  - Re: Building multiple indexes on one table., Marc Mamin
    - Re: Building multiple indexes on one table., Claudio Freire
      - Re: Building multiple indexes on one table., Felipe Santos
GIN index not used, Huang, Suya
- Re: GIN index not used, Andreas Kretschmer
  - Re: GIN index not used, Tom Lane
    - Re: GIN index not used, Andreas Kretschmer
    - Re: GIN index not used, Huang, Suya
      - Re: GIN index not used, Tom Lane
        
        Re: GIN index not used, Huang, Suya
        
        Re: GIN index not used, Emre Hasegeli
PGSQL 9.3 - billion rows, Nicolas Paris
- Re: PGSQL 9.3 - billion rows, Felipe Santos
- Re: PGSQL 9.3 - billion rows, Sékine Coulibaly
- Message not available
  - Re: PGSQL 9.3 - billion rows, Josh Berkus
stored procedure suddenly runs slowly in HOT STANDBY but fast in primary, piuschan
- Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary, Tom Lane
  - Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary, piuschan
DB sessions 100 times of DB connections, Huang, Suya
- Re: DB sessions 100 times of DB connections, Huang, Suya
  - Re: DB sessions 100 times of DB connections, Steve Crawford
Hash Join node sometimes slow, Dave Roberge
- Re: Hash Join node sometimes slow, Tom Lane
  - Re: Hash Join node sometimes slow, Dave Roberge
fragmention issue with ext4: e4defrag?, Marc Mamin
- Re: fragmention issue with ext4: e4defrag?, Kevin Grittner
Volatility - docs vs behaviour?, Craig Ringer
- Re: Volatility - docs vs behaviour?, Tom Lane
  - Re: Volatility - docs vs behaviour?, Craig Ringer
    - Re: Volatility - docs vs behaviour?, Tom Lane
      - Re: Volatility - docs vs behaviour?, Merlin Moncure
Postgres Replaying WAL slowly, Soni M
- Re: Postgres Replaying WAL slowly, Heikki Linnakangas
  - Re: Postgres Replaying WAL slowly, Soni M
    - Re: Postgres Replaying WAL slowly, Soni M
    - Re: Postgres Replaying WAL slowly, Heikki Linnakangas
      - Re: Postgres Replaying WAL slowly, Soni M
        
        Re: Postgres Replaying WAL slowly, Heikki Linnakangas
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Andres Freund
        
        Re: Postgres Replaying WAL slowly, Soni M
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Andres Freund
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Tom Lane
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Matheus de Oliveira
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Andres Freund
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Tom Lane
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Tom Lane
        
        Re: Postgres Replaying WAL slowly, Andres Freund
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Jeff Frost
        
        Re: Postgres Replaying WAL slowly, Tom Lane
        
        Re: Postgres Replaying WAL slowly, Andres Freund
        
        Re: Postgres Replaying WAL slowly, Tom Lane
        
        Re: Postgres Replaying WAL slowly, Simon Riggs
        
        Re: Postgres Replaying WAL slowly, Simon Riggs
        
        Re: Postgres Replaying WAL slowly, Pavel Stehule
Can improve 'limit 1' ? with slow function, songtebo
60 core performance with 9.3, Mark Kirkwood
- Re: 60 core performance with 9.3, Scott Marlowe
  - Re: 60 core performance with 9.3, Mark Kirkwood
    - Re: 60 core performance with 9.3, Andres Freund
      - Re: 60 core performance with 9.3, Mark Kirkwood
      - Re: 60 core performance with 9.3, Mark Kirkwood
        
        Re: 60 core performance with 9.3, Mark Kirkwood
        
        Re: 60 core performance with 9.3, Andres Freund
        
        Re: 60 core performance with 9.3, Mark Kirkwood
        
        Re: 60 core performance with 9.3, Andres Freund
        
        Re: 60 core performance with 9.3, Mark Kirkwood
        
        Re: 60 core performance with 9.3, Kevin Grittner
        
        Re: 60 core performance with 9.3, Mark Kirkwood
        
        Re: 60 core performance with 9.3, Kevin Grittner
        
        Re: 60 core performance with 9.3, Mark Kirkwood
        
        Message not available
        
        Message not available
        
        Message not available
        
        Re: 60 core performance with 9.3, Mark Kirkwood
- Message not available
  - Re: 60 core performance with 9.3, Josh Berkus
    - Re: 60 core performance with 9.3, Mark Kirkwood
      - Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Shaun Thomas
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Peter Geoghegan
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Mark Kirkwood
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Mark Kirkwood
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Shaun Thomas
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Bruce Momjian
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Tatsuo Ishii
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Graeme B. Bell
        
        Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Bruce Momjian
        
        Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Bruce Momjian
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Scott Marlowe
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Scott Marlowe
        
        Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Steve Crawford
        
        Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Mark Kirkwood
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Joshua D. Drake
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Scott Marlowe
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Shaun Thomas
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Andres Freund
        
        Message not available
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Josh Berkus
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Mark Kirkwood
        
        Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3, Mark Kirkwood
how to improve perf of 131MM row table?, AJ Weber
- Re: how to improve perf of 131MM row table?, Shaun Thomas
  - Re: how to improve perf of 131MM row table?, Aaron Weber
    - Re: how to improve perf of 131MM row table?, Shaun Thomas
      - Re: how to improve perf of 131MM row table?, Aaron Weber
      - Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Matheus de Oliveira
        
        Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Matheus de Oliveira
        
        Re: how to improve perf of 131MM row table?, Shaun Thomas
        
        Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Shaun Thomas
        
        Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Sébastien Lorion
        
        Re: how to improve perf of 131MM row table?, Claudio Freire
        
        Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Claudio Freire
        
        Re: how to improve perf of 131MM row table?, AJ Weber
        
        Re: how to improve perf of 131MM row table?, Claudio Freire
        
        Re: how to improve perf of 131MM row table?, Shaun Thomas
        
        Re: how to improve perf of 131MM row table?, AJ Weber
    - Re: how to improve perf of 131MM row table?, Jeff Janes
      - Re: how to improve perf of 131MM row table?, Shaun Thomas
        
        Re: how to improve perf of 131MM row table?, Aaron Weber
      - Re: how to improve perf of 131MM row table?, Aaron Weber
Guidelines on best indexing strategy for varying searches on 20+ columns, Niels Kristian Schjødt
- Re: Guidelines on best indexing strategy for varying searches on 20+ columns, Merlin Moncure
  - Re: Guidelines on best indexing strategy for varying searches on 20+ columns, Niels Kristian Schjødt
- Re: Guidelines on best indexing strategy for varying searches on 20+ columns, Jeff Janes
  - Re: Guidelines on best indexing strategy for varying searches on 20+ columns, Niels Kristian Schjødt
GIST optimization to limit calls to operator on sub nodes, Pujol Mathieu
- Re: GIST optimization to limit calls to operator on sub nodes, Emre Hasegeli
  - Re: GIST optimization to limit calls to operator on sub nodes, Tom Lane
    - Re: GIST optimization to limit calls to operator on sub nodes, Pujol Mathieu
      - Re: GIST optimization to limit calls to operator on sub nodes, Tom Lane
        
        Re: GIST optimization to limit calls to operator on sub nodes, Pujol Mathieu
  - Re: GIST optimization to limit calls to operator on sub nodes, Pujol Mathieu
huge pgstat.stat file on PostgreSQL 8.3.24, Huang, Suya
- Re: huge pgstat.stat file on PostgreSQL 8.3.24, Pavel Stehule
  - Re: huge pgstat.stat file on PostgreSQL 8.3.24, Huang, Suya
    - Re: huge pgstat.stat file on PostgreSQL 8.3.24, Pavel Stehule
      - Re: huge pgstat.stat file on PostgreSQL 8.3.24, Huang, Suya
        
        Re: huge pgstat.stat file on PostgreSQL 8.3.24, Pavel Stehule
        
        Re: huge pgstat.stat file on PostgreSQL 8.3.24, Tomas Vondra
        
        Re: huge pgstat.stat file on PostgreSQL 8.3.24, Huang, Suya
    - Re: huge pgstat.stat file on PostgreSQL 8.3.24, Tomas Vondra
Unable to allocate 2G of shared memory on wheezy, Dave Cramer
- Re: Unable to allocate 2G of shared memory on wheezy, Tom Lane
  - Re: Unable to allocate 2G of shared memory on wheezy, Dave Cramer
    - Re: Unable to allocate 2G of shared memory on wheezy, Dave Cramer
    - Re: Unable to allocate 2G of shared memory on wheezy, Tom Lane
1 machine + master DB with postgres_fdw + multiple DB instances on different ports, Gezeala M. Bacuño II
- Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports, Albe Laurenz
  - Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports, Gezeala M. Bacuño II
OFFSET/LIMIT - Disparate Performance w/ Go application, Matt Silverlock
- Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Tom Lane
  - Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Merlin Moncure
  - Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Andreas Joseph Krogh
    - Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Merlin Moncure
- Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Jeff Janes
  - Re: OFFSET/LIMIT - Disparate Performance w/ Go application, Matt Silverlock
Query memory usage greatly in excess of work_mem * query plan steps, Timothy Garnett
- Re: Query memory usage greatly in excess of work_mem * query plan steps, Franklin, Dan
- Re: Query memory usage greatly in excess of work_mem * query plan steps, Tom Lane
[no subject], Scott Marlowe
- Re:, Tom Lane
  - Re:, Scott Marlowe
postgres files in use not staying in linux file cache, Brio
- Re: postgres files in use not staying in linux file cache, Shaun Thomas
  - Re: postgres files in use not staying in linux file cache, Tim Kane
    - Re: postgres files in use not staying in linux file cache, Shaun Thomas
- Re: postgres files in use not staying in linux file cache, Jeff Janes
  - Message not available
    - Message not available
      - Re: postgres files in use not staying in linux file cache, Brio
Seqscan on big table, when an Index-Usage should be possible, Weinzierl Stefan
- Re: Seqscan on big table, when an Index-Usage should be possible, Igor Neyman
parse/bind/execute, Huang, Suya
- Re: parse/bind/execute, David G Johnston
  - Re: parse/bind/execute, Huang, Suya
    - Re: parse/bind/execute, David Johnston
CPU load spikes when CentOS tries to reclaim 'cached' memory, vlasmarias
- Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Jeff Janes
  - Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Merlin Moncure
    - Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Deron
      - Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Merlin Moncure
        
        Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Vincent Lasmarias
        
        Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Steven Crandell
        
        Re: CPU load spikes when CentOS tries to reclaim 'cached' memory, Merlin Moncure
group commit, Evgeny Shishkin
- Re: group commit, David G Johnston
Possible performance regression in PostgreSQL 9.2/9.3?, Linos
- Re: Possible performance regression in PostgreSQL 9.2/9.3?, Merlin Moncure
  - Re: Possible performance regression in PostgreSQL 9.2/9.3?, Linos
    - Re: Possible performance regression in PostgreSQL 9.2/9.3?, Merlin Moncure
      - Re: Possible performance regression in PostgreSQL 9.2/9.3?, Linos
        
        Re: Possible performance regression in PostgreSQL 9.2/9.3?, Igor Neyman
        
        Re: Possible performance regression in PostgreSQL 9.2/9.3?, Linos
High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available, Vince Lasmarias
- Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available, Tom Lane
  - Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available, Merlin Moncure
SELECT outage in semop, Сурен Арустамян
- Re: SELECT outage in semop, Сурен Арустамян
- Re: SELECT outage in semop, Albe Laurenz
  - Re[2]: [PERFORM] SELECT outage in semop, Suren Arustamyan
Planner doesn't take indexes into account, Grzegorz Olszewski
- Re: Planner doesn't take indexes into account, AI Rumman
  - Re: Planner doesn't take indexes into account, Grzegorz Olszewski
    - Re: Planner doesn't take indexes into account, Heikki Linnakangas
    - Re: Planner doesn't take indexes into account, Shaun Thomas
      - Re: Planner doesn't take indexes into account, Grzegorz Olszewski
NFS, file system cache and shared_buffers, Albe Laurenz
- Re: NFS, file system cache and shared_buffers, Heikki Linnakangas
  - Re: NFS, file system cache and shared_buffers, Stephen Frost
    - Re: NFS, file system cache and shared_buffers, Albe Laurenz
      - Re: NFS, file system cache and shared_buffers, Shaun Thomas
        
        Re: NFS, file system cache and shared_buffers, David Boreham
      - Re: NFS, file system cache and shared_buffers, Jeff Janes
        
        Re: NFS, file system cache and shared_buffers, Albe Laurenz
        
        Message not available
        
        Re: NFS, file system cache and shared_buffers, Josh Berkus
        
        Re: NFS, file system cache and shared_buffers, Albe Laurenz
- Re: NFS, file system cache and shared_buffers, Jeff Janes
- Re: NFS, file system cache and shared_buffers, John Melesky
  - Re: NFS, file system cache and shared_buffers, Albe Laurenz
Profiling PostgreSQL, Dimitris Karampinas
- Re: Profiling PostgreSQL, David Boreham
- Re: Profiling PostgreSQL, Tom Lane
  - Re: Profiling PostgreSQL, Michael Paquier
    - Re: Profiling PostgreSQL, Dimitris Karampinas
      - Re: Profiling PostgreSQL, Pavel Stehule
      - Re: Profiling PostgreSQL, Jeff Janes
        
        Re: Profiling PostgreSQL, Dimitris Karampinas
        
        Re: Profiling PostgreSQL, Jeff Janes
        
        Re: Profiling PostgreSQL, Dimitris Karampinas
        
        Re: Profiling PostgreSQL, Matheus de Oliveira
View has different query plan than select statement, Geoff Hull
- Re: View has different query plan than select statement, David Rowley
  - Re: View has different query plan than select statement, Geoff Hull
autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
- Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
- Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, Tom Lane
  - Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
    - Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, Tom Lane
    - Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
      - Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
        
        Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
        
        Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, Tom Lane
        
        Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
        
        Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0, tim_wilson
same query different execution plan (hash join vs. semi-hash join), Huang, Suya
- Re: same query different execution plan (hash join vs. semi-hash join), Tom Lane
  - Re: same query different execution plan (hash join vs. semi-hash join), Huang, Suya
    - Re: same query different execution plan (hash join vs. semi-hash join), Tom Lane
      - Re: same query different execution plan (hash join vs. semi-hash join), Huang, Suya
Query plan good in 8.4, bad in 9.2 and better in 9.3, Scott Marlowe
- Re: Query plan good in 8.4, bad in 9.2 and better in 9.3, Tom Lane
  - Re: Query plan good in 8.4, bad in 9.2 and better in 9.3, Scott Marlowe
- Re: Query plan good in 8.4, bad in 9.2 and better in 9.3, Jeff Janes
how do functions affect query plan?, 常超
- Re: how do functions affect query plan?, David G Johnston
  - Re: how do functions affect query plan?, changchao
    - Re: how do functions affect query plan?, changchao
      - Message not available
        
        Re: FW: how do functions affect query plan?, 楊新波
        
        Re: how do functions affect query plan?, changchao
Stats collector constant I/O, Craig James
- Re: Stats collector constant I/O, Jeff Janes
- Re: Stats collector constant I/O, Pavel Stehule
- Re: Stats collector constant I/O, Tomas Vondra
Adaptive query execution, Tim Kane
- Re: Adaptive query execution, Claudio Freire
  - Re: Adaptive query execution, Tim Kane
Constraint exclusion won't exclude parent table, Tim Kane
- Re: Constraint exclusion won't exclude parent table, Tom Lane
  - Re: Constraint exclusion won't exclude parent table, Tim Kane
9.2.4 vs 9.3.0 query planning (sort merge join vs hash join), Tim Kane
- Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join), Tom Lane
  - Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join), Tim Kane
- Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join), Jeff Janes
Postgresql 9.3 for a Mobile Backend, Rajiv Kasera
- Re: Postgresql 9.3 for a Mobile Backend, desmodemone
- Re: Postgresql 9.3 for a Mobile Backend, Tomas Vondra
Check memory consumption of postgresql query, Phan Công Minh
- Re: Check memory consumption of postgresql query, Clinton Adams
  - Re: Check memory consumption of postgresql query, Phan Công Minh
    - Re: Check memory consumption of postgresql query, Matheus de Oliveira
Specifications for a new server, Johann Spies
- Re: Specifications for a new server, DFE
- Re: Specifications for a new server, Michael Stone
  - Re: Specifications for a new server, Dorian Hoxha
    - Re: Specifications for a new server, Michael Stone
      - Re: Specifications for a new server, Dorian Hoxha
        
        Re: Specifications for a new server, Tomas Vondra
        
        Re: [PERFORM] Specifications for a new server, r.etzenhammer@xxxxxxxxxxx
  - Re: Specifications for a new server, Johann Spies
    - Re: Specifications for a new server, Johann Spies
      - Re: Specifications for a new server, Dorian Hoxha
    - Re: Specifications for a new server, Michael Stone
    - Re: Specifications for a new server, Jeff Janes
Re: recently and selectively slow, but very simple, update query...., Stelios Mavromichalis
- Re: recently and selectively slow, but very simple, update query...., David G Johnston
  - Re: Re: recently and selectively slow, but very simple, update query...., Stelios Mavromichalis
    - Re: recently and selectively slow, but very simple, update query...., David G Johnston
      - Re: Re: recently and selectively slow, but very simple, update query...., Stelios Mavromichalis
        
        Re: Re: recently and selectively slow, but very simple, update query...., Stelios Mavromichalis
Re: PostgreSQL's query planner is using the wrong index, what can I do to improve this situation?, David G Johnston
Optimize query for listing un-read messages, Andreas Joseph Krogh
- Re: Optimize query for listing un-read messages, Jochem Berndsen
  - Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
    - Re: Optimize query for listing un-read messages, Pavel Stehule
      - Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, Pavel Stehule
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, Pavel Stehule
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, Tomas Vondra
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, Tomas Vondra
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, David G Johnston
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
        
        Re: Optimize query for listing un-read messages, David G Johnston
        
        Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
- Re: Optimize query for listing un-read messages, David G Johnston
  - Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
- Re: Optimize query for listing un-read messages, Craig James
  - Re: Optimize query for listing un-read messages, Andreas Joseph Krogh
    - Re: Optimize query for listing un-read messages, Vitalii Tymchyshyn
Slow queries on 9.3.1 despite use of index, Michael van Rooyen
- Re: Slow queries on 9.3.1 despite use of index, Tom Lane
  - Re: Slow queries on 9.3.1 despite use of index, Michael van Rooyen
    - Re: Slow queries on 9.3.1 despite use of index, Tom Lane
- Re: Slow queries on 9.3.1 despite use of index, Jeff Janes
  - Re: Slow queries on 9.3.1 despite use of index, Michael van Rooyen
Revisiting disk layout on ZFS systems, Karl Denninger
- Re: Revisiting disk layout on ZFS systems, Heikki Linnakangas
  - Re: Revisiting disk layout on ZFS systems, Karl Denninger
    - Re: Revisiting disk layout on ZFS systems, Heikki Linnakangas
      - Re: Revisiting disk layout on ZFS systems, Karl Denninger
    - Re: Revisiting disk layout on ZFS systems, Jeff Janes
      - Re: Revisiting disk layout on ZFS systems, Karl Denninger
- Re: Revisiting disk layout on ZFS systems, Albe Laurenz
  - Re: Revisiting disk layout on ZFS systems, Karl Denninger
- Message not available
  - Re: Revisiting disk layout on ZFS systems, Josh Berkus
Varying performacne results after instance restart, MadDamon
Checkpoints and slow queries, Elanchezhiyan Elango
- Re: Checkpoints and slow queries, Tomas Vondra
  - Re: Checkpoints and slow queries, Elanchezhiyan Elango
    - Re: Checkpoints and slow queries, Tom Lane
      - Re: Checkpoints and slow queries, Tomas Vondra
        
        Re: Checkpoints and slow queries, Jeff Janes
        
        Re: Checkpoints and slow queries, Tomas Vondra
      - Re: Checkpoints and slow queries, Tomas Vondra
    - Re: Checkpoints and slow queries, Tomas Vondra
- <Possible follow-ups>
- Checkpoints and slow queries, Elanchezhiyan Elango
pl/pgsql performance, Mehdi Ravanbakhsh
- Re: pl/pgsql performance, Pavel Stehule
  - Re: pl/pgsql performance, Michael Paquier
Server vacuuming the same table again and again, Дмитрий Шалашов
- Re: Server vacuuming the same table again and again, Ilya Kosmodemiansky
  - Re: Server vacuuming the same table again and again, Дмитрий Шалашов
    - Re: Server vacuuming the same table again and again, Дмитрий Шалашов
      - Re: Server vacuuming the same table again and again, Ilya Kosmodemiansky
        
        Re: Server vacuuming the same table again and again, Дмитрий Шалашов
        
        Re: Server vacuuming the same table again and again, Ilya Kosmodemiansky
    - Re: Server vacuuming the same table again and again, Ilya Kosmodemiansky
- Re: Server vacuuming the same table again and again, Torsten Förtsch
  - Re: Server vacuuming the same table again and again, Дмитрий Шалашов
Poor performance for delete query, Jonatan Evald Buus
- Re: Poor performance for delete query, Tom Lane
  - Re: Poor performance for delete query, Jonatan Evald Buus
    - Re: Poor performance for delete query, Tom Lane
      - Re: Poor performance for delete query, Jonatan Evald Buus
        
        Re: Poor performance for delete query, Tom Lane
Best practices for update timestamp with/without triggers, Verghese, Riya
- Re: Best practices for update timestamp with/without triggers, hubert depesz lubaczewski
Help on migrating data from MSSQL2008R2 to PostgreSQL 9.3, Wureka JI
Query on partitioned table not using index, Souquieres Adam
Best practice question, Tory M Blue
- Re: Best practice question, David G Johnston
- Re: Best practice question, Sergey Konoplev
Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Laurence Parry
- Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Oleg Bartunov
  - Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Laurence Parry
  - Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Heikki Linnakangas
    - Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Oleg Bartunov
    - Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search, Tom Lane
IP addresses, NetBlocks, and ASNs, Gary Warner
- Re: IP addresses, NetBlocks, and ASNs, Steve Atkins
  - Re: IP addresses, NetBlocks, and ASNs, Gary Warner
tsearch2, large data and indexes, Ivan Voras
- Re: tsearch2, large data and indexes, Heikki Linnakangas
  - Re: tsearch2, large data and indexes, Ivan Voras
    - Re: tsearch2, large data and indexes, Jeff Janes
      - Re: tsearch2, large data and indexes, Ivan Voras
        
        Re: tsearch2, large data and indexes, Matheus de Oliveira
        
        Re: tsearch2, large data and indexes, Sergey Konoplev
        
        Re: tsearch2, large data and indexes, Heikki Linnakangas
        
        Re: tsearch2, large data and indexes, Ivan Voras
        
        Re: tsearch2, large data and indexes, Sergey Konoplev
        
        Re: tsearch2, large data and indexes, Heikki Linnakangas
        
        Re: tsearch2, large data and indexes, Sergey Konoplev
    - Re: tsearch2, large data and indexes, Heikki Linnakangas
Hot standby 9.2.1 PANIC: WAL contains references to invalid pages, Vishalakshi Navaneethakrishnan
- Re: Hot standby 9.2.1 PANIC: WAL contains references to invalid pages, Sergey Konoplev
Fast distinct not working as expected, Franck Routier
- Re: Fast distinct not working as expected, Jeff Janes
  - Re: Fast distinct not working as expected, Franck Routier
    - Re: Fast distinct not working as expected, Jeff Janes
      - Re: Fast distinct not working as expected, Franck Routier
        
        Re: Fast distinct not working as expected, Franck Routier
        
        Re: Fast distinct not working as expected, Merlin Moncure
unneeded joins on view, Linos
- Re: unneeded joins on view, Heikki Linnakangas
  - Re: unneeded joins on view, Linos
Queries very slow after data size increases, sheishere b
Workaround for working_mem max value in windows?, Nick Eubank
- Re: Workaround for working_mem max value in windows?, Martin French
- Re: Workaround for working_mem max value in windows?, amulsul
  - Re: Workaround for working_mem max value in windows?, Nick Eubank
    - Re: Workaround for working_mem max value in windows?, Martin French
    - Re: Workaround for working_mem max value in windows?, amul sul
- Re: Workaround for working_mem max value in windows?, Jeff Janes
  - Re: Workaround for working_mem max value in windows?, Nick Eubank
Testing strategies, Dave Cramer
- Re: Testing strategies, Matheus de Oliveira
HFS+ pg_test_fsync performance, Mel Llaguno
- Re: HFS+ pg_test_fsync performance, desmodemone
  - Re: HFS+ pg_test_fsync performance, Mel Llaguno
- Message not available
  - Re: HFS+ pg_test_fsync performance, Josh Berkus
    - Re: HFS+ pg_test_fsync performance, Mel Llaguno
      - Message not available
        
        Re: HFS+ pg_test_fsync performance, Josh Berkus
Tuning Postgres for Single connection use, Nick Eubank
- Re: Tuning Postgres for Single connection use, Gavin Flower
  - Re: Tuning Postgres for Single connection use, Nick Eubank
    - Re: Tuning Postgres for Single connection use, Gavin Flower
      - Re: Tuning Postgres for Single connection use, Nick Eubank
- Re: Tuning Postgres for Single connection use, Andrew Dunstan
- Re: Tuning Postgres for Single connection use, Jeff Janes
  - Re: Tuning Postgres for Single connection use, Nick Eubank
    - Re: Tuning Postgres for Single connection use, Jeff Janes
      - Re: Tuning Postgres for Single connection use, Tom Lane
        
        Tuning Postgres for Single connection use, Nick Eubank
    - Re: Tuning Postgres for Single connection use, Schnabel, Robert D.
Approach to Data Summary and Analysis, Robert DiFalco
- Re: [GENERAL] Approach to Data Summary and Analysis, Chris Curvey
  - Re: [GENERAL] Approach to Data Summary and Analysis, Chris Curvey
    - Re: [GENERAL] Approach to Data Summary and Analysis, Robert DiFalco
Checkpoint distribution, Borodin Vladimir
- Re: Checkpoint distribution, Jeff Janes
  - Re: Checkpoint distribution, Borodin Vladimir
    - Re: Checkpoint distribution, Jeff Janes
      - Re: Checkpoint distribution, Borodin Vladimir
Interesting case of index un-usage, Claudio Freire
Optimizing Time Series Access, Robert Burgholzer
- Message not available
  - Re: Optimizing Time Series Access, Robert Burgholzer
query against large table not using sensible index to find very small amount of data, Andrew W. Gibbs
- Re: query against large table not using sensible index to find very small amount of data, Shaun Thomas
  - Re: query against large table not using sensible index to find very small amount of data, Jeff Janes
  - Re: query against large table not using sensible index to find very small amount of data, 'Andrew W. Gibbs'
- Re: query against large table not using sensible index to find very small amount of data, Tom Lane
  - Re: query against large table not using sensible index to find very small amount of data, Andrew W. Gibbs
performance drop when function argument is evaluated in WHERE clause, Gerardo Herzig
- Re: performance drop when function argument is evaluated in WHERE clause, Tom Lane
  - Re: performance drop when function argument is evaluated in WHERE clause, Gerardo Herzig
    - Re: [SQL] Re: performance drop when function argument is evaluated in WHERE clause, Tom Lane
Nested loop issue, Manoj Gadi
- Re: Nested loop issue, Dhananjay Singh
Performance regressions in PG 9.3 vs PG 9.0, uher dslij
- Re: Performance regressions in PG 9.3 vs PG 9.0, uher dslij
  - Re: Performance regressions in PG 9.3 vs PG 9.0, Tom Lane
    - Re: Performance regressions in PG 9.3 vs PG 9.0, uher dslij
    - Re: Performance regressions in PG 9.3 vs PG 9.0, uher dslij
      - Re: Performance regressions in PG 9.3 vs PG 9.0, Tom Lane
Batch update query performance, Hans Drexler
- Re: Batch update query performance, Albe Laurenz
  - Re: Batch update query performance, Heikki Linnakangas
- Re: Batch update query performance, Jeff Janes
- <Possible follow-ups>
- Re: batch update query performance, Hans Drexler
  - Re: batch update query performance, Jeff Janes
performance degradation after launching postgres cluster using pgpool-II, Cora Ma
- Re: performance degradation after launching postgres cluster using pgpool-II, Tatsuo Ishii
  - Re: performance degradation after launching postgres cluster using pgpool-II, Cora Ma
The same query - much different runtimes, Johann Spies
- Re: The same query - much different runtimes, Pavan Deolasee
SSI slows down over time, Ryan Johnson
- Re: SSI slows down over time, Heikki Linnakangas
  - Re: SSI slows down over time, Ryan Johnson
- Re: SSI slows down over time, Tom Lane
  - Re: SSI slows down over time, Ryan Johnson
  - Re: SSI slows down over time, Ryan Johnson
- Re: SSI slows down over time, Ryan Johnson
  - Re: SSI slows down over time, Bruce Momjian
    - Re: SSI slows down over time, Ryan Johnson
- <Possible follow-ups>
- SSI slows down over time, Ryan Johnson
  - Re: SSI slows down over time, Kevin Grittner
    - Re: SSI slows down over time, Ryan Johnson
      - Re: SSI slows down over time, Kevin Grittner
    - Re: SSI slows down over time, Ryan Johnson
      - Re: SSI slows down over time, Ryan Johnson
PGSQL 9.3 - Materialized View - multithreading, Nicolas Paris
- Re: PGSQL 9.3 - Materialized View - multithreading, Thom Brown
  - Re: PGSQL 9.3 - Materialized View - multithreading, PARIS Nicolas
    - Re: PGSQL 9.3 - Materialized View - multithreading, Thom Brown
      - Re: PGSQL 9.3 - Materialized View - multithreading, PARIS Nicolas
        
        Re: PGSQL 9.3 - Materialized View - multithreading, Thom Brown
        
        Re: PGSQL 9.3 - Materialized View - multithreading, PARIS Nicolas
        
        Re: PGSQL 9.3 - Materialized View - multithreading, ktm@xxxxxxxx
        
        Re: PGSQL 9.3 - Materialized View - multithreading, Thom Brown
        
        Re: PGSQL 9.3 - Materialized View - multithreading, PARIS Nicolas
- Re: PGSQL 9.3 - Materialized View - multithreading, Graeme B. Bell
  - Re: PGSQL 9.3 - Materialized View - multithreading, Nicolas Paris
    - Re: PGSQL 9.3 - Materialized View - multithreading, Graeme B. Bell
      - Re: PGSQL 9.3 - Materialized View - multithreading, Nicolas Paris
        
        Re: PGSQL 9.3 - Materialized View - multithreading, Graeme B. Bell
PGSQL, checkpoints, and file system syncs, Reza Taheri
- Re: PGSQL, checkpoints, and file system syncs, Heikki Linnakangas
  - Re: PGSQL, checkpoints, and file system syncs, Reza Taheri
    - Re: PGSQL, checkpoints, and file system syncs, Ilya Kosmodemiansky
      - Re: PGSQL, checkpoints, and file system syncs, Reza Taheri
  - Re: PGSQL, checkpoints, and file system syncs, Bruce Momjian
- <Possible follow-ups>
- PGSQL, checkpoints, and file system syncs, Reza Taheri
  - Re: PGSQL, checkpoints, and file system syncs, Shaun Thomas
    - Re: PGSQL, checkpoints, and file system syncs, Bruce Momjian
Sudden crazy high CPU usage, Niels Kristian Schjødt
- Re: Sudden crazy high CPU usage, Merlin Moncure
  - Re: Sudden crazy high CPU usage, Niels Kristian Schjødt
    - Re: Sudden crazy high CPU usage, Merlin Moncure
      - Re: Sudden crazy high CPU usage, Niels Kristian Schjødt
        
        Re: Sudden crazy high CPU usage, Andres Freund
        
        Re: Sudden crazy high CPU usage, Michael Paquier
    - Re: Sudden crazy high CPU usage, Scott Marlowe
      - Re: Sudden crazy high CPU usage, Niels Kristian Schjødt
- Re: Sudden crazy high CPU usage, Sergey Konoplev
  - Re: Sudden crazy high CPU usage, Will Platnick
    - Re: Sudden crazy high CPU usage, Niels Kristian Schjødt
Slow Count-Distinct Query, Christopher Jackson
- Re: Slow Count-Distinct Query, Shaun Thomas
- Re: Slow Count-Distinct Query, Tom Lane
  - Re: Slow Count-Distinct Query, Christopher Jackson
- Re: Slow Count-Distinct Query, bricklen
  - Re: Slow Count-Distinct Query, Christopher Jackson
    - Re: Slow Count-Distinct Query, Michael Paquier
      - Re: Slow Count-Distinct Query, Christopher Jackson
- <Possible follow-ups>
- Fwd: Slow Count-Distinct Query, Varadharajan Mukundan
  - Re: Fwd: Slow Count-Distinct Query, Jeff Janes
    - Re: Fwd: Slow Count-Distinct Query, Varadharajan Mukundan
      - Slow Count-Distinct Query, Jeff Janes
        
        Re: Slow Count-Distinct Query, Varadharajan Mukundan
Partitions and prepared statements?, Dave Johansen
semaphore waits and performance stall, Matthew Spilich
Why shared_buffers max is 8GB?, Alexey Vasiliev
- Re: Why shared_buffers max is 8GB?, Ilya Kosmodemiansky
  - Re: Why shared_buffers max is 8GB?, desmodemone
    - Re: Why shared_buffers max is 8GB?, Albe Laurenz
      - Re: Why shared_buffers max is 8GB?, desmodemone
    - Re: Why shared_buffers max is 8GB?, Markella Skempri
      - Re: Why shared_buffers max is 8GB?, Martin French
        
        Re: Why shared_buffers max is 8GB?, Markella Skempri
        
        Re: Why shared_buffers max is 8GB?, Martin French
      - Re: Why shared_buffers max is 8GB?, Scott Marlowe
        
        Re: Why shared_buffers max is 8GB?, Shaun Thomas
        
        Re: Why shared_buffers max is 8GB?, Ilya Kosmodemiansky
    - Re: Why shared_buffers max is 8GB?, Martin French
- Re: Why shared_buffers max is 8GB?, Alexey Klyukin
  - Re: Why shared_buffers max is 8GB?, Bruce Momjian
Stalls on PGSemaphoreLock, Matthew Spilich
- Re: Stalls on PGSemaphoreLock, Ray Stell
  - RE : Stalls on PGSemaphoreLock, Pavy Philippe
    - Re: Stalls on PGSemaphoreLock, Matthew Spilich
      - Re: Stalls on PGSemaphoreLock, Pavy Philippe
        
        Re: Stalls on PGSemaphoreLock, Gudmundsson Martin (mg)
        
        Re: Stalls on PGSemaphoreLock, Matthew Spilich
        
        Re: Stalls on PGSemaphoreLock, Matheus de Oliveira
- Re: Stalls on PGSemaphoreLock, Emre Hasegeli
- Re: Stalls on PGSemaphoreLock, Takashi Horikawa
pg_dump vs pg_basebackup, gianfranco caca
- Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
  - Re: pg_dump vs pg_basebackup, gianfranco caca
    - Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
- Re: pg_dump vs pg_basebackup, David Johnston
  - Re: pg_dump vs pg_basebackup, Claudio Freire
    - Re: pg_dump vs pg_basebackup, Joshua D. Drake
      - Re: pg_dump vs pg_basebackup, desmodemone
      - Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
        
        Re: pg_dump vs pg_basebackup, Magnus Hagander
        
        Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
        
        Re: pg_dump vs pg_basebackup, Magnus Hagander
        
        Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
        
        Re: pg_dump vs pg_basebackup, Joshua D. Drake
        
        Re: pg_dump vs pg_basebackup, Joshua D. Drake
        
        Re: pg_dump vs pg_basebackup, Ilya Kosmodemiansky
        
        Re: pg_dump vs pg_basebackup, Graeme B. Bell
        
        Re: pg_dump vs pg_basebackup, Alan Hodgson
        
        Re: pg_dump vs pg_basebackup, Claudio Freire
Suboptimal query plan when using expensive BCRYPT functions, Erik van Zijst
- Re: Suboptimal query plan when using expensive BCRYPT functions, bricklen
  - Re: Suboptimal query plan when using expensive BCRYPT functions, Erik van Zijst
    - Re: Suboptimal query plan when using expensive BCRYPT functions, bricklen
      - Re: Suboptimal query plan when using expensive BCRYPT functions, Erik van Zijst
        
        Re: Suboptimal query plan when using expensive BCRYPT functions, bricklen

[Index of Archives] [Postgresql Home] [Postgresql General] [PHP on Windows] [Yosemite News]