Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2010-03 Chronological Index (1/3)
Last updated: Wed Jan 18 04:13:55 2012
425 messages
31 March 2010
Re: How to fast the REINDEX Jaime Casanova (22:25)
Re: How to fast the REINDEX Kevin Grittner (22:11)
Re: How to fast the REINDEX raghavendra t (22:01)
Re: How to fast the REINDEX Kevin Grittner (21:52)
Re: How to fast the REINDEX raghavendra t (21:47)
Re: How to fast the REINDEX Kevin Grittner (21:40)
Re: How to fast the REINDEX raghavendra t (21:34)
Re: How to fast the REINDEX Kevin Grittner (21:03)
How to fast the REINDEX raghavendra t (20:51)
Re: Database size growing over time and leads to performance impact Alvaro Herrera (20:48)
Re: Database size growing over time and leads to performance impact Robert Haas (20:47)
Re: Database size growing over time and leads to performance impact Scott Carey (20:38)
Re: query has huge variance in execution times David Wilson (18:46)
Re: query has huge variance in execution times Brian Cox (18:40)
Re: 3ware vs. MegaRAID Francisco Reyes (16:59)
Re: experiments in query optimization Robert Haas (15:04)
Re: mysql to postgresql, performance questions Bruce Momjian (14:23)
Re: 3ware vs. MegaRAID Matteo Beccati (12:43)
Re: experiments in query optimization Faheem Mitha (10:11)
Re: experiments in query optimization Faheem Mitha (09:36)
Re: experiments in query optimization Matthew Wakeling (09:30)
Re: query has huge variance in execution times David Wilson (04:37)
query has huge variance in execution times Brian Cox (04:24)
30 March 2010
Re: temp table "on commit delete rows": transaction overhead Tom Lane (17:51)
Re: experiments in query optimization Faheem Mitha (17:29)
Re: 3ware vs. MegaRAID Greg Smith (17:29)
Re: 3ware vs. MegaRAID Matteo Beccati (17:17)
Re: experiments in query optimization Faheem Mitha (17:15)
Re: experiments in query optimization Kevin Grittner (16:08)
Re: REINDEXing database-wide daily Kevin Grittner (15:05)
Re: why does swap not recover? Robert Haas (14:58)
Re: Why Wal_buffer is 64KB Robert Haas (14:43)
Re: REINDEXing database-wide daily Andy Colson (14:06)
Re: Database size growing over time and leads to performance impact Andy Colson (13:50)
3ware vs. MegaRAID Ireneusz Pluta (13:21)
temp table "on commit delete rows": transaction overhead Artiom Makarov (11:46)
Re: Database size growing over time and leads to performance impact Gnanakumar (11:18)
Re: Performance regarding LIKE searches Matthew Wakeling (09:35)
REINDEXing database-wide daily Gnanakumar (09:32)
Re: why does swap not recover? Josh Berkus (06:18)
29 March 2010
Re: experiments in query optimization Robert Haas (19:56)
Re: experiments in query optimization Faheem Mitha (18:32)
Re: experiments in query optimization Robert Haas (18:02)
Re: Performance regarding LIKE searches Andy Colson (17:36)
Re: Performance regarding LIKE searches randalls (17:19)
Re: Performance regarding LIKE searches Tom Lane (17:00)
Re: How much memory is PostgreSQL using Greg Smith (16:54)
Performance regarding LIKE searches randalls (16:50)
How much memory is PostgreSQL using Campbell, Lance (15:04)
transaction overhead at "on commit delete rows"; admin(at)gifts(dot)ru (14:01)
Re: Optimizer showing wrong rows in plan Nikolas Everett (13:43)
Re: Optimizer showing wrong rows in plan raghavendra t (12:24)
Re: Optimizer showing wrong rows in plan Matthew Wakeling (11:18)
Re: Why Wal_buffer is 64KB Tadipathri Raghu (07:06)
Re: Why Wal_buffer is 64KB Scott Marlowe (06:45)
Re: Why Wal_buffer is 64KB Tadipathri Raghu (06:01)
Re: Optimizer showing wrong rows in plan Tadipathri Raghu (04:56)
Re: Pgbench TPS Calculation Greg Smith (04:23)
Re: Database size growing over time and leads to performance impact Greg Smith (04:22)
Re: Database size growing over time and leads to performance impact Greg Smith (04:13)
28 March 2010
Re: Optimizer showing wrong rows in plan Tom Lane (17:37)
Re: Optimizer showing wrong rows in plan Jeremy Harris (17:26)
Re: Optimizer showing wrong rows in plan Tom Lane (16:27)
Re: Optimizer showing wrong rows in plan Gary Doades (09:40)
Re: Optimizer showing wrong rows in plan Frank Heikens (09:18)
Re: Optimizer showing wrong rows in plan Tadipathri Raghu (09:07)
Re: Optimizer showing wrong rows in plan Tadipathri Raghu (07:34)
Re: Optimizer showing wrong rows in plan Szymon Guz (07:29)
Re: Optimizer showing wrong rows in plan Tadipathri Raghu (07:11)
Re: Optimizer showing wrong rows in plan Szymon Guz (07:02)
Re: why does swap not recover? Richard Yen (06:56)
Optimizer showing wrong rows in plan Tadipathri Raghu (06:52)
27 March 2010
Re: [ADMIN] Database size growing over time and leads to performance impact Tomeh, Husam (13:47)
Re: Database size growing over time and leads to performance impact Pierre C (13:41)
Re: Database size growing over time and leads to performance impact Andy Colson (13:35)
Database size growing over time and leads to performance impact Gnanakumar (13:05)
Re: why does swap not recover? Craig James (00:32)
Re: why does swap not recover? Scott Carey (00:29)
Re: Block at a time ... Scott Carey (00:28)
Re: pg_dump far too slow Scott Carey (00:07)
Re: why does swap not recover? Scott Marlowe (00:06)
26 March 2010
Re: Why Wal_buffer is 64KB Scott Marlowe (14:00)
Re: Why Wal_buffer is 64KB Pierre C (13:49)
Re: Performance Tuning Large PL/PGSQL Stored Procedure Richard Huxton (12:18)
Re: Performance Tuning Large PL/PGSQL Stored Procedure Merlin Moncure (12:08)
good effective_io_concurrency for FusionIO drives? Richard Yen (04:49)
Re: Performance Tuning Large PL/PGSQL Stored Procedure Eliot Gable (03:56)
Re: Why Wal_buffer is 64KB Tadipathri Raghu (03:28)
Re: Performance Tuning Large PL/PGSQL Stored Procedure Merlin Moncure (02:00)
25 March 2010
Re: mysql to postgresql, performance questions Yeb Havinga (21:25)
Re: mysql to postgresql, performance questions Scott Marlowe (20:38)
Re: mysql to postgresql, performance questions Pierre C (20:35)
Re: mysql to postgresql, performance questions Scott Marlowe (20:24)
Re: mysql to postgresql, performance questions James Mansion (20:14)
Re: Why Wal_buffer is 64KB Pierre C (18:20)
Re: Why Wal_buffer is 64KB Jaime Casanova (17:16)
Re: Why Wal_buffer is 64KB Brad Nicholson (16:05)
Re: default_statistics_target Robert Haas (15:44)
Why Wal_buffer is 64KB Tadipathri Raghu (15:01)
Re: memory question Matthew Wakeling (10:35)
Re: memory question Dave Crooke (06:28)
Re: Forcing index scan on query produces 16x faster Robert Haas (02:17)
Re: memory question Scott Marlowe (02:06)
Re: Forcing index scan on query produces 16x faster Eger, Patrick (01:17)
memory question Campbell, Lance (00:51)
Re: Forcing index scan on query produces 16x faster Robert Haas (00:47)
24 March 2010
Re: mysql to postgresql, performance questions Chris Browne (15:59)
Re: mysql to postgresql, performance questions Chris Browne (15:58)
Re: mysql to postgresql, performance questions Greg Smith (12:10)
Re: mysql to postgresql, performance questions Hannu Krosing (09:00)
Re: mysql to postgresql, performance questions Yeb Havinga (08:57)
Re: mysql to postgresql, performance questions Yeb Havinga (08:56)
Re: mysql to postgresql, performance questions Scott Marlowe (00:03)
23 March 2010
Re: mysql to postgresql, performance questions Tom Lane (23:35)
Re: mysql to postgresql, performance questions Scott Marlowe (23:31)
Re: mysql to postgresql, performance questions Dave Crooke (23:07)
Re: [ADMIN] tuning auto vacuum for highly active tables Scott Marlowe (21:42)
Re: mysql to postgresql, performance questions Ross J. Reedstrom (21:39)
Re: mysql to postgresql, performance questions Greg Smith (21:38)
tuning auto vacuum for highly active tables Bhella Paramjeet-PFCW67 (21:01)
Performance Tuning Large PL/PGSQL Stored Procedure Eliot Gable (21:00)
Re: mysql to postgresql, performance questions Scott Marlowe (20:10)
Re: mysql to postgresql, performance questions Tom Lane (19:22)
Re: mysql to postgresql, performance questions Ross J. Reedstrom (19:16)
Re: Got that new server, now it's time for config! Scott Mead (13:08)
Re: Got that new server, now it's time for config! Greg Smith (04:12)
22 March 2010
Re: Got that new server, now it's time for config! Dan Harris (23:23)
Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Eger, Patrick (23:12)
Got that new server, now it's time for config! Carlo Stonebanks (22:58)
Re: default_statistics_target Carlo Stonebanks (22:28)
Re: Block at a time ... Greg Stark (21:25)
Re: Block at a time ... Dave Crooke (21:06)
Re: Block at a time ... Pierre C (21:00)
Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Tom Lane (19:21)
PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster Christian Brink (19:09)
Re: Block at a time ... Scott Carey (18:49)
Re: mysql to postgresql, performance questions Dave Crooke (15:32)
Re: GiST index performance Matthew Wakeling (14:24)
Re: GiST index performance Yeb Havinga (14:02)
Re: GiST index performance Matthew Wakeling (13:30)
Re: too complex query plan for not exists query and multicolumn indexes Tom Lane (12:40)
Re: too complex query plan for not exists query and multicolumn indexes Matthew Wakeling (11:48)
Re: mysql to postgresql, performance questions Pierre C (11:20)
Re: mysql to postgresql, performance questions Merlin Moncure (11:15)
Re: pgbench installation Greg Smith (05:00)
Re: GZIP of pre-zipped output Scott Marlowe (03:00)
Re: GZIP of pre-zipped output Craig Ringer (02:47)
Re: mysql to postgresql, performance questions Dave Crooke (01:14)
21 March 2010
Re: pg_dump far too slow Bob Lunney (18:04)
GZIP of pre-zipped output Dave Crooke (17:04)
Re: pg_dump far too slow David Newall (15:50)
Re: pg_dump far too slow Tom Lane (15:39)
Re: pg_dump far too slow Dave Crooke (14:33)
Re: pg_dump far too slow Craig Ringer (13:57)
Re: pg_dump far too slow David Newall (13:17)
Re: mysql to postgresql, performance questions Andy Colson (03:56)
20 March 2010
pgbench installation Reydan Cankur (04:50)
Re: PG using index+filter instead only use index Tom Lane (02:16)
19 March 2010
Re: PG using index+filter instead only use index Alexandre de Arruda Paes (21:04)
Re: GiST index performance Yeb Havinga (20:49)
Re: GiST index performance Yeb Havinga (20:20)
Re: PG using index+filter instead only use index Tom Lane (19:49)
Re: too complex query plan for not exists query and multicolumn indexes Dave Crooke (19:13)
Re: too complex query plan for not exists query and multicolumn indexes Stephen Frost (18:28)
Re: mysql to postgresql, performance questions Merlin Moncure (18:21)
Re: mysql to postgresql, performance questions Pierre C (17:39)