pgsql-performance - January 2008

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 31

Jan. 2, 2008

Thread Author Time
Re: [GENERAL] Can't make backup Sebastián Baioni 12:24

Jan. 3, 2008

Thread Author Time
Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 11:50
Commit takes a long time. Peter Childs 14:35
Re: Commit takes a long time. Pavel Stehule 16:20
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Sven Geisler 16:27
Re: Commit takes a long time. Tom Lane 16:35
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 16:59
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 17:37
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 17:51
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera 18:31
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 19:26

Jan. 4, 2008

Thread Author Time
Re: Commit takes a long time. Peter Childs 08:46
Re: Commit takes a long time. Simon Riggs 10:17
Re: Linux/PostgreSQL scalability issue - problem with 8 cores James Mansion 20:46
Re: Linux/PostgreSQL scalability issue - problem with 8 cores David Boreham 20:55

Jan. 6, 2008

Thread Author Time
concurrent inserts into two separate tables are very slow Sergei Shelukhin 03:00

Jan. 7, 2008

Thread Author Time
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 11:00
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera 15:12
Re: concurrent inserts into two separate tables are very slow Scott Marlowe 22:17
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 22:31
Re: concurrent inserts into two separate tables are very slow Sergei Shelukhin 22:49
Re: concurrent inserts into two separate tables are very slow Scott Marlowe 23:08

Jan. 8, 2008

Thread Author Time
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 00:01
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 00:54
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 12:19
Loss of cache when persistent connexion is closed Guillaume Pungeot 15:35
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 17:25

Jan. 9, 2008

Thread Author Time
Re: Loss of cache when persistent connexion is closed Tom Lane 00:05
Performance of aggregates over set-returning functions John Smith 02:21
Re: Performance of aggregates over set-returning functions Tom Lane 03:07
Re: Performance of aggregates over set-returning functions John Smith 03:33
Re: Performance of aggregates over set-returning functions Tom Lane 03:51
After Vacuum Analyse - Procedure performance not improved - Innner select is faster Anoo Sivadasan Pillai 04:03
Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster Alvaro Herrera 05:06
Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Anoo Sivadasan Pillai 06:00
big database performance Adrian Moisey 08:18
Re: big database performance Joshua D. Drake 08:27
Re: big database performance Frank Habermann 08:42
Search for fixed set of keywords Jörg Kiegeland 10:43
Re: Search for fixed set of keywords Oleg Bartunov 10:55
Re: big database performance Adrian Moisey 12:53
Re: big database performance Alan Hodgson 16:16
Re: big database performance Joshua D. Drake 16:50
Re: big database performance Guillaume Smet 16:59
Re: big database performance Jared Mauch 17:42
Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Erik Jones 18:06
Re: big database performance Greg Smith 18:44
Re: big database performance Simon Riggs 21:01

Jan. 10, 2008

Thread Author Time
Re: big database performance Adrian Moisey 08:45
Re: big database performance Adrian Moisey 08:57
Re: Search for fixed set of keywords Jörg Kiegeland 09:23
Re: big database performance Stephane Bailliez 11:08
Re: Search for fixed set of keywords Oleg Bartunov 12:05
Re: big database performance Jared Mauch 14:21
Re: big database performance Jared Mauch 14:34
not exists clause S Golly 20:15
Re: not exists clause Josh Berkus 21:50
Best way to index IP data? Kevin Kempter 23:14
Re: Best way to index IP data? Joshua D. Drake 23:22
Re: Best way to index IP data? Steve Atkins 23:25
Re: Best way to index IP data? Jonah H. Harris 23:41

Jan. 11, 2008

Thread Author Time
Re: not exists clause Guy Rouillier 04:00
Re: Best way to index IP data? Pomarede Nicolas 09:31
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 11:11
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 15:05
Re: Best way to index IP data? Tom Lane 15:19
Re: Best way to index IP data? Andrew Sullivan 15:37
Re: Best way to index IP data? Pomarede Nicolas 15:55
Re: Best way to index IP data? Steve Atkins 16:11
Re: Best way to index IP data? Joshua D. Drake 16:18
Re: Best way to index IP data? Michael Stone 16:27
Evaluating boolean formula: slow performance Jörg Kiegeland 17:06
Re: Evaluating boolean formula: slow performance Jörg Kiegeland 17:42
Re: Best way to index IP data? Tom Lane 20:07
Re: Best way to index IP data? D'Arcy J.M. Cain 20:19
Re: Best way to index IP data? Michael Stone 21:27
Re: Best way to index IP data? Michael Stone 21:32
Re: Best way to index IP data? Alvaro Herrera 21:37
Re: Best way to index IP data? Michael Stone 21:40
Re: Best way to index IP data? Michael Stone 22:02
Re: Best way to index IP data? Andrew Sullivan 22:24
Re: Best way to index IP data? Steve Atkins 22:38
Re: Best way to index IP data? Pomarede Nicolas 22:43
Re: Best way to index IP data? Andrew Sullivan 23:00
Re: Best way to index IP data? Steve Atkins 23:37
Re: Best way to index IP data? Joshua D. Drake 23:52
Re: Best way to index IP data? Steve Atkins 23:55

Jan. 12, 2008

Thread Author Time
Re: Best way to index IP data? Michael Stone 00:11
Re: Best way to index IP data? Tom Lane 00:19
Re: Best way to index IP data? Michael Stone 00:21
Re: Best way to index IP data? Michael Stone 00:36
Re: Best way to index IP data? Joshua D. Drake 00:43
Re: Best way to index IP data? Tom Lane 00:51
Re: Best way to index IP data? Joshua D. Drake 00:57
Re: Best way to index IP data? Michael Stone 01:04
Re: Best way to index IP data? Michael Stone 01:07
Simple select, but takes long time James DeMichele 01:33
Re: Best way to index IP data? Michael Stone 01:58
Re: Simple select, but takes long time Tom Lane 02:11
Re: Best way to index IP data? Greg Smith 02:56
Re: Simple select, but takes long time andrew 05:37
Re: Simple select, but takes long time Tom Lane 05:44
Re: Best way to index IP data? D'Arcy J.M. Cain 06:00
Re: Best way to index IP data? david 11:17
Inheritance, unique keys and performance Julian Scarfe 19:34
Re: Inheritance, unique keys and performance Tom Lane 20:35

Jan. 13, 2008

Thread Author Time
Re: Inheritance, unique keys and performance Julian Scarfe 09:13
Re: Inheritance, unique keys and performance Tom Lane 18:46
Re: Inheritance, unique keys and performance Julian Scarfe 19:28
Re: Inheritance, unique keys and performance Tom Lane 20:47

Jan. 14, 2008

Thread Author Time
Re: Best way to index IP data? Florian Weimer 08:27
Re: Best way to index IP data? Michael Stone 11:19
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 11:47
Re: Best way to index IP data? Florian Weimer 14:05
Re: Best way to index IP data? Michael Stone 14:12
Seq scans on indexed columns. Yannick Le Guédart 14:18
Re: Seq scans on indexed columns. Guillaume Cottenceau 14:34
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 15:22
Saving result set of SELECT to table column Patric 18:19
Re: Saving result set of SELECT to table column Ansgar -59cobalt- Wiechers 18:38
Re: Seq scans on indexed columns. Shane Ambler 19:06

Jan. 15, 2008

Thread Author Time
Re: Saving result set of SELECT to table column Robins Tharakan 03:30
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 12:09
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Adrian Moisey 12:26
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 15:20
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 15:45
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 15:51
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane 16:26
Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Doug Knight 17:05
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka 17:06

Jan. 16, 2008

Thread Author Time
strange pauses Adrian Moisey 10:42
Re: strange pauses Richard Huxton 10:50
Re: strange pauses Tom Lane 15:23
Re: strange pauses Scott Marlowe 15:30
Re: strange pauses Greg Smith 15:37

Jan. 17, 2008

Thread Author Time
Re: strange pauses Adrian Moisey 06:50
Re: strange pauses Brian Herlihy 09:16
Re: strange pauses Scott Marlowe 13:44
[OT] RAID controllers blocking one another? Sean Davis 20:17
Re: [OT] RAID controllers blocking one another? Scott Marlowe 21:07
Re: [OT] RAID controllers blocking one another? Greg Smith 23:23
Re: [OT] RAID controllers blocking one another? Steinar H. Gunderson 23:30

Jan. 18, 2008

Thread Author Time
Re: strange pauses Adrian Moisey 10:58
Re: strange pauses Adrian Moisey 12:03
Re: strange pauses Alvaro Herrera 12:41
Re: [OT] RAID controllers blocking one another? Sean Davis 13:03
Re: strange pauses Scott Marlowe 15:36
Re: [OT] RAID controllers blocking one another? Greg Smith 19:14
Re: [OT] RAID controllers blocking one another? Sean Davis 19:35
Re: Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Kevin Grittner 22:50

Jan. 19, 2008

Thread Author Time
Re: [OT] RAID controllers blocking one another? david 17:31

Jan. 20, 2008

Thread Author Time
Slow set-returning functions Dean Rasheed 11:40
Re: Slow set-returning functions Heikki Linnakangas 14:34
Re: Slow set-returning functions Merlin Moncure 15:25
Re: Slow set-returning functions Dean Rasheed 17:32
Re: Slow set-returning functions Tom Lane 18:30

Jan. 21, 2008

Thread Author Time
Re: strange pauses Adrian Moisey 07:58
Slow performance with left outer join Marten Verhoeven 15:00
Re: Slow performance with left outer join Pavel Stehule 15:17
Re: Slow performance with left outer join Tom Lane 16:55
Re: Slow performance with left outer join Pavel Stehule 18:04
Re: strange pauses Decibel! 19:29
8.3 synchronous_commit Hannes Dorbath 21:55
Re: 8.3 synchronous_commit Pavel Stehule 22:11
Re: 8.3 synchronous_commit Jeff Davis 22:25
Re: 8.3 synchronous_commit Greg Smith 23:31
Re: 8.3 synchronous_commit Jeff Davis 23:45

Jan. 22, 2008

Thread Author Time
Re: 8.3 synchronous_commit Greg Smith 00:26
Re: 8.3 synchronous_commit Fernando Ike 00:48
scheduler Adrian Moisey 07:00
Re: scheduler Claus Guttesen 08:10
Re: scheduler Adrian Moisey 08:27
Re: 8.3 synchronous_commit Florian Weimer 08:32
Re: scheduler david 08:37
Re: scheduler Luke Lonergan 08:45
Re: 8.3 synchronous_commit Guillaume Smet 08:49
Re: 8.3 synchronous_commit Florian Weimer 08:56
Re: 8.3 synchronous_commit Hannes Dorbath 11:56
Re: 8.3 synchronous_commit Hannes Dorbath 12:13
Optimizing queries that use temporary tables Luiz K. Matsumura 19:32
Re: SELECT * FROM table is too slow Luiz K. Matsumura 19:44
Re: SELECT * FROM table is too slow Joshua D. Drake 20:19
Re: Optimizing queries that use temporary tables Scott Marlowe 20:34

Jan. 23, 2008

Thread Author Time
Workaround for cross column stats dependency Guillaume Smet 00:57
Re: Workaround for cross column stats dependency Tom Lane 01:43
Re: Workaround for cross column stats dependency Guillaume Smet 02:02
Making the most of memory? Joshua Fielek 04:11
Re: Making the most of memory? Scott Marlowe 05:20
Re: SELECT * FROM table is too slow Guillaume Cottenceau 08:47
Re: Workaround for cross column stats dependency Guillaume Smet 09:05
*_cost recommendation with 8.3 and a fully cached db Guillaume Smet 12:36
planner chooses unoptimal plan on joins with complex key Dmitry Potapov 13:48
Re: planner chooses unoptimal plan on joins with complex key Guillaume Smet 13:58
Re: Making the most of memory? Bill Moran 14:59
Re: planner chooses unoptimal plan on joins with complex key Tom Lane 17:17
Postgres 8.2 memory weirdness Tory M Blue 18:23
Vacuum and FSM page size Thomas Lozza 18:29
Re: Making the most of memory? Scott Marlowe 18:44
Re: Vacuum and FSM page size Decibel! 19:02
Re: Making the most of memory? Rich 19:06

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 31