Home > mailing lists

Mailing lists [pgsql-performance]

3 January 2013

00:46 Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
03:47 Re: Two Necessary Kernel Tweaks for Linux Systems Richard Neill
16:30 FW: performance issue with a 2.5gb joinded table Daniel Westermann
20:02 Re: FW: performance issue with a 2.5gb joinded table Heikki Linnakangas
21:34 Re: FW: performance issue with a 2.5gb joinded table Daniel Westermann

4 January 2013

01:54 Simple join doesn't use index Alex Vinnik
02:11 Re: Simple join doesn't use index Jeremy Harris
02:45 SMP on a heavy loaded database nobody nowhere
07:33 Re: Simple join doesn't use index Stefan Andreatta
08:14 Re: serious under-estimation of n_distinct for clustered distributions Stefan Andreatta
10:42 Re: SMP on a heavy loaded database Scott Marlowe
17:41 Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
17:47 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Charles Gomes
17:52 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire
18:56 Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
19:23 Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
19:43 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire
20:50 Re: Postgres delete performance problem dankogan
21:05 Re: Postgres delete performance problem Vitalii Tymchyshyn
22:04 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire
23:40 Re: FW: performance issue with a 2.5gb joinded table Tom Lane

5 January 2013

00:07 Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
00:20 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire
00:30 Re: FW: performance issue with a 2.5gb joinded table Daniel Westermann
00:31 Partition table in 9.0.x? AJ Weber
00:38 Re[6]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
00:53 Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire
02:02 Re: Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database Tom Lane
07:03 Re: Partition table in 9.0.x? Jeff Janes
11:37 Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere
11:53 Re[2]: [PERFORM] Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere

6 January 2013

18:27 Re: Partition table in 9.0.x? AJ Weber

7 January 2013

20:18 Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS Patrick Dung
21:10 Re: SMP on a heavy loaded database FIXED !!!! nobody nowhere
21:28 Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS ktm@rice.edu
22:22 Re: Two Necessary Kernel Tweaks for Linux Systems Merlin Moncure

8 January 2013

00:49 Forcing WAL flush james
00:55 Re: Forcing WAL flush François Beausoleil
01:05 Re: Forcing WAL flush james
02:56 Re: Forcing WAL flush Jeff Janes
03:13 Re: Simple join doesn't use index Merlin Moncure
11:30 Re: Two Necessary Kernel Tweaks for Linux Systems Andrea Suisani
18:16 Re: Two Necessary Kernel Tweaks for Linux Systems Andrea Suisani
18:26 Re: Partition table in 9.0.x? Jeff Janes
19:27 Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS Patrick Dung
19:46 Re: Partition table in 9.0.x? AJ Weber
20:21 Re: Partition table in 9.0.x? Jeff Janes
20:53 Re: Partition table in 9.0.x? Tom Lane
21:05 Re: Partition table in 9.0.x? AJ Weber
21:26 Re: Two Necessary Kernel Tweaks for Linux Systems Midge Brown
21:28 Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
21:31 Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe
21:36 Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
22:04 Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe
22:32 Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
23:06 Re: Two Necessary Kernel Tweaks for Linux Systems AJ Weber

9 January 2013

00:48 Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
02:24 Re: Two Necessary Kernel Tweaks for Linux Systems Alan Hodgson
07:34 Re: Simple join doesn't use index Jeff Janes
12:30 Re: FW: performance issue with a 2.5gb joinded table Vladimir Sitnikov
18:49 Re: Simple join doesn't use index Alex Vinnik
18:53 Re: Simple join doesn't use index Merlin Moncure

10 January 2013

11:51 Re: Two Necessary Kernel Tweaks for Linux Systems Henri Philipps
16:32 Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki
18:53 Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas
21:02 Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 PostgreSQL
21:04 Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 PostgreSQL
21:17 Re: Slow query after upgrade from 9.0 to 9.2 Jeff Janes
21:46 Partition insert trigger using C language Matheus de Oliveira
21:48 Re: Slow query after upgrade from 9.0 to 9.2 Matheus de Oliveira
21:54 Re: Partition insert trigger using C language Heikki Linnakangas
22:12 Re: Partition insert trigger using C language Matheus de Oliveira
22:15 Re: Partition insert trigger using C language Pavel Stehule
22:22 Re: Partition insert trigger using C language Heikki Linnakangas
22:48 Re: Partition insert trigger using C language Matheus de Oliveira
22:57 Re: Partition insert trigger using C language Charles Gomes

11 January 2013

11:13 Re: Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki
11:23 Re: Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki
13:19 Re: Partition insert trigger using C language Heikki Linnakangas
13:36 Re: Partition insert trigger using C language Matheus de Oliveira
13:57 Re: Partition insert trigger using C language Matheus de Oliveira
14:02 Re: Partition insert trigger using C language Heikki Linnakangas
14:55 Re: Partition insert trigger using C language Matheus de Oliveira
20:12 Re: Slow query after upgrade from 9.0 to 9.2 Jeff Janes

12 January 2013

02:55 Insert performance for large transaction with multiple COPY FROM Horst Dehmer
04:17 Insert performance for large transaction with multiple COPY FROM Jeff Janes
04:18 Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire
23:16 Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer

13 January 2013

00:23 Re: Insert performance for large transaction with multiple COPY FROM Jeff Janes
01:18 Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire
01:26 Re: Insert performance for large transaction with multiple COPY FROM Tom Lane
01:42 Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer
04:52 Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire

14 January 2013

00:49 From TODO: Simplify creation of partitioned tables Alexandre de Arruda Paes
10:35 Re: serious under-estimation of n_distinct for clustered distributions Stefan Andreatta
14:34 Re: serious under-estimation of n_distinct for clustered distributions Peter Geoghegan
17:29 Re: Two Necessary Kernel Tweaks for Linux Systems Boszormenyi Zoltan
21:24 Re: Partition table in 9.0.x? Jeff Janes

16 January 2013

02:44 Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer

17 January 2013

17:38 Re: Performance on Bulk Insert to Partitioned Table Ali Pouya
18:01 Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
19:03 Re: Performance on Bulk Insert to Partitioned Table Ali Pouya
21:12 Re: Insert performance for large transaction with multiple COPY FROM Jeff Janes

19 January 2013

02:15 Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer

21 January 2013

18:05 High CPU usage after partitioning rudi
18:29 Analyze and default_statistics_target AJ Weber
18:47 Re: Analyze and default_statistics_target Heikki Linnakangas
19:00 Re: Analyze and default_statistics_target Albe Laurenz
20:13 Re: High CPU usage after partitioning Merlin Moncure

22 January 2013

00:12 Re: High CPU usage after partitioning Kevin Grittner
03:41 Re: High CPU usage after partitioning Andrew Dunstan
16:35 Re: High CPU usage after partitioning rudi
17:04 Re: High CPU usage after partitioning Merlin Moncure
17:22 Re: High CPU usage after partitioning rudi
17:46 Re: High CPU usage after partitioning Andrew Dunstan
18:08 Re: High CPU usage after partitioning rudi
18:42 Re: High CPU usage after partitioning Igor Neyman
21:38 Re: High CPU usage after partitioning Tom Lane
23:57 Effect of the WindowAgg on the Nested Loop Виктор Егоров

23 January 2013

19:54 autovacuum fringe case? AJ Weber
22:03 Re: autovacuum fringe case? Evgeniy Shishkin
22:13 Re: autovacuum fringe case? Jeff Janes

24 January 2013

01:17 Re: autovacuum fringe case? Kevin Grittner
01:48 Re: autovacuum fringe case? AJ Weber
05:03 Re: autovacuum fringe case? Alvaro Herrera
06:06 Re: autovacuum fringe case? Jeff Janes

25 January 2013

09:38 DML's to tpcw benchmark for postgresql Sachin D. Kotwal
18:34 Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital
21:29 Re: Nested loop and simple join query - slow after upgrade to 9.2 Jeff Janes
22:30 Re: Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital

27 January 2013

03:15 PostgreSQL over internet belal hamed
05:45 Re: PostgreSQL over internet ktm@rice.edu
09:13 Re: PostgreSQL over internet Richard Neill
15:10 Re: PostgreSQL over internet belal hamed
20:33 Re: PostgreSQL over internet ktm@rice.edu
23:23 Re: PostgreSQL over internet David Rowley

28 January 2013

14:15 Re: PostgreSQL over internet belal hamed
21:54 Triggers and transactions Craig James
22:10 Re: Triggers and transactions Richard Huxton
22:25 Re: Triggers and transactions Rosser Schwarz

29 January 2013

02:43 Re: Simple join doesn't use index Alex Vinnik
03:55 Re: Simple join doesn't use index Filip Rembiałkowski
05:31 Re: Simple join doesn't use index Merlin Moncure
17:24 Re: Simple join doesn't use index Alex Vinnik
17:41 Re: Simple join doesn't use index Alex Vinnik
19:22 Re: Simple join doesn't use index Filip Rembiałkowski
19:41 Re: Simple join doesn't use index Merlin Moncure
20:39 Re: Simple join doesn't use index Ben Chobot
21:59 Re: Simple join doesn't use index Alex Vinnik
22:35 Re: Simple join doesn't use index Merlin Moncure
23:06 Re: Simple join doesn't use index Jeff Janes
23:43 Re: Simple join doesn't use index Alex Vinnik
23:48 Re: Simple join doesn't use index Alex Vinnik

30 January 2013

02:15 Re: Simple join doesn't use index Jeff Janes