Postgres Performance Date Index
[Prev Page][Next Page]
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Re: Postgres benchmarking with pgbench
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Need help with one query
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Extremely slow intarray index creation and inserts.
- Re: Extremely slow intarray index creation and inserts.
- Re: Extremely slow intarray index creation and inserts.
- Re: Prepared statement does not exist
- Prepared statement does not exist
- Re: Extremely slow intarray index creation and inserts.
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Extremely slow intarray index creation and inserts.
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Extremely slow intarray index creation and inserts.
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Performance of archive logging in a PITR restore
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Extremely slow intarray index creation and inserts.
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
- parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Extremely slow intarray index creation and inserts.
- Extremely slow intarray index creation and inserts.
- Confused ! when insert with Preimary key, Freebsd 7.1 is slower thrice times then Debian5
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Re: High CPU Utilization
- Re: Postgres benchmarking with pgbench
- Re: High CPU Utilization
- Re: High CPU Utilization
- Re: Postgres benchmarking with pgbench
- Re: High CPU Utilization
- Re: High CPU Utilization
- Re: High CPU Utilization
- Re: High CPU Utilization
- Re: High CPU Utilization
- Re: Proposal of tunable fix for scalability of 8.4
- Re: [ADMIN] deployment query
- High CPU Utilization
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Performance of archive logging in a PITR restore
- Performance of archive logging in a PITR restore
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Postgres benchmarking with pgbench
- Postgres benchmarking with pgbench
- deployment query
- From: Nagalingam, Karthikeyan
- Re: Query much slower when run from postgres function
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Query performance over a large proportion of data
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Query performance over a large proportion of data
- Re: Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Hash Join performance
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Hash Join performance
- Re: Hash Join performance
- Re: Hash Join performance
- Hash Join performance
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: Full statement logging problematic on larger machines?
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Entry point for Postgresql Performance
- From: Rajesh Kumar Mallah
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- From: Grzegorz Jaśkiewicz
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: Full statement logging problematic on larger machines?
- Re: Entry point for Postgresql Performance
- Entry point for Postgresql Performance
- From: Nagalingam, Karthikeyan
- Re: Full statement logging problematic on larger machines?
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: Full statement logging problematic on larger machines?
- Re: Proposal of tunable fix for scalability of 8.4
- Proposal of tunable fix for scalability of 8.4
- Re: Full statement logging problematic on larger machines?
- Re: random_page_cost vs ssd?
- Re: Full statement logging problematic on larger machines?
- Re: random_page_cost vs ssd?
- Re: random_page_cost vs ssd?
- From: hubert depesz lubaczewski
- Re: random_page_cost vs ssd?
- Full statement logging problematic on larger machines?
- Re: random_page_cost vs ssd?
- Re: random_page_cost vs ssd?
- Re: random_page_cost vs ssd?
- From: Grzegorz Jaśkiewicz
- random_page_cost vs ssd?
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Re: Query performance over a large proportion of data
- Query performance over a large proportion of data
- Re: When does sequential performance matter in PG?
- Re: When does sequential performance matter in PG?
- Re: Query much slower when run from postgres function
- Re: When does sequential performance matter in PG?
- Re: Query much slower when run from postgres function
- Re: When does sequential performance matter in PG?
- When does sequential performance matter in PG?
- Re: [JDBC] Query much slower when run from postgres function
- Re: DBT Presentation Location?
- Re: Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: [JDBC] Query much slower when run from postgres function
- Re: Query much slower when run from postgres function
- From: Guillaume Cottenceau
- Re: Query much slower when run from postgres function
- DBT Presentation Location?
- Query much slower when run from postgres function
- Re: Postgres 8.3, four times slower queries?
- Re: Index scan plan estimates way off.
- Re: Index scan plan estimates way off.
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: Index scan plan estimates way off.
- Re: Postgres 8.3, four times slower queries?
- Index scan plan estimates way off.
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: Postgres 8.3, four times slower queries?
- Re: work_mem in high transaction rate database
- Re: work_mem in high transaction rate database
- Long Running Commits
- Re: work_mem in high transaction rate database
- From: Flavio Henrique Araque Gurgel
- Re: work_mem in high transaction rate database
- Re: work_mem in high transaction rate database
- Re: work_mem in high transaction rate database
- work_mem in high transaction rate database
- From: Flavio Henrique Araque Gurgel
- Re: Postgres 8.3, four times slower queries?
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Postgres 8.3, four times slower queries?
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Postgres 8.3, four times slower queries?
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Postgres 8.3, four times slower queries?
- Re: Problems with ordering (can't force query planner to use an index)
- Re: Problems with ordering (can't force query planner to use an index)
- Problems with ordering (can't force query planner to use an index)
- Substring search using "exists" with a space in the search term
- Re: Postgres 8.3, four times slower queries?
- Postgres 8.3, four times slower queries?
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: "slow" queries
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: "slow" queries
- Re: Bad plan for nested loop + limit
- Re: "slow" queries
- "slow" queries
- Re: Bad plan for nested loop + limit
- Re: Bad plan for nested loop + limit
- Re: Bad plan for nested loop + limit
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- From: Rodrigo E. De León Plicet
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: PostgreSQL block size for SSD RAID setup?
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: PostgreSQL block size for SSD RAID setup?
- Re: full text search - dictionary caching
- Re: PostgreSQL block size for SSD RAID setup?
- Re: PostgreSQL block size for SSD RAID setup?
- PostgreSQL block size for SSD RAID setup?
- full text search - dictionary caching
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: LIMIT confuses the planner
- Re: TCP network cost
- will 8.4 be able to optmize rank() windows ?
- From: Grzegorz Jaśkiewicz
- Re: planner's midjudge number of rows resulting, despite pretty obvious join
- planner's midjudge number of rows resulting, despite pretty obvious join
- From: Grzegorz Jaśkiewicz
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: postgreSQL performance 8.2.6 vs 8.3.3
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Re: Abnormal performance difference between Postgres and MySQL
- Abnormal performance difference between Postgres and MySQL
- Re: TCP network cost
- Re: postgreSQL performance 8.2.6 vs 8.3.3
- Re: TCP network cost
- Re: TCP network cost
- Re: LIMIT confuses the planner
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: LIMIT confuses the planner
- Re: LIMIT confuses the planner
- Re: LIMIT confuses the planner
- Re: LIMIT confuses the planner
- Re: LIMIT confuses the planner
- LIMIT confuses the planner
- Re: dbt-2 tuning results with postgresql-8.3.5
- Re: not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4
- Re: not in(subselect) in 8.4
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: not in(subselect) in 8.4
- Re: not in(subselect) in 8.4
- Re: not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4
- Re: Partial index usage
- Re: not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: how the hdd read speed is related to the query execution speed.
- how the hdd read speed is related to the query execution speed.
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: not in(subselect) in 8.4
- From: Rodrigo E. De León Plicet
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: postgreSQL performance 8.2.6 vs 8.3.3
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: postgreSQL performance 8.2.6 vs 8.3.3
- Re: postgreSQL performance 8.2.6 vs 8.3.3
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- postgreSQL performance 8.2.6 vs 8.3.3
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: Benchmark comparing PostgreSQL, MySQL and Oracle
- Benchmark comparing PostgreSQL, MySQL and Oracle
- Re: not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- Re: not in(subselect) in 8.4
- Re: SSD performance
- Re: not in(subselect) in 8.4
- Re: not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- not in(subselect) in 8.4
- From: Grzegorz Jaśkiewicz
- Re: TCP network cost
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Grzegorz Jaśkiewicz
- Re: TCP network cost
- Re: Call of function inside trigger much slower than explicit function call
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: Call of function inside trigger much slower than explicit function call
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: TCP network cost
- Re: Call of function inside trigger much slower than explicit function call
- Re: Query composite index range in an efficient way
- Re: TCP network cost
- Re: Call of function inside trigger much slower than explicit function call
- Re: Call of function inside trigger much slower than explicit function call
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Call of function inside trigger much slower than explicit function call
- Re: Query composite index range in an efficient way
- Re: Query composite index range in an efficient way
- Cannot interpret EXPLAIN
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: Query composite index range in an efficient way
- Re: Query composite index range in an efficient way
- Query composite index range in an efficient way
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: TCP network cost
- Re: TCP network cost
- TCP network cost
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: Partial index usage
- Re: I/O increase after upgrading to 8.3.5
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Partial index usage
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: Bad plan for nested loop + limit
- Re: Bad plan for nested loop + limit
- Bad plan for nested loop + limit
- Re: Slow queries from information schema
- Re: I/O increase after upgrading to 8.3.5
- Re: Slow queries from information schema
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Slow queries from information schema
- Retrieving data from PostgreSQL to .NET application – performance test – surprising results
- Re: scheduling autovacuum at lean hours only.
- From: Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only.
- Re: I/O increase after upgrading to 8.3.5
- Re: dissimilar drives in Raid10 , does it make difference ?
- Re: I/O increase after upgrading to 8.3.5
- Re: [HACKERS] GIST versus GIN indexes for intarrays
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: I/O increase after upgrading to 8.3.5
- Re: dissimilar drives in Raid10 , does it make difference ?
- Re: [HACKERS] GIST versus GIN indexes for intarrays
- dissimilar drives in Raid10 , does it make difference ?
- From: Rajesh Kumar Mallah
- I/O increase after upgrading to 8.3.5
- Re: GIST versus GIN indexes for intarrays
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'
- Re: GIST versus GIN indexes for intarrays
- Re: GIST versus GIN indexes for intarrays
- Re: GIST versus GIN indexes for intarrays
- GIST versus GIN indexes for intarrays
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'
- Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'
- col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'
- Re: scheduling autovacuum at lean hours only.
- From: Guillaume Cottenceau
- Re: scheduling autovacuum at lean hours only.
- From: Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only.
- Re: scheduling autovacuum at lean hours only.
- Re: scheduling autovacuum at lean hours only.
- From: Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only.
- Re: scheduling autovacuum at lean hours only.
- Re: scheduling autovacuum at lean hours only.
- From: Grzegorz Jaśkiewicz
- Re: scheduling autovacuum at lean hours only.
- Re: scheduling autovacuum at lean hours only.
- From: Rajesh Kumar Mallah
- Re: scheduling autovacuum at lean hours only.
- From: Guillaume Cottenceau
- Re: scheduling autovacuum at lean hours only.
- scheduling autovacuum at lean hours only.
- From: Rajesh Kumar Mallah
- Re: please help with the explain analyze plan
- From: Rajesh Kumar Mallah
- Re: please help with the explain analyze plan
- From: Rajesh Kumar Mallah
- Re: please help with the explain analyze plan
- please help with the explain analyze plan
- From: Rajesh Kumar Mallah
- Re: View performance degraded between 8.1 and 8.3
- View performance degraded between 8.1 and 8.3
- Re: explanation of some configs
- Re: explanation of some configs
- Re: explanation of some configs
- Re: explanation of some configs
- Re: explanation of some configs
- Re: query becomes fas on 'SET enable_hashjoin TO off;'
- From: Rajesh Kumar Mallah
- Re: query becomes fas on 'SET enable_hashjoin TO off;'
- Re: query slow only after reboot
- Re: ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521.
- From: Rajesh Kumar Mallah
- Re: query becomes fas on 'SET enable_hashjoin TO off;'
- From: Rajesh Kumar Mallah
- Re: query becomes fas on 'SET enable_hashjoin TO off;'
- ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521.
- Re: explanation of some configs
- query becomes fas on 'SET enable_hashjoin TO off;'
- From: Rajesh Kumar Mallah
- Re: query slow only after reboot
- Re: query slow only after reboot
- query slow only after reboot
- Re: explanation of some configs
- Re: explanation of some configs
- Re: explanation of some configs
- Re: Postgres not willing to use an index?
- Re: Postgres not willing to use an index?
- Re: Postgres not willing to use an index?
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- Re: inheritance, and plans
- Re: inheritance, and plans
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: explanation of some configs
- Re: explanation of some configs
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: explanation of some configs
- Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests
- Re: Getting error while running DBT2 test for PostgreSQL
- Re: explanation of some configs
- explanation of some configs
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: inheritance, and plans
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: inheritance, and plans
- Re: Postgres not willing to use an index?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Arjen van der Meijden
- inheritance, and plans
- From: Grzegorz Jaśkiewicz
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Arjen van der Meijden
- Re: Postgres not willing to use an index?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: Postgres not willing to use an index?
- Re: Postgres not willing to use an index?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: Postgres not willing to use an index?
- From: Grzegorz Jaśkiewicz
- Postgres not willing to use an index?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: Number of occurrence of characters?
- From: Grzegorz Jaśkiewicz
- Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests
- Can't locate Test/Parser/Dbt2.pm in DBT2 tests
- Re: Number of occurrence of characters?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: dbt-2 tuning results with postgresql-8.3.5
- Re: dbt-2 tuning results with postgresql-8.3.5
- Re: bitmap heap scan recheck on full text search with gin index
- bitmap heap scan recheck on full text search with gin index
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: Number of occurrence of characters?
- Re: Number of occurrence of characters?
- From: hubert depesz lubaczewski
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Number of occurrence of characters?
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Arjen van der Meijden
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
- suggestions for postgresql setup on Dell 2950 , PERC6i controller
- From: Rajesh Kumar Mallah
- Re: SSD performance
- Re: Deleting millions of rows
- Re: SSD performance
- Re: Deleting millions of rows
- Getting error while running DBT2 test for PostgreSQL
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: SSD performance
- Re: SSD performance
- Re: SSD performance
- Re: Deleting millions of rows
- Re: SSD performance
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Re: Deleting millions of rows
- Deleting millions of rows
- Re: SSD performance
- Re: Using multiple cores for index creation?
- Re: Poor plan choice in prepared statement
- Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Re: Using multiple cores for index creation?
- Re: Using multiple cores for index creation?
- Re: Sort performance
- From: Subbiah Stalin-XCGF84
- Re: Sort performance
- From: Subbiah Stalin-XCGF84
- Re: Sort performance
- Re: Sort performance
- Re: Using multiple cores for index creation?
- Re: Using multiple cores for index creation?
- Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Sort performance
- From: Subbiah Stalin-XCGF84
- Using multiple cores for index creation?
- Re: Max on union
- Re: LIKE Query performance
- Re: LIKE Query performance
- Re: LIKE Query performance
- Max on union
- Re: NOT IN >2hrs vs EXCEPT < 2 sec.
- Re: NOT IN >2hrs vs EXCEPT < 2 sec.
- Re: NOT IN >2hrs vs EXCEPT < 2 sec.
- Re: NOT IN >2hrs vs EXCEPT < 2 sec.
- Re: NOT IN >2hrs vs EXCEPT < 2 sec.
- NOT IN >2hrs vs EXCEPT < 2 sec.
- Re: [PERFORMANCE] Buying hardware
- Re: [PERFORMANCE] Buying hardware
- Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Re: LIKE Query performance
- PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
- Re: LIKE Query performance
- Re: LIKE Query performance
- Need help in setting up DBT2 for PostgreSQL
- Re: LIKE Query performance
- LIKE Query performance
- Re: Odd behavior with temp usage logging
- Re: [PERFORMANCE] Buying hardware
- From: M. Edward (Ed) Borasky
- Re: [PERFORMANCE] Buying hardware
- Re: [PERFORMANCE] Buying hardware
- From: M. Edward (Ed) Borasky
- Re: [PERFORMANCE] Buying hardware
- From: M. Edward (Ed) Borasky
- Re: [PERFORMANCE] Buying hardware
- Re: Odd behavior with temp usage logging
- Odd behavior with temp usage logging
[Index of Archives]
[Postgresql General]
[Postgresql PHP]
[PHP Home]
[PHP on Windows]
[Yosemite]