Newsgroup:
pgsql.performance
Add New Display Options
13
replies
explain analyze reports that my queries are fast but they run very slowly
started 2012-12-27 23:10:39 UTC
2012-12-28 05:36:19 UTC
Nikolas Everett
1
reply
Improve performance for writing
started 2012-12-27 19:02:28 UTC
2012-12-27 20:45:47 UTC
Charles Gomes
4
replies
Why is PostgreSQL 9.2 slower than 9.1 in my tests?
started 2012-12-10 09:53:57 UTC
2012-12-24 04:55:32 UTC
Jeff Janes
2
replies
Slow queries after vacuum analyze
started 2012-12-14 02:42:52 UTC
2012-12-21 21:34:31 UTC
Kevin Grittner
16
replies
hash join vs nested loop join
started 2012-12-12 10:25:55 UTC
2012-12-21 03:16:35 UTC
Huan Ruan
2
replies
How can i find out top high load sql queries in PostgreSQL.
started 2012-12-17 15:21:53 UTC
2012-12-20 01:13:52 UTC
Igor Neyman
34
replies
Do I have a hardware or a software problem?
started 2012-12-11 04:52:11 UTC
2012-12-15 06:22:25 UTC
Scott Marlowe
19
replies
Why does the number of rows are different in actual and estimated.
started 2012-12-14 04:12:42 UTC
2012-12-15 04:47:50 UTC
Kevin Grittner
4
replies
Occasional timeouts on TRUNCATE and simple INSERTs
started 2012-12-12 03:19:27 UTC
2012-12-14 02:57:30 UTC
Osborn, Jeff
3
replies
encouraging index-only scans
started 2012-12-13 03:07:21 UTC
2012-12-14 00:52:37 UTC
Tom Lane
6
replies
Limit & offset effect on query plans
started 2012-12-13 10:08:42 UTC
2012-12-14 00:14:42 UTC
Kevin Grittner
5
replies
problem with large inserts
started 2012-12-13 21:37:48 UTC
2012-12-13 22:44:37 UTC
Filip Rembiałkowski
3
replies
Read rows deleted
started 2012-12-12 22:26:54 UTC
2012-12-13 02:30:32 UTC
Andrew Dunstan
21
replies
Savepoints in transactions for speed?
started 2012-11-28 04:04:52 UTC
2012-12-12 23:02:10 UTC
Jeff Janes
26
replies
Slow query: bitmap scan troubles
started 2012-12-04 21:07:04 UTC
2012-12-10 15:52:51 UTC
p***@foo.me.uk
1
reply
Perform scan on Toast table
started 2012-12-10 06:35:45 UTC
2012-12-10 14:57:25 UTC
Albe Laurenz
4
replies
Any idea on how to improve the statistics estimates for this plan?
started 2012-12-06 01:39:24 UTC
2012-12-09 01:03:33 UTC
Jeff Janes
55
replies
Two identical systems, radically different performance
started 2012-10-09 02:45:30 UTC
2012-12-06 18:53:43 UTC
Andrea Suisani
8
replies
Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance
started 2012-12-06 00:28:30 UTC
2012-12-06 14:29:57 UTC
John Lister
1
reply
CREATING INDEX on column having null values
started 2012-12-05 14:10:19 UTC
2012-12-05 14:47:55 UTC
Willem Leenen
5
replies
Comparative tps question
started 2012-11-29 00:37:41 UTC
2012-12-04 22:28:08 UTC
John Lister
36
replies
Optimize update query
started 2012-11-28 18:57:58 UTC
2012-12-03 15:37:13 UTC
Niels Kristian Schjødt
2
replies
deadlock under load
started 2012-11-30 20:34:22 UTC
2012-11-30 22:13:16 UTC
Bob Jolliffe
5
replies
9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
started 2012-11-29 17:34:00 UTC
2012-11-29 18:45:45 UTC
Pavan Deolasee
2
replies
NEED REPLICATION SOLUTION -POSTGRES 9.1
started 2012-11-29 00:12:37 UTC
2012-11-29 00:30:27 UTC
Rick Otten
7
replies
Database design - best practice
started 2012-11-28 18:41:23 UTC
2012-11-29 00:05:50 UTC
Jeff Janes
3
replies
pgsql_tmp( Temporary tablespace)
started 2012-11-28 12:45:22 UTC
2012-11-28 16:28:54 UTC
Albe Laurenz
17
replies
Hints (was Poor performance using CTE)
started 2012-11-21 07:35:48 UTC
2012-11-28 08:26:57 UTC
Scott Marlowe
4
replies
Postgres configuration for 8 CPUs, 6 GB RAM
started 2012-11-27 19:34:38 UTC
2012-11-28 06:29:15 UTC
Dave Crooke
1
reply
Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7
started 2012-11-20 13:28:23 UTC
2012-11-28 05:37:42 UTC
Merlin Moncure
Click to Load More...
Loading...