Postgres Performance Date Index
[Prev Page][Next Page]
- merge join killing performance
- Re: Slow Bulk Delete
- Re: Slow Bulk Delete
- From: Grzegorz Jaśkiewicz
- Re: Slow Bulk Delete
- Re: Slow Bulk Delete
- Re: Slow Bulk Delete
- From: Grzegorz Jaśkiewicz
- Re: Slow Bulk Delete
- Re: Slow Bulk Delete
- Re: old server, new server, same performance
- Re: Slow Bulk Delete
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: Benchmark with FreeBSD 8.0 and pgbench
- pg_dump and pg_restore
- Re: Planner issue on sorting joining of two tables with limit
- Re: Benchmark with FreeBSD 8.0 and pgbench
- Re: Benchmark with FreeBSD 8.0 and pgbench
- Benchmark with FreeBSD 8.0 and pgbench
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- old server, new server, same performance
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- Re: old server, new server, same performance
- old server, new server, same performance
- Re: Performance issues when the number of records are around 10 Million
- Re: Slow Bulk Delete
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: 8K recordsize bad on ZFS?
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Re: Performance issues when the number of records are around 10 Million
- Performance issues when the number of records are around 10 Million
- Re: Slow Bulk Delete
- Re: 8K recordsize bad on ZFS?
- Slow Bulk Delete
- Re: Function scan/Index scan to nested loop
- Re: Function scan/Index scan to nested loop
- Re: Function scan/Index scan to nested loop
- Function scan/Index scan to nested loop
- Re: 8K recordsize bad on ZFS?
- Re: 8K recordsize bad on ZFS?
- Re: 8K recordsize bad on ZFS?
- Re: 8K recordsize bad on ZFS?
- Re: 8K recordsize bad on ZFS?
- Re: 8K recordsize bad on ZFS?
- Re: Dell Perc HX00 RAID controllers: What's inside?
- Re: Dell Perc HX00 RAID controllers: What's inside?
- Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?
- Re: 8K recordsize bad on ZFS?
- Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?
- Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?
- Re: Slow Bulk Delete
- 8K recordsize bad on ZFS?
- Dell Perc HX00 RAID controllers: What's inside?
- Re: debugging handle exhaustion and 15 min/ 5mil row delete
- Re: partioning tips?
- Re: Planner issue on sorting joining of two tables with limit
- Re: Planner issue on sorting joining of two tables with limit
- Re: Planner issue on sorting joining of two tables with limit
- Re: Planner issue on sorting joining of two tables with limit
- Re: debugging handle exhaustion and 15 min/ 5mil row delete
- Re: debugging handle exhaustion and 15 min/ 5mil row delete
- Re: debugging handle exhaustion and 15 min/ 5mil row delete
- debugging handle exhaustion and 15 min/ 5mil row delete
- Re: PgPool II configuration with PostgreSQL 8.4
- Re: PgPool II configuration with PostgreSQL 8.4
- Re: PgPool II configuration with PostgreSQL 8.4
- PgPool II configuration with PostgreSQL 8.4
- Re: partioning tips?
- partioning tips?
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: Optimization idea
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: Optimization idea
- Re: tmpfs and postgres memory
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: tmpfs and postgres memory
- tmpfs and postgres memory
- Re: autovacuum strategy / parameters
- Re: Planner issue on sorting joining of two tables with limit
- Planner issue on sorting joining of two tables with limit
- Re: autovacuum strategy / parameters
- Re: Optimization idea
- Re: Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- From: Grzegorz Jaśkiewicz
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Re: Optimization idea
- Re: Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Re: Optimization idea
- Re: Optimization idea
- Re: Optimization idea
- Re: Optimization idea
- Re: Optimization idea
- Re: Optimization idea
- Re: Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: autovacuum strategy / parameters
- Re: significant slow down with various LIMIT
- Re: significant slow down with various LIMIT
- autovacuum strategy / parameters
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Re: Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: Replacing Cursors with Temporary Tables
- Optimization idea
- Re: Replacing Cursors with Temporary Tables
- Re: Very high effective_cache_size == worse performance?
- Re: Replacing Cursors with Temporary Tables
- Re: [PERFORM] Dbt2 with postgres issues on CentOS-5.3
- Replacing Cursors with Temporary Tables
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: significant slow down with various LIMIT
- Re: Very high effective_cache_size == worse performance?
- Re: performance change from 8.3.1 to later releases
- Re: significant slow down with various LIMIT
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: performance change from 8.3.1 to later releases
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- performance change from 8.3.1 to later releases
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Re: Very high effective_cache_size == worse performance?
- Very high effective_cache_size == worse performance?
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Planner not using column limit specified for one column for another column equal to first
- HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: significant slow down with various LIMIT
- stats collector suddenly causing lots of IO
- [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Dbt2 with postgres issues on CentOS-5.3
- SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: stats collector suddenly causing lots of IO
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: stats collector suddenly causing lots of IO
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Re: Planner not using column limit specified for one column for another column equal to first
- Planner not using column limit specified for one column for another column equal to first
- SOLVED: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency)
- Re: stats collector suddenly causing lots of IO
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Autovaccum with cost_delay does not complete on one solaris 5.10 machine
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency)
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency)
- 8.3.9 - latency spikes with Linux (and tuning for consistently low latency)
- Re: JDBC question for PG 8.3.9
- Re: JDBC question for PG 8.3.9
- Re: Good/Bad query plans based on text criteria
- Good/Bad query plans based on text criteria
- Re: JDBC question for PG 8.3.9
- Re: Occasional giant spikes in CPU load
- JDBC question for PG 8.3.9
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: significant slow down with various LIMIT
- Re: count is ten times faster
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- From: Grzegorz Jaśkiewicz
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: stats collector suddenly causing lots of IO
- Re: "could not open relation..."
- Re: stats collector suddenly causing lots of IO
- Re: count is ten times faster
- Re: significant slow down with various LIMIT
- Re: significant slow down with various LIMIT
- stats collector suddenly causing lots of IO
- Re: significant slow down with various LIMIT
- count is ten times faster
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Re: How to diagnose a *context-switching * storm problem ?
- Re: significant slow down with various LIMIT
- Re: [PERFORM] How to diagnose a “context-switching ” storm problem ?
- Re: significant slow down with various LIMIT
- How to diagnose a “context-switching ” storm problem ?
- 答复: [PERFORM] About “context-switching issue on Xeon” test case ?
- Re: planer chooses very bad plan
- Re: Some question
- Re: significant slow down with various LIMIT
- Re: How check execution plan of a function
- Re: function performs differently with different values
- Re: significant slow down with various LIMIT
- significant slow down with various LIMIT
- From: Helio Campos Mello de Andrade
- Re: planer chooses very bad plan
- Re: significant slow down with various LIMIT
- From: Helio Campos Mello de Andrade
- Re: planer chooses very bad plan
- Re: planer chooses very bad plan
- Re: planer chooses very bad plan
- Re: planer chooses very bad plan
- Re: planer chooses very bad plan
- planer chooses very bad plan
- Re: [PERFORM] About “context-switching issue on Xeon” test case ?
- Re: Some question
- Re: "could not open relation..."
- Re: About “context-switching issue on Xeon” test case ?
- function performs differently with different values
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: [PERFORM] About “context-switching issue on Xeon” test case ?
- Re: [PERFORM] About “context-switching issue on Xeon” test case ?
- Re: "could not open relation..."
- Re: About “context-switching issue on Xeon” test case ?
- Re: significant slow down with various LIMIT
- Re: How check execution plan of a function
- Re: significant slow down with various LIMIT
- About “context-switching issue on Xeon” test case ?
- "could not open relation..."
- Re: 3ware vs. MegaRAID
- Re: 3ware vs. MegaRAID
- Re: 3ware vs. MegaRAID
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: 3ware vs. MegaRAID
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: 3ware vs. MegaRAID
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: How check execution plan of a function
- Re: 3ware vs. MegaRAID
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: 3ware vs. MegaRAID
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: significant slow down with various LIMIT
- Re: How check execution plan of a function
- Re: Query Optimization
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: How check execution plan of a function
- Re: Occasional giant spikes in CPU load
- Re: Using high speed swap to improve performance?
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- significant slow down with various LIMIT
- How check execution plan of a function
- Re: Query Optimization
- From: Kaloyan Iliev Iliev
- Query Optimization
- From: Kaloyan Iliev Iliev
- Re: PostgreSQL with Zabbix - problem of newbe
- Re: PostgreSQL with Zabbix - problem of newbe
- From: Grzegorz Jaśkiewicz
- PostgreSQL with Zabbix - problem of newbe
- Re: 3ware vs. MegaRAID
- Re: Occasional giant spikes in CPU load
- Re: 3ware vs. MegaRAID
- Re: 3ware vs. MegaRAID
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Re: Occasional giant spikes in CPU load
- Occasional giant spikes in CPU load
- Re: indexes in partitioned tables - again
- Re: query slow; strace output worrisome
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- From: Grzegorz Jaśkiewicz
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- From: Grzegorz Jaśkiewicz
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: Some question
- Re: query slow; strace output worrisome
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- indexes in partitioned tables - again
- Re: Some question
- Re: Using high speed swap to improve performance?
- Re: Some question
- Re: LIMIT causes planner to do Index Scan using a less optimal index
- Re: 3ware vs. MegaRAID
- Re: query slow; strace output worrisome
- LIMIT causes planner to do Index Scan using a less optimal index
- Re: temp table "on commit delete rows": transaction overhead
- Re: How to fast the REINDEX
- Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Re: Using high speed swap to improve performance?
- Some question
- Re: temp table "on commit delete rows": transaction overhead
- Re: Using high speed swap to improve performance?
- From: Christiaan Willemsen
- Re: query slow; strace output worrisome
- Re: query slow; strace output worrisome
- Re: query slow; strace output worrisome
- query slow; strace output worrisome
- Re: Huge table searching optimization
- Re: How to fast the REINDEX
- Re: Huge table searching optimization
- Re: Huge table searching optimization
- Re: Using high speed swap to improve performance?
- Re: Huge table searching optimization
- From: hubert depesz lubaczewski
- Huge table searching optimization
- Re: temp table "on commit delete rows": transaction overhead
- Re: Using high speed swap to improve performance?
- Re: Using high speed swap to improve performance?
- Re: Using high speed swap to improve performance?
- Re: [GENERAL] ERROR: cache lookup failed for relation X
- Re: [GENERAL] ERROR: cache lookup failed for relation X
- Re: [GENERAL] ERROR: cache lookup failed for relation X
- From: justin@xxxxxxxxxxxx
- ERROR: cache lookup failed for relation X
- Re: How much memory is PostgreSQL using
- David Crooke wants to stay in touch on LinkedIn
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
- Re: How much memory is PostgreSQL using
- Re: Using high speed swap to improve performance?
- From: Arjen van der Meijden
- Using high speed swap to improve performance?
- From: Christiaan Willemsen
- Re: Database size growing over time and leads to performance impact
- Re: Database size growing over time and leads to performance impact
- Re: Database size growing over time and leads to performance impact
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: experiments in query optimization
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: temp table "on commit delete rows": transaction overhead
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- Re: How to fast the REINDEX
- How to fast the REINDEX
- Re: Database size growing over time and leads to performance impact
- Re: Database size growing over time and leads to performance impact
- Re: Database size growing over time and leads to performance impact
- Re: query has huge variance in execution times
- Re: query has huge variance in execution times
- Re: 3ware vs. MegaRAID
- Re: experiments in query optimization
- Re: mysql to postgresql, performance questions
- Re: 3ware vs. MegaRAID
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: query has huge variance in execution times
- query has huge variance in execution times
- Re: experiments in query optimization
- Re: temp table "on commit delete rows": transaction overhead
- Re: experiments in query optimization
- Re: 3ware vs. MegaRAID
- Re: 3ware vs. MegaRAID
- Re: experiments in query optimization
- transaction overhead at "on commit delete rows";
- temp table "on commit delete rows": transaction overhead
- Re: Database size growing over time and leads to performance impact
- Re: [ADMIN] Database size growing over time and leads to performance impact
- Re: experiments in query optimization
- Re: REINDEXing database-wide daily
- Re: why does swap not recover?
- Re: Why Wal_buffer is 64KB
- Re: REINDEXing database-wide daily
- Re: Database size growing over time and leads to performance impact
- 3ware vs. MegaRAID
- Re: Database size growing over time and leads to performance impact
- Re: Performance regarding LIKE searches
- REINDEXing database-wide daily
- Re: why does swap not recover?
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: experiments in query optimization
- Re: Performance regarding LIKE searches
- Re: Performance regarding LIKE searches
- Re: Performance regarding LIKE searches
- Re: How much memory is PostgreSQL using
- Performance regarding LIKE searches
- How much memory is PostgreSQL using
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Why Wal_buffer is 64KB
- Re: Why Wal_buffer is 64KB
- Re: Why Wal_buffer is 64KB
- Re: Optimizer showing wrong rows in plan
- Re: Pgbench TPS Calculation
- Re: Database size growing over time and leads to performance impact
- Re: Forcing index scan on query produces 16x faster
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: Optimizer showing wrong rows in plan
- Re: why does swap not recover?
- Optimizer showing wrong rows in plan
- Pgbench TPS Calculation
- Re: Database size growing over time and leads to performance impact
- Re: Database size growing over time and leads to performance impact
- Database size growing over time and leads to performance impact
- Re: why does swap not recover?
- Re: why does swap not recover?
- Re: Block at a time ...
- Re: pg_dump far too slow
- Re: why does swap not recover?
- why does swap not recover?
- Re: Why Wal_buffer is 64KB
- Re: Why Wal_buffer is 64KB
- Re: Performance Tuning Large PL/PGSQL Stored Procedure
- Re: Performance Tuning Large PL/PGSQL Stored Procedure
- good effective_io_concurrency for FusionIO drives?
- Re: Performance Tuning Large PL/PGSQL Stored Procedure
- Re: Why Wal_buffer is 64KB
- Re: Performance Tuning Large PL/PGSQL Stored Procedure
- experiments in query optimization
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- tuning auto vacuum for highly active tables
- From: Bhella Paramjeet-PFCW67
- Re: Why Wal_buffer is 64KB
- Re: Why Wal_buffer is 64KB
- Re: Why Wal_buffer is 64KB
- Re: default_statistics_target
- Why Wal_buffer is 64KB
- Re: memory question
- Re: memory question
- Re: Forcing index scan on query produces 16x faster
- Re: memory question
- Re: Forcing index scan on query produces 16x faster
- memory question
- Re: Forcing index scan on query produces 16x faster
- Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: [ADMIN] tuning auto vacuum for highly active tables
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Performance Tuning Large PL/PGSQL Stored Procedure
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: Got that new server, now it's time for config!
- Re: Got that new server, now it's time for config!
- Re: Block at a time ...
- Re: Got that new server, now it's time for config!
- Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
- Got that new server, now it's time for config!
- Re: default_statistics_target
- Re: Block at a time ...
- Re: Block at a time ...
- Re: Block at a time ...
- Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
- PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
- Re: Block at a time ...
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: Building multiple indexes concurrently
- Re: Building multiple indexes concurrently
- Re: Building multiple indexes concurrently
- Re: mysql to postgresql, performance questions
- Re: GiST index performance
- Re: GiST index performance
- Re: GiST index performance
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: pgbench installation
- Re: GZIP of pre-zipped output
- Re: GZIP of pre-zipped output
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: pg_dump far too slow
- GZIP of pre-zipped output
- Re: pg_dump far too slow
- Re: pg_dump far too slow
- Re: pg_dump far too slow
- Re: pg_dump far too slow
- Re: pg_dump far too slow
- Re: mysql to postgresql, performance questions
- Re: GiST index performance
- pgbench installation
- Re: PG using index+filter instead only use index
- Re: GiST index performance
- Re: PG using index+filter instead only use index
- From: Alexandre de Arruda Paes
- Re: GiST index performance
- Re: GiST index performance
- Re: PG using index+filter instead only use index
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: Building multiple indexes concurrently
- Re: GiST index performance
- Re: too complex query plan for not exists query and multicolumn indexes
- Re: mysql to postgresql, performance questions
- PG using index+filter instead only use index
- From: Alexandre de Arruda Paes
- too complex query plan for not exists query and multicolumn indexes
- Re: shared_buffers advice
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: Forcing index scan on query produces 16x faster
- Re: Building multiple indexes concurrently
- Re: mysql to postgresql, performance questions
- From: Arjen van der Meijden
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: shared_buffers advice
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- From: Grzegorz Jaśkiewicz
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- Re: mysql to postgresql, performance questions
- mysql to postgresql, performance questions
- Re: pg_dump far too slow
- Re: shared_buffers advice
- Re: Forcing index scan on query produces 16x faster
- Re: Testing FusionIO
- Re: Forcing index scan on query produces 16x faster
- Re: Forcing index scan on query produces 16x faster
- Forcing index scan on query produces 16x faster
- Re: Building multiple indexes concurrently
- Re: Building multiple indexes concurrently
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Building multiple indexes concurrently
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Building multiple indexes concurrently
- Re: Block at a time ...
- Re: Block at a time ...
- Re: Block at a time ...
- Fwd: shared_buffers advice
- Re: Building multiple indexes concurrently
- Re: Testing FusionIO
- Re: Building multiple indexes concurrently
- Re: Block at a time ...
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Testing FusionIO
- Re: Building multiple indexes concurrently
- Re: Block at a time ...
- Re: GiST index performance
[Index of Archives]
[Postgresql General]
[Postgresql PHP]
[PHP Home]
[PHP on Windows]
[Yosemite]