Mailing lists [pgsql-performance]

1 May 2014

• 01:32   Re: Adding new field to big table RichmondDyes@monroehosp.org
• 01:32   Checkpoints and slow queries Elanchezhiyan Elango
• 14:28   Optimize query for listing un-read messages Andreas Joseph Krogh
• 21:35   Re: Optimize query for listing un-read messages Jochem Berndsen
• 22:19   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 22:31   Re: Optimize query for listing un-read messages Pavel Stehule
• 22:39   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 22:54   Re: Optimize query for listing un-read messages Pavel Stehule
• 23:32   Re: Optimize query for listing un-read messages Andreas Joseph Krogh

2 May 2014

• 00:03   Re: Optimize query for listing un-read messages Pavel Stehule
• 00:19   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 00:20   Re: Optimize query for listing un-read messages David G Johnston
• 00:31   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 00:34   Re: Revisiting disk layout on ZFS systems Josh Berkus
• 00:46   Re: Optimize query for listing un-read messages Tomas Vondra
• 00:58   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 01:34   Re: Optimize query for listing un-read messages Tomas Vondra
• 01:41   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 01:55   Re: Optimize query for listing un-read messages David G Johnston
• 02:51   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 02:58   Re: Optimize query for listing un-read messages David G Johnston
• 03:10   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 03:18   Re: Optimize query for listing un-read messages Craig James
• 10:22   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 20:28   Re: Optimize query for listing un-read messages Vitalii Tymchyshyn

4 May 2014

• 23:51   Re: PostgreSQL's query planner is using the wrong index, what can I do to improve this situation? David G Johnston

6 May 2014

• 00:21   Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 00:51   Re: recently and selectively slow, but very simple, update query.... David G Johnston
• 01:06   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 02:54   Re: recently and selectively slow, but very simple, update query.... David G Johnston
• 12:13   Specifications for a new server Johann Spies
• 12:26   Re: Specifications for a new server DFE
• 14:07   Re: Specifications for a new server Michael Stone
• 14:15   Re: Specifications for a new server Dorian Hoxha
• 14:24   Re: Specifications for a new server Michael Stone
• 16:31   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 17:44   Re: Specifications for a new server Dorian Hoxha

7 May 2014

• 18:57   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis

8 May 2014

• 00:35   Re: Specifications for a new server Tomas Vondra
• 08:20   Re: [PERFORM] Specifications for a new server r.etzenhammer@t-online.de
• 10:05   Check memory consumption of postgresql query Phan Công Minh
• 10:10   Postgresql 9.3 for a Mobile Backend Rajiv Kasera
• 10:31   Re: Postgresql 9.3 for a Mobile Backend desmodemone
• 11:11   Re: Specifications for a new server Johann Spies
• 11:28   Re: Specifications for a new server Johann Spies
• 14:44   Re: Specifications for a new server Dorian Hoxha
• 17:04   Re: Check memory consumption of postgresql query Clinton Adams

9 May 2014

• 01:59   Re: Postgresql 9.3 for a Mobile Backend Tomas Vondra

12 May 2014

• 10:03   Re: Check memory consumption of postgresql query Phan Công Minh
• 13:45   9.2.4 vs 9.3.0 query planning (sort merge join vs hash join) Tim Kane
• 14:23   Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join) Tom Lane
• 15:23   Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join) Tim Kane
• 19:02   Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join) Jeff Janes
• 19:38   Re: Check memory consumption of postgresql query Matheus de Oliveira

13 May 2014

• 17:19   Re: Specifications for a new server Michael Stone
• 20:12   Re: Specifications for a new server Jeff Janes
• 23:02   Constraint exclusion won't exclude parent table Tim Kane
• 23:08   Adaptive query execution Tim Kane
• 23:13   Re: Adaptive query execution Claudio Freire
• 23:24   Re: Constraint exclusion won't exclude parent table Tom Lane
• 23:34   Re: Adaptive query execution Tim Kane
• 23:57   Re: Constraint exclusion won't exclude parent table Tim Kane

14 May 2014

• 02:05   Re: CPU spikes and transactions Dave Owens
• 16:48   Re: CPU spikes and transactions Merlin Moncure
• 19:28   Re: CPU spikes and transactions Jeff Janes

15 May 2014

• 07:18   Stats collector constant I/O Craig James
• 08:16   how do functions affect query plan? 常超
• 08:43   Re: how do functions affect query plan? David G Johnston
• 09:19   Re: how do functions affect query plan? changchao
• 10:59   Re: how do functions affect query plan? changchao
• 11:18   Re: Stats collector constant I/O Jeff Janes
• 11:26   Re: Stats collector constant I/O Pavel Stehule
• 11:31   Re: FW: how do functions affect query plan? 楊新波
• 11:44   Re: how do functions affect query plan? changchao
• 19:35   Query plan good in 8.4, bad in 9.2 and better in 9.3 Scott Marlowe
• 19:52   Re: Query plan good in 8.4, bad in 9.2 and better in 9.3 Tom Lane
• 19:54   Re: Query plan good in 8.4, bad in 9.2 and better in 9.3 Jeff Janes

16 May 2014

• 02:27   Re: Stats collector constant I/O Tomas Vondra
• 05:38   same query different execution plan (hash join vs. semi-hash join) Huang, Suya
• 05:58   Re: same query different execution plan (hash join vs. semi-hash join) Tom Lane

19 May 2014

• 03:35   autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
• 06:56   Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
• 07:47   View has different query plan than select statement Geoff Hull
• 09:14   Re: same query different execution plan (hash join vs. semi-hash join) Huang, Suya
• 10:19   Re: View has different query plan than select statement David Rowley
• 17:22   Re: same query different execution plan (hash join vs. semi-hash join) Tom Lane
• 17:50   Re: Query plan good in 8.4, bad in 9.2 and better in 9.3 Scott Marlowe

20 May 2014

• 07:13   Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 Tom Lane

21 May 2014

• 02:06   Re: View has different query plan than select statement Geoff Hull

22 May 2014

• 16:27   Profiling PostgreSQL Dimitris Karampinas
• 16:34   Re: Profiling PostgreSQL David Boreham
• 16:48   Re: Profiling PostgreSQL Tom Lane

23 May 2014

• 02:39   Re: Profiling PostgreSQL Michael Paquier
• 03:16   Re: same query different execution plan (hash join vs. semi-hash join) Huang, Suya
• 17:40   Re: Profiling PostgreSQL Dimitris Karampinas
• 18:13   Re: Profiling PostgreSQL Pavel Stehule
• 19:52   Re: Profiling PostgreSQL Jeff Janes
• 20:25   Re: Profiling PostgreSQL Dimitris Karampinas
• 20:57   Re: Profiling PostgreSQL Jeff Janes

25 May 2014

• 19:26   Re: Profiling PostgreSQL Dimitris Karampinas

26 May 2014

• 01:45   Re: Profiling PostgreSQL Matheus de Oliveira

27 May 2014

• 14:06   NFS, file system cache and shared_buffers Albe Laurenz
• 15:27   Re: NFS, file system cache and shared_buffers Heikki Linnakangas
• 17:40   Re: NFS, file system cache and shared_buffers Stephen Frost
• 18:00   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 18:09   Re: NFS, file system cache and shared_buffers Shaun Thomas
• 18:18   Re: NFS, file system cache and shared_buffers David Boreham
• 18:32   Re: NFS, file system cache and shared_buffers Jeff Janes
• 19:54   Re: NFS, file system cache and shared_buffers Jeff Janes

28 May 2014

• 00:09   Planner doesn't take indexes into account Grzegorz Olszewski
• 00:14   Re: Planner doesn't take indexes into account AI Rumman
• 10:50   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 11:41   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 12:59   Re: Planner doesn't take indexes into account Grzegorz Olszewski
• 13:23   Re: Planner doesn't take indexes into account Heikki Linnakangas
• 16:31   Re: Planner doesn't take indexes into account Shaun Thomas
• 23:27   Re: NFS, file system cache and shared_buffers John Melesky

29 May 2014

• 00:03   Re: Planner doesn't take indexes into account Grzegorz Olszewski
• 03:36   Re: NFS, file system cache and shared_buffers Josh Berkus

30 May 2014

• 10:12   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 17:55   SELECT outage in semop Сурен Арустамян
• 18:01   Re: SELECT outage in semop Сурен Арустамян
• 18:19   Re: SELECT outage in semop Albe Laurenz

31 May 2014

• 12:03   Re[2]: [PERFORM] SELECT outage in semop Suren Arustamyan