Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-11 Chronological Index (1/2)
Last updated: Wed Jan 18 04:11:55 2012
289 messages
30 November 2011
Re: vacuum internals and performance affect Josh Berkus (21:19)
Re: Problems with FTS Robert Haas (20:58)
Re: Query planner suggestion, for indexes with similar but not exact ordering. Robert Haas (20:51)
Re: Guidance Requested - Bulk Inserting + Queries Leonardo Francalanci (16:17)
Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (15:27)
29 November 2011
Re: WAL in RAM Marcus Engene (16:59)
Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (15:40)
28 November 2011
Re: PostgreSQL 9.1 : why is this query slow? Tomas Vondra (19:32)
Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (17:37)
Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (17:32)
Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (17:23)
Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (17:05)
Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (16:58)
PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (16:42)
Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk (00:06)
27 November 2011
24 November 2011
Re: query uses index but takes too much time? Cédric Villemain (19:25)
Re: query uses index but takes too much time? Aidan Van Dyk (17:51)
query uses index but takes too much time? MirrorX (17:20)
Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Tom Lane (17:05)
Re: Seq Scan used instead of Index Scan Tom Lane (03:06)
Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk (02:57)
Re: Seq Scan used instead of Index Scan Mark Kirkwood (01:30)
23 November 2011
Seq Scan used instead of Index Scan Gary Warner (22:24)
Re: SSD endurance calculations Greg Smith (15:19)
Re: SSD options, small database, ZFS Amitabh Kant (11:34)
Re: Autovacuum Issue Raghavendra (06:11)
Autovacuum Issue J Ramesh Kumar (05:55)
22 November 2011
Re: SSD options, small database, ZFS Bruce Momjian (18:10)
Re: SSD endurance calculations Edgardo Portal (17:15)
21 November 2011
Re: Problems with FTS Rauan Maemirov (05:54)
20 November 2011
Re: external sort performance Jon Nelson (15:01)
Re: external sort performance Jeremy Harris (13:56)
19 November 2011
Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane (05:39)
18 November 2011
Re: SSD options, small database, ZFS Amitabh Kant (17:20)
Re: probably cause (and fix) for floating-point assist faults on itanium Greg Matthews (16:38)
Re: SSD options, small database, ZFS Tomas Vondra (16:31)
Re: SSD options, small database, ZFS Scott Marlowe (16:17)
Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane (16:11)
Re: probably cause (and fix) for floating-point assist faults on itanium Claudio Freire (14:22)
Re: index usage for min() vs. "order by asc limit 1" MirrorX (14:16)
Re: Benchmarking tools, methods Cédric Villemain (12:45)
Re: Benchmarking tools, methods Tomas Vondra (11:59)
Re: SSD options, small database, ZFS Greg Smith (10:09)
Benchmarking tools, methods CSS (09:56)
Re: SSD options, small database, ZFS Arjen van der Meijden (07:02)
Re: SSD options, small database, ZFS CSS (03:45)
Re: index usage for min() vs. "order by asc limit 1" Ben Chobot (01:23)
Re: index usage for min() vs. "order by asc limit 1" Steve Atkins (01:20)
index usage for min() vs. "order by asc limit 1" Ben Chobot (01:12)
probably cause (and fix) for floating-point assist faults on itanium Greg Matthews (01:08)
Re: external sort performance Josh Berkus (00:46)
Re: external sort performance Tom Lane (00:34)
17 November 2011
Re: external sort performance Jon Nelson (19:33)
Re: external sort performance Tom Lane (17:55)
Re: external sort performance Craig James (17:28)
Re: external sort performance Claudio Freire (17:17)
external sort performance Jon Nelson (17:11)
Re: Performance question 83 GB Table 150 million rows, distinct select Claudio Freire (16:56)
Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (16:06)
Re: Performance question 83 GB Table 150 million rows, distinct select Aidan Van Dyk (14:17)
Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (05:33)
Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (05:23)
Re: Performance question 83 GB Table 150 million rows, distinct select Josh Berkus (05:19)
Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (03:47)
Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (03:16)
Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (03:04)
Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (03:03)
Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (02:43)
Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (02:27)
Re: Performance question 83 GB Table 150 million rows, distinct select Andy Colson (02:11)
Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (01:59)
Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (01:58)
Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (00:45)
Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (00:00)
16 November 2011
Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (23:32)
Re: Performance question 83 GB Table 150 million rows, distinct select Alan Hodgson (23:28)
Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (22:53)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (18:17)
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (17:32)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (16:52)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (16:34)
Re: Subquery in a JOIN not getting restricted? Jay Levitt (14:06)
Re: What's the state of postgresql on ext4 now? Greg Smith (06:51)
Re: Slow queries / commits, mis-configuration or hardware issues? Greg Smith (04:27)
Re: What's the state of postgresql on ext4 now? Aidan Van Dyk (04:01)
Re: What's the state of postgresql on ext4 now? Scott Marlowe (03:55)
Re: What's the state of postgresql on ext4 now? Greg Smith (03:48)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (02:16)
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (01:23)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (00:19)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (00:13)
15 November 2011
Re: unlogged tables Josh Berkus (20:51)
Re: What's the state of postgresql on ext4 now? Josh Berkus (20:49)
Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov (15:04)
Re: Large number of short lived connections - could a connection pool help? Mario Weilguni (08:12)
Re: What's the state of postgresql on ext4 now? Maciek Sakrejda (07:41)
Re: avoiding seq scans when two columns are very correlated Stuart Bishop (07:16)
Re: Large number of short lived connections - could a connection pool help? Ben Chobot (01:06)
Re: Large number of short lived connections - could a connection pool help? Cody Caughlan (01:04)
Large number of short lived connections - could a connection pool help? Cody Caughlan (00:42)
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (00:14)
14 November 2011
Query planner suggestion, for indexes with similar but not exact ordering. Andrew Barnham (22:31)
Re: Using incrond for archiving Shaun Thomas (22:07)
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (22:06)
Re: Using incrond for archiving Kevin Grittner (21:47)
Re: Using incrond for archiving Shaun Thomas (21:41)
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (19:23)
Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (18:17)
Re: unlogged tables Kevin Grittner (17:50)
Re: unlogged tables Anibal David Acosta (17:38)
Re: unlogged tables Kevin Grittner (17:27)
Re: unlogged tables Anibal David Acosta (17:11)
Re: unlogged tables Sergey Konoplev (10:39)
Re: unlogged tables Richard Huxton (10:18)
Re: unlogged tables Sergey Konoplev (10:09)
What's the state of postgresql on ext4 now? Alexandru (10:00)
Re: unlogged tables Richard Huxton (08:58)
Re: unlogged tables Sergey Konoplev (08:11)
Re: : bg_writer overloaded ? Venkat Balaji (05:54)
13 November 2011
Re: Heavy contgnous load Pavel Stehule (09:08)
12 November 2011
Re: WAL partition filling up after high WAL activity Greg Smith (06:31)
11 November 2011
Re: unlogged tables Stephen Frost (20:18)
unlogged tables Anibal David Acosta (20:14)
Re: where clause + function, execution order Richard Huxton (16:55)
Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov (16:39)
Re: where clause + function, execution order Sorin Dudui (16:28)
Re: where clause + function, execution order Tom Lane (16:00)
Re: where clause + function, execution order Richard Huxton (16:00)
Re: where clause + function, execution order Julius Tuskenis (15:54)
where clause + function, execution order Sorin Dudui (15:38)
Re: avoiding seq scans when two columns are very correlated Tom Lane (15:36)
avoiding seq scans when two columns are very correlated Ruslan Zakirov (15:01)
Re: WAL partition filling up after high WAL activity Rafael Martinez (09:54)
10 November 2011
Re: Subquery in a JOIN not getting restricted? Tom Lane (15:23)
Re: IMMUTABLE STABLE functions, daily updates Craig Ringer (14:28)
Re: Subquery in a JOIN not getting restricted? Jay Levitt (13:52)
Re: IMMUTABLE STABLE functions, daily updates Thom Brown (13:26)
IMMUTABLE STABLE functions, daily updates Sorin Dudui (13:06)
09 November 2011
Re: Subquery in a JOIN not getting restricted? Kevin Grittner (20:20)
Re: Subquery in a JOIN not getting restricted? Merlin Moncure (19:50)
Re: Heavy contgnous load kzsolt (19:48)
Re: WAL partition filling up after high WAL activity Greg Smith (16:06)
Re: Subquery in a JOIN not getting restricted? Kevin Grittner (15:16)
Re: : bg_writer overloaded ? Scott Marlowe (14:46)
: bg_writer overloaded ? Venkat Balaji (09:25)
Re: STRICT SQL functions never inline Tom Lane (00:31)
Re: STRICT SQL functions never inline Andres Freund (00:25)
08 November 2011
Trying to understand Stats/Query planner issue Strange, John W (22:39)
Re: SSL encryption makes bytea transfer slow Albe Laurenz (13:18)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni (12:49)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra (12:40)
Re: SSL encryption makes bytea transfer slow Albe Laurenz (12:35)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (12:16)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra (11:50)
Re: SSL encryption makes bytea transfer slow Marti Raudsepp (10:52)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Lucas Mocellin (10:34)
Re: SSL encryption makes bytea transfer slow Albe Laurenz (10:25)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Sam Gendler (08:20)