Архив рассылок [pgsql-performance]

1 мая 2014 г.

• 11:28   Optimize query for listing un-read messages Andreas Joseph Krogh
• 18:35   Re: Optimize query for listing un-read messages Jochem Berndsen
• 19:19   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 19:31   Re: Optimize query for listing un-read messages Pavel Stehule
• 19:39   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 19:54   Re: Optimize query for listing un-read messages Pavel Stehule
• 20:32   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 21:03   Re: Optimize query for listing un-read messages Pavel Stehule
• 21:19   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 21:20   Re: Optimize query for listing un-read messages David G Johnston
• 21:31   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 21:34   Re: Revisiting disk layout on ZFS systems Josh Berkus
• 21:46   Re: Optimize query for listing un-read messages Tomas Vondra
• 21:58   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 22:34   Re: Optimize query for listing un-read messages Tomas Vondra
• 22:41   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 22:55   Re: Optimize query for listing un-read messages David G Johnston
• 23:51   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 23:58   Re: Optimize query for listing un-read messages David G Johnston

2 мая 2014 г.

• 00:10   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 00:18   Re: Optimize query for listing un-read messages Craig James
• 07:22   Re: Optimize query for listing un-read messages Andreas Joseph Krogh
• 17:28   Re: Optimize query for listing un-read messages Vitalii Tymchyshyn

4 мая 2014 г.

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

5 мая 2014 г.

• 21:21   Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 21:51   Re: recently and selectively slow, but very simple, update query.... David G Johnston
• 22:06   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 23:54   Re: recently and selectively slow, but very simple, update query.... David G Johnston

6 мая 2014 г.

• 09:13   Specifications for a new server Johann Spies
• 09:26   Re: Specifications for a new server DFE
• 11:07   Re: Specifications for a new server Michael Stone
• 11:15   Re: Specifications for a new server Dorian Hoxha
• 11:24   Re: Specifications for a new server Michael Stone
• 13:31   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 14:44   Re: Specifications for a new server Dorian Hoxha

7 мая 2014 г.

• 15:57   Re: Re: recently and selectively slow, but very simple, update query.... Stelios Mavromichalis
• 21:35   Re: Specifications for a new server Tomas Vondra

8 мая 2014 г.

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

12 мая 2014 г.

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

13 мая 2014 г.

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

14 мая 2014 г.

• 13:48   Re: CPU spikes and transactions Merlin Moncure
• 16:28   Re: CPU spikes and transactions Jeff Janes

15 мая 2014 г.

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

16 мая 2014 г.

• 02:38   same query different execution plan (hash join vs. semi-hash join) Huang, Suya
• 02:58   Re: same query different execution plan (hash join vs. semi-hash join) Tom Lane

19 мая 2014 г.

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

20 мая 2014 г.

• 04:13   Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 Tom Lane
• 23:06   Re: View has different query plan than select statement Geoff Hull

22 мая 2014 г.

• 13:27   Profiling PostgreSQL Dimitris Karampinas
• 13:34   Re: Profiling PostgreSQL David Boreham
• 13:48   Re: Profiling PostgreSQL Tom Lane
• 23:39   Re: Profiling PostgreSQL Michael Paquier

23 мая 2014 г.

• 00:16   Re: same query different execution plan (hash join vs. semi-hash join) Huang, Suya
• 14:40   Re: Profiling PostgreSQL Dimitris Karampinas
• 15:13   Re: Profiling PostgreSQL Pavel Stehule
• 16:52   Re: Profiling PostgreSQL Jeff Janes
• 17:25   Re: Profiling PostgreSQL Dimitris Karampinas
• 17:57   Re: Profiling PostgreSQL Jeff Janes

25 мая 2014 г.

• 16:26   Re: Profiling PostgreSQL Dimitris Karampinas
• 22:45   Re: Profiling PostgreSQL Matheus de Oliveira

27 мая 2014 г.

• 11:06   NFS, file system cache and shared_buffers Albe Laurenz
• 12:27   Re: NFS, file system cache and shared_buffers Heikki Linnakangas
• 14:40   Re: NFS, file system cache and shared_buffers Stephen Frost
• 15:00   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 15:09   Re: NFS, file system cache and shared_buffers Shaun Thomas
• 15:18   Re: NFS, file system cache and shared_buffers David Boreham
• 15:32   Re: NFS, file system cache and shared_buffers Jeff Janes
• 16:54   Re: NFS, file system cache and shared_buffers Jeff Janes
• 21:09   Planner doesn't take indexes into account Grzegorz Olszewski
• 21:14   Re: Planner doesn't take indexes into account AI Rumman

28 мая 2014 г.

• 07:50   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 08:41   Re: NFS, file system cache and shared_buffers Albe Laurenz
• 09:59   Re: Planner doesn't take indexes into account Grzegorz Olszewski
• 10:23   Re: Planner doesn't take indexes into account Heikki Linnakangas
• 13:31   Re: Planner doesn't take indexes into account Shaun Thomas
• 20:27   Re: NFS, file system cache and shared_buffers John Melesky
• 21:03   Re: Planner doesn't take indexes into account Grzegorz Olszewski

29 мая 2014 г.

• 00:36   Re: NFS, file system cache and shared_buffers Josh Berkus

30 мая 2014 г.

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

31 мая 2014 г.

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