Postgres Performance Date Index
[Prev Page][Next Page]
- Re: pg_dumpall affecting performance
- Re: high user cpu, massive SELECTs, no io waiting problem
- Re: pg_dumpall affecting performance
- Re: pg_dumpall affecting performance
- pg_dumpall affecting performance
- Re: high user cpu, massive SELECTs, no io waiting problem
- Re: high user cpu, massive SELECTs, no io waiting problem
- high user cpu, massive SELECTs, no io waiting problem
- Re: Checkpointing question
- Re: LIMIT on partitioned-table!?
- LIMIT on partitioned-table!?
- Checkpointing question
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: Field wise checking the performance.
- Field wise checking the performance.
- Re: performance issue in the fields.
- performance issue in the fields.
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: choosing the right RAID level for PostgresQL database
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- Re: How to boost performance of queries containing pattern matching characters
- How to boost performance of queries containing pattern matching characters
- Re: Why we don't want hints
- Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan
- Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan
- Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan
- Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan
- comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan
- Re: choosing the right RAID level for PostgresQL database
- Re: choosing the right RAID level for PostgresQL database
- Re: choosing the right RAID level for PostgresQL database
- Re: choosing the right RAID level for PostgresQL database
- Re: Why we don't want hints
- choosing the right RAID level for PostgresQL database
- Re: Why we don't want hints
- Re: Why we don't want hints
- Re: Unblock tables
- Re: Why we don't want hints Was: Slow count(*) again...
- Unblock tables
- Re: High load,
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Re: Indexes with condition using immutable functions applied to column not used
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Does auto-analyze work on dirty writes?
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Really really slow select count(*)
- Re: Bad query plan when the wrong data type is used
- Re: Query Core Dumping
- Query Core Dumping
- Re: Bad query plan when the wrong data type is used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Bad query plan when the wrong data type is used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Indexes with condition using immutable functions applied to column not used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Indexes with condition using immutable functions applied to column not used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Bad query plan when the wrong data type is used
- Re: Really really slow select count(*)
- Re: compare languages
- compare languages
- Re: Write-heavy pg_stats_collector on mostly idle server
- Re: Talking about optimizer, my long dream
- Re: Indexes with condition using immutable functions applied to column not used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Write-heavy pg_stats_collector on mostly idle server
- Indexes with condition using immutable functions applied to column not used
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Write-heavy pg_stats_collector on mostly idle server
- Re: Write-heavy pg_stats_collector on mostly idle server
- Re: Write-heavy pg_stats_collector on mostly idle server
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Different execution plans for semantically equivalent queries
- Re: Really really slow select count(*)
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: High load,
- Re: Really really slow select count(*)
- Re: Different execution plans for semantically equivalent queries
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Need some help analyzing some benchmarks
- Re: general hardware advice
- Re: Different execution plans for semantically equivalent queries
- Re: Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...)
- Re: Talking about optimizer, my long dream
- Re: Query performance with disabled hashjoin and mergejoin
- Different execution plans for semantically equivalent queries
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: general hardware advice
- Re: general hardware advice
- Re: general hardware advice
- Re: general hardware advice
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: general hardware advice
- Re: Really really slow select count(*)
- general hardware advice
- Re: copy command and blobs
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Which RAID Controllers to pick/avoid?
- Re: Really really slow select count(*)
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: checkpoint_completion_target and Ext3
- Need some help analyzing some benchmarks
- From: Benjamin Krajmalnik
- Re: Write-heavy pg_stats_collector on mostly idle server
- Re: Really really slow select count(*)
- Re: How to best use 32 15k.7 300GB drives?
- Re: [HACKERS] Slow count(*) again...
- Re: table partitioning and select max(id)
- Re: [HACKERS] Slow count(*) again...
- Re: table partitioning and select max(id)
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Talking about optimizer, my long dream
- Re: table partitioning and select max(id)
- Re: Talking about optimizer, my long dream
- Re: [HACKERS] Slow count(*) again...
- Re: table partitioning and select max(id)
- Re: Query performance with disabled hashjoin and mergejoin
- Re: Does auto-analyze work on dirty writes?
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: Talking about optimizer, my long dream
- table partitioning and select max(id)
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Re: getting the most of out multi-core systems for repeated complex SELECT statements
- checkpoint_completion_target and Ext3
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Write-heavy pg_stats_collector on mostly idle server
- Re: Really really slow select count(*)
- Re: How to best use 32 15k.7 300GB drives?
- Re: [HACKERS] Slow count(*) again...
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Really really slow select count(*)
- Fwd: Really really slow select count(*)
- Re: [HACKERS] Slow count(*) again...
- Re: Talking about optimizer, my long dream
- Re: Talking about optimizer, my long dream
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: Really really slow select count(*)
- Re: [HACKERS] Slow count(*) again...
- Re: Really really slow select count(*)
- From: hubert depesz lubaczewski
- Really really slow select count(*)
- Re: Query performance with disabled hashjoin and mergejoin
- Re: [HACKERS] Slow count(*) again...
- Re: Talking about optimizer, my long dream
- Re: [HACKERS] Slow count(*) again...
- Re: Talking about optimizer, my long dream
- Re: Talking about optimizer, my long dream
- Re: Talking about optimizer, my long dream
- Re: [HACKERS] Slow count(*) again...
- Query performance with disabled hashjoin and mergejoin
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: How to best use 32 15k.7 300GB drives?
- Re: [HACKERS] Slow count(*) again...
- Talking about optimizer, my long dream
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...)
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Why we don't want hints Was: Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Which RAID Controllers to pick/avoid?
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Exhaustive list of what takes what locks
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: FW: Queries becoming slow under heavy load
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: High load,
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: Exhaustive list of what takes what locks
- Re: FW: Queries becoming slow under heavy load
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: getting the most of out multi-core systems for repeated complex SELECT statements
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Get master-detail relationship metadata
- getting the most of out multi-core systems for repeated complex SELECT statements
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Get master-detail relationship metadata
- Re: [HACKERS] Slow count(*) again...
- Re: Which RAID Controllers to pick/avoid?
- Re: [HACKERS] Slow count(*) again...
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: [HACKERS] Slow count(*) again...
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: Which RAID Controllers to pick/avoid?
- Re: Server Configuration
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Which RAID Controllers to pick/avoid?
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Which RAID Controllers to pick/avoid?
- Re: Exhaustive list of what takes what locks
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Exhaustive list of what takes what locks
- Re: Are we in the ballpark?
- Re: Exhaustive list of what takes what locks
- [Fwd: Re: [HACKERS] Slow count(*) again...]
- Re: Server Configuration
- Re: Exhaustive list of what takes what locks
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Server Configuration
- Re: Configuration for a new server.
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Server Configuration
- Re: [HACKERS] Slow count(*) again...
- Re: Configuration for a new server.
- From: Benjamin Krajmalnik
- Re: About pg_stat_activity
- Re: [HACKERS] Slow count(*) again...
- Re: About pg_stat_activity
- Re: Are we in the ballpark?
- monitoring querys Re: About pg_stat_activity
- About pg_stat_activity
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: [HACKERS] Slow count(*) again...
- Re: Are we in the ballpark?
- Re: Configuration for a new server.
- Are we in the ballpark?
- Re: Any experience using "shake" defragmenter?
- Re: [HACKERS] Slow count(*) again...
- Re: Bloat issue on 8.3; autovac ignores HOT new pages?
- Re: Any experience using "shake" defragmenter?
- Re: Any experience using "shake" defragmenter?
- Re: Questions on query planner, join types, and work_mem
- Re: Any experience using "shake" defragmenter?
- Re: Any experience using "shake" defragmenter?
- Exhaustive list of what takes what locks
- Re: postgres 9 query performance
- Re: Configuration for a new server.
- From: Benjamin Krajmalnik
- Re: Configuration for a new server.
- From: Benjamin Krajmalnik
- Re: Any experience using "shake" defragmenter?
- Re: Configuration for a new server.
- Re: Questions on query planner, join types, and work_mem
- Configuration for a new server.
- From: Benjamin Krajmalnik
- Re: Bloat issue on 8.3; autovac ignores HOT new pages?
- Re: Bloat issue on 8.3; autovac ignores HOT new pages?
- Re: Any experience using "shake" defragmenter?
- Re: Migrating to Postgresql and new hardware
- Re: Bloat issue on 8.3; autovac ignores HOT new pages?
- Re: Any experience using "shake" defragmenter?
- Re: Any experience using "shake" defragmenter?
- Re: Any experience using "shake" defragmenter?
- Re: Any experience using "shake" defragmenter?
- Re: postgres 9 query performance
- Re: Any experience using "shake" defragmenter?
- Re: postgres 9 query performance
- Re: Any experience using "shake" defragmenter?
- Any experience using "shake" defragmenter?
- Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1
- Re: How to best use 32 15k.7 300GB drives?
- Re: postgres 9 query performance
- Re: postgres 9 query performance
- Re: Migrating to Postgresql and new hardware
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: postgres 9 query performance
- Re: postgres 9 query performance
- Re: postgres 9 query performance
- postgres 9 query performance
- Re: How to best use 32 15k.7 300GB drives?
- Re: FW: Queries becoming slow under heavy load
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: FW: Queries becoming slow under heavy load
- Re: High load,
- Re: How to best use 32 15k.7 300GB drives?
- Re: High load,
- Re: How to best use 32 15k.7 300GB drives?
- Re: High load,
- Re: FW: Queries becoming slow under heavy load
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- Re: How to best use 32 15k.7 300GB drives?
- How to best use 32 15k.7 300GB drives?
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: High load,
- From: Ing. Marcos Ortiz Valmaseda
- Re: Postgres 9.0 has a bias against indexes
- Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1
- Re: High load,
- Re: High load,
- Re: High load,
- Re: High load,
- Re: High load,
- Re: Running PostgreSQL as fast as possible no matter the consequences
- Re: High load,
- Re: Postgres 9.0 has a bias against indexes
- Re: Running PostgreSQL as fast as possible no matter the consequences
- Re: Postgres 9.0 has a bias against indexes
- Re: Real vs Int performance
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Re: Postgres 9.0 has a bias against indexes
- Postgres 9.0 has a bias against indexes
- Re: Real vs Int performance
- Re: High load,
- Re: High load,
- Re: Why I lost the last pg_xlog file?
- Re: Real vs Int performance
- Re: Real vs Int performance
- Re: Why I lost the last pg_xlog file?
- Re: Real vs Int performance
- Re: High load,
- Re: High load,
- Re: High load,
- Re: High load,
- Re: High load,
- Why I lost the last pg_xlog file?
- Re: High load,
- Re: High load,
- Re: High load,
- High load,
- Re: FW: Queries becoming slow under heavy load
- Re: FW: Queries becoming slow under heavy load
- Re: Queries becoming slow under heavy load
- Re: anti-join chosen even when slower than old plan
- Re: Real vs Int performance
- Re: Real vs Int performance
- Real vs Int performance
- Re: FW: Queries becoming slow under heavy load
- FW: Queries becoming slow under heavy load
- Re: Queries becoming slow under heavy load
- Re: Running PostgreSQL as fast as possible no matter the consequences
- Re: Queries becoming slow under heavy load
- From: Ing. Marcos Ortiz Valmaseda
- Re: Queries becoming slow under heavy load
- Re: Queries becoming slow under heavy load
- Queries becoming slow under heavy load
- Re: Bloat issue on 8.3; autovac ignores HOT page splits?
- Re: Bloat issue on 8.3; autovac ignores HOT page splits?
- Re: Bloat issue on 8.3; autovac ignores HOT page splits?
- Re: Fun little performance IMPROVEMENT...
- Re: Possible to improve query plan?
- Re: How to use indexes for GROUP BY
- Bloat issue on 8.3; autovac ignores HOT page splits?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: How to use indexes for GROUP BY
- From: hubert depesz lubaczewski
- Re: How to use indexes for GROUP BY
- Re: How to use indexes for GROUP BY
- How to use indexes for GROUP BY
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: copy command and blobs
- Re: copy command and blobs
- Re: Fun little performance IMPROVEMENT...
- Re: Fun little performance IMPROVEMENT...
- Re: Fun little performance IMPROVEMENT...
- Re: Fun little performance IMPROVEMENT...
- Re: Fun little performance IMPROVEMENT...
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Fun little performance IMPROVEMENT...
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Fun little performance IMPROVEMENT...
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Best way to get the latest revision from a table
- Re: Fun little performance IMPROVEMENT...
- Fun little performance IMPROVEMENT...
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: the XID question
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Best way to get the latest revision from a table
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: copy command and blobs
- Re: copy command and blobs
- copy command and blobs
- Re: the XID question
- Re: anti-join chosen even when slower than old plan
- Re: anti-join chosen even when slower than old plan
- Re: Migrating to Postgresql and new hardware
- Re: Running PostgreSQL as fast as possible no matter the consequences
- Re: the XID question
- Re: Migrating to Postgresql and new hardware
- Re: anti-join chosen even when slower than old plan
- Re: anti-join chosen even when slower than old plan
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: the XID question
- Re: Migrating to Postgresql and new hardware
- Re: the XID question
- Re: anti-join chosen even when slower than old plan
- Re: anti-join chosen even when slower than old plan
- Re: anti-join chosen even when slower than old plan
- Re: the XID question
- Re: the XID question
- Re: the XID question
- Re: Running PostgreSQL as fast as possible no matter the consequences
- From: Fabrízio de Royes Mello
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Running PostgreSQL as fast as possible no matter the consequences
- Re: the XID question
- Re: the XID question
- From: Filip Rembiałkowski
- Re: the XID question
- the XID question
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: hashed subplan 5000x slower than two sequential operations
- Re: Migrating to Postgresql and new hardware
- Re: Migrating to Postgresql and new hardware
- Re: hashed subplan 5000x slower than two sequential operations
- Migrating to Postgresql and new hardware
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Bad plan when join on function
- Re: The good, old times
- Re: The good, old times
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Problem with query
- Re: Possible to improve query plan?
- Re: Bad plan when join on function
- Re: Bad plan when join on function
- Re: Bad plan when join on function
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Bad plan when join on function
- Re: Possible to improve query plan?
- Re: Bad plan when join on function
- Bad plan when join on function
- Re: Possible to improve query plan?
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- From: Ing. Marcos Ortiz Valmaseda
- "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
- Re: Possible to improve query plan?
- From: Ing. Marcos Ortiz Valmaseda
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Re: Possible to improve query plan?
- Possible to improve query plan?
- Re: Possible to improve query plan?
- Possible to improve query plan?
- Re: The good, old times
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: queries with lots of UNIONed relations
- Problem with query
- Re: The good, old times
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: "COPY TO stdout" statements occurrence in log files
- Re: Best way to get the latest revision from a table
- Re: Best way to get the latest revision from a table
- Re: "COPY TO stdout" statements occurrence in log files
- Best way to get the latest revision from a table
- Re: "COPY TO stdout" statements occurrence in log files
- Re: queries with lots of UNIONed relations
- "COPY TO stdout" statements occurrence in log files
- Re: Problems with FTS
- Re: "SELECT .. WHERE NOT IN" query running for hours
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table
- Re: The good, old times
- Re: plan question - query with order by and limit not choosing index depends on size of limit, table
- Re: queries with lots of UNIONed relations
- Re: The good, old times
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
- Re: queries with lots of UNIONed relations
[Index of Archives]
[Postgresql General]
[Postgresql PHP]
[PHP Home]
[PHP on Windows]
[Yosemite]